MySQL 5.6.14 Source Code Document
 All Classes Namespaces Files Functions Variables Typedefs Enumerations Enumerator Friends Macros Groups Pages
innodb_stats_table_flag_analyze.inc
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';