1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
|
set @save_innodb_stats_persistent= @@innodb_stats_persistent;
set global innodb_stats_persistent=default;
SELECT COUNT(*) FROM mysql.innodb_table_stats WHERE
database_name = 'test' AND
table_name = 'test_ps_create_table';
COUNT(*) 0
CREATE TABLE test_ps_create_table (a INT, PRIMARY KEY (a))
ENGINE=INNODB STATS_PERSISTENT=0;
SELECT COUNT(*) FROM mysql.innodb_table_stats WHERE
database_name = 'test' AND
table_name = 'test_ps_create_table';
COUNT(*) 0
DROP TABLE test_ps_create_table;
CREATE TABLE test_ps_create_table (a INT, PRIMARY KEY (a))
ENGINE=INNODB;
SELECT COUNT(*) FROM mysql.innodb_table_stats WHERE
database_name = 'test' AND
table_name = 'test_ps_create_table';
COUNT(*) 1
DROP TABLE test_ps_create_table;
CREATE TABLE test_ps_create_table (a INT, PRIMARY KEY (a))
ENGINE=INNODB STATS_PERSISTENT=default;
SELECT COUNT(*) FROM mysql.innodb_table_stats WHERE
database_name = 'test' AND
table_name = 'test_ps_create_table';
COUNT(*) 1
DROP TABLE test_ps_create_table;
CREATE TABLE test_ps_create_table (a INT, PRIMARY KEY (a))
ENGINE=INNODB STATS_PERSISTENT=1;
SELECT COUNT(*) FROM mysql.innodb_table_stats WHERE
database_name = 'test' AND
table_name = 'test_ps_create_table';
COUNT(*) 1
DROP TABLE test_ps_create_table;
set global innodb_stats_persistent= @save_innodb_stats_persistent;
|
