And in following the previous commands mentioned by fimublvetr1 in july of 2016 above, I've pasted the results below:
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> SET SESSION TOKUDB_ANALYZE_IN_BACKGROUND=1; Query OK, 0 rows affected (0.02 sec)
mysql> SET SESSION TOKUDB_ANALYZE_MODE=TOKUDB_ANALYZE_RECOUNT_ROWS; Query OK, 0 rows affected (0.00 sec)
mysql> SET SESSION TOKUDB_ANALYZE_THROTTLE=0; Query OK, 0 rows affected (0.00 sec)
mysql> ANALYZE TABLE retail.lw_item_discovery; +--------------------------+---------+----------+------------------+ | Table | Op | Msg_type | Msg_text | +--------------------------+---------+----------+------------------+ | retail.lw_item_discovery | analyze | status | Operation failed | +--------------------------+---------+----------+------------------+ 1 row in set (0.01 sec)
mysql> SET SESSION TOKUDB_ANALYZE_MODE=TOKUDB_ANALYZE_STANDARD; Query OK, 0 rows affected (0.00 sec)
mysql> SET SESSION TOKUDB_ANALYZE_TIME=0; Query OK, 0 rows affected (0.00 sec)
mysql> ANALYZE TABLE retail.lw_item_discovery;
-- I'll post the result when finished.
And in following the previous commands mentioned by fimublvetr1 in july of 2016 above, I've pasted the results below:
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> SET SESSION TOKUDB_ ANALYZE_ IN_BACKGROUND= 1;
Query OK, 0 rows affected (0.02 sec)
mysql> SET SESSION TOKUDB_ ANALYZE_ MODE=TOKUDB_ ANALYZE_ RECOUNT_ ROWS;
Query OK, 0 rows affected (0.00 sec)
mysql> SET SESSION TOKUDB_ ANALYZE_ THROTTLE= 0;
Query OK, 0 rows affected (0.00 sec)
mysql> ANALYZE TABLE retail. lw_item_ discovery; ------- ------- ------+ ------- --+---- ------+ ------- ------- ----+ ------- ------- ------+ ------- --+---- ------+ ------- ------- ----+ lw_item_ discovery | analyze | status | Operation failed | ------- ------- ------+ ------- --+---- ------+ ------- ------- ----+
+------
| Table | Op | Msg_type | Msg_text |
+------
| retail.
+------
1 row in set (0.01 sec)
mysql> SET SESSION TOKUDB_ ANALYZE_ MODE=TOKUDB_ ANALYZE_ STANDARD;
Query OK, 0 rows affected (0.00 sec)
mysql> SET SESSION TOKUDB_ ANALYZE_ THROTTLE= 0;
Query OK, 0 rows affected (0.00 sec)
mysql> SET SESSION TOKUDB_ ANALYZE_ TIME=0;
Query OK, 0 rows affected (0.00 sec)
mysql> ANALYZE TABLE retail. lw_item_ discovery;
-- I'll post the result when finished.