| 1 |
SHOW CREATE TABLE test_ps_flag; |
| 2 |
|
| 3 |
DELETE FROM mysql.innodb_index_stats WHERE table_name = 'test_ps_flag'; |
| 4 |
DELETE FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; |
| 5 |
|
| 6 |
# must be 0, we have just deleted the rows |
| 7 |
SELECT COUNT(*) AS cnt_before FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; |
| 8 |
|
| 9 |
ANALYZE TABLE test_ps_flag; |
| 10 |
|
| 11 |
# if the table is PS enabled, then this should be 1 and 0 otherwise |
| 12 |
SELECT COUNT(*) AS cnt_after FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; |