A scheduler will call this method. When it is called the table state is marked as optimizing.
TODO we need to verify that no deletions are running before we call optimize. We should wait
if a deletion is in progress.
This restores when there is an optimization error. The error output looks like this:
mysql> optimize table JCS_STORE_FLIGHT_OPTION_ITINERARY;
+---------------------------------------------+----------+----------+---------------------+
| Table | Op | Msg_type | Msg_text |
+---------------------------------------------+----------+----------+---------------------+
| jcs_cache.JCS_STORE_FLIGHT_OPTION_ITINERARY | optimize | error | 2 when fixing table |
| jcs_cache.JCS_STORE_FLIGHT_OPTION_ITINERARY | optimize | status | Operation failed |
+---------------------------------------------+----------+----------+---------------------+
2 rows in set (51.78 sec)
A successful repair response looks like this:
mysql> REPAIR TABLE JCS_STORE_FLIGHT_OPTION_ITINERARY;
+---------------------------------------------+--------+----------+----------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+---------------------------------------------+--------+----------+----------------------------------------------+
| jcs_cache.JCS_STORE_FLIGHT_OPTION_ITINERARY | repair | error | 2 when fixing table |
| jcs_cache.JCS_STORE_FLIGHT_OPTION_ITINERARY | repair | warning | Number of rows changed from 131276 to 260461 |
| jcs_cache.JCS_STORE_FLIGHT_OPTION_ITINERARY | repair | status | OK |
+---------------------------------------------+--------+----------+----------------------------------------------+
3 rows in set (3 min 5.94 sec)
A successful optimization looks like this:
mysql> optimize table JCS_STORE_DEFAULT;
+-----------------------------+----------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+-----------------------------+----------+----------+----------+
| jcs_cache.JCS_STORE_DEFAULT | optimize | status | OK |
+-----------------------------+----------+----------+----------+
1 row in set (1.10 sec)