SHOW CREATE TABLE test_ps_flag; DELETE FROM mysql.innodb_index_stats WHERE table_name = 'test_ps_flag'; DELETE FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; # must be 0, we have just deleted the rows SELECT COUNT(*) AS cnt_before FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; ANALYZE TABLE test_ps_flag; # if the table is PS enabled, then this should be 1 and 0 otherwise SELECT COUNT(*) AS cnt_after FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag';
| Name | Type | Size | Permission | Actions |
|---|---|---|---|---|
| checksum_not_strict.inc | File | 151 B | 0644 |
|
| import.inc | File | 1014 B | 0644 |
|
| innodb_dict.inc | File | 371 B | 0644 |
|
| innodb_stats.inc | File | 665 B | 0644 |
|
| innodb_stats_table_flag.inc | File | 2.33 KB | 0644 |
|
| innodb_stats_table_flag_analyze.inc | File | 508 B | 0644 |
|