Comment 21 for bug 1607300

Revision history for this message
Ross E Carver (recarv) wrote :

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_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.