⚝
One Hat Cyber Team
⚝
Your IP:
216.73.216.124
Server IP:
50.28.103.30
Server:
Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software:
nginx/1.28.0
PHP Version:
8.3.12
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
www
/
server
/
mysql
/
mysql-test
/
suite
/
innodb
/
r
/
View File Name :
innodb_stats_flag_global_on.result
===== === Test ANALYZE behavior after default creation ===== CREATE TABLE test_ps_flag (a INT) ENGINE=INNODB; SHOW CREATE TABLE test_ps_flag; Table Create Table test_ps_flag CREATE TABLE `test_ps_flag` ( `a` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 DELETE FROM mysql.innodb_index_stats WHERE table_name = 'test_ps_flag'; DELETE FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; SELECT COUNT(*) AS cnt_before FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; cnt_before 0 ANALYZE TABLE test_ps_flag; Table Op Msg_type Msg_text test.test_ps_flag analyze status OK SELECT COUNT(*) AS cnt_after FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; cnt_after 1 DROP TABLE test_ps_flag; CREATE TABLE test_ps_flag (a INT) ENGINE=INNODB STATS_PERSISTENT=default; SHOW CREATE TABLE test_ps_flag; Table Create Table test_ps_flag CREATE TABLE `test_ps_flag` ( `a` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 DELETE FROM mysql.innodb_index_stats WHERE table_name = 'test_ps_flag'; DELETE FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; SELECT COUNT(*) AS cnt_before FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; cnt_before 0 ANALYZE TABLE test_ps_flag; Table Op Msg_type Msg_text test.test_ps_flag analyze status OK SELECT COUNT(*) AS cnt_after FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; cnt_after 1 DROP TABLE test_ps_flag; ===== === Test ANALYZE behavior after creation with explicit PS=OFF ===== CREATE TABLE test_ps_flag (a INT) ENGINE=INNODB STATS_PERSISTENT=0; SHOW CREATE TABLE test_ps_flag; Table Create Table test_ps_flag CREATE TABLE `test_ps_flag` ( `a` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 STATS_PERSISTENT=0 DELETE FROM mysql.innodb_index_stats WHERE table_name = 'test_ps_flag'; DELETE FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; SELECT COUNT(*) AS cnt_before FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; cnt_before 0 ANALYZE TABLE test_ps_flag; Table Op Msg_type Msg_text test.test_ps_flag analyze status OK SELECT COUNT(*) AS cnt_after FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; cnt_after 0 DROP TABLE test_ps_flag; ===== === Test ANALYZE behavior after creation with explicit PS=ON ===== CREATE TABLE test_ps_flag (a INT) ENGINE=INNODB STATS_PERSISTENT=1; SHOW CREATE TABLE test_ps_flag; Table Create Table test_ps_flag CREATE TABLE `test_ps_flag` ( `a` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 STATS_PERSISTENT=1 DELETE FROM mysql.innodb_index_stats WHERE table_name = 'test_ps_flag'; DELETE FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; SELECT COUNT(*) AS cnt_before FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; cnt_before 0 ANALYZE TABLE test_ps_flag; Table Op Msg_type Msg_text test.test_ps_flag analyze status OK SELECT COUNT(*) AS cnt_after FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; cnt_after 1 DROP TABLE test_ps_flag; ===== === Test ANALYZE behavior after creation with explicit PS=OFF, === then ALTER to ON, then ALTER to OFF, then ALTER to default ===== CREATE TABLE test_ps_flag (a INT) ENGINE=INNODB STATS_PERSISTENT=0; ALTER TABLE test_ps_flag STATS_PERSISTENT=1; # restart SHOW CREATE TABLE test_ps_flag; Table Create Table test_ps_flag CREATE TABLE `test_ps_flag` ( `a` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 STATS_PERSISTENT=1 DELETE FROM mysql.innodb_index_stats WHERE table_name = 'test_ps_flag'; DELETE FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; SELECT COUNT(*) AS cnt_before FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; cnt_before 0 ANALYZE TABLE test_ps_flag; Table Op Msg_type Msg_text test.test_ps_flag analyze status OK SELECT COUNT(*) AS cnt_after FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; cnt_after 1 ALTER TABLE test_ps_flag STATS_PERSISTENT=0; SHOW CREATE TABLE test_ps_flag; Table Create Table test_ps_flag CREATE TABLE `test_ps_flag` ( `a` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 STATS_PERSISTENT=0 DELETE FROM mysql.innodb_index_stats WHERE table_name = 'test_ps_flag'; DELETE FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; SELECT COUNT(*) AS cnt_before FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; cnt_before 0 ANALYZE TABLE test_ps_flag; Table Op Msg_type Msg_text test.test_ps_flag analyze status OK SELECT COUNT(*) AS cnt_after FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; cnt_after 0 ALTER TABLE test_ps_flag STATS_PERSISTENT=default; SHOW CREATE TABLE test_ps_flag; Table Create Table test_ps_flag CREATE TABLE `test_ps_flag` ( `a` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 DELETE FROM mysql.innodb_index_stats WHERE table_name = 'test_ps_flag'; DELETE FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; SELECT COUNT(*) AS cnt_before FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; cnt_before 0 ANALYZE TABLE test_ps_flag; Table Op Msg_type Msg_text test.test_ps_flag analyze status OK SELECT COUNT(*) AS cnt_after FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; cnt_after 1 DROP TABLE test_ps_flag; ===== === Test ANALYZE behavior after creation with explicit PS=ON, === then ALTER to OFF, then ALTER to ON, then ALTER to default ===== CREATE TABLE test_ps_flag (a INT) ENGINE=INNODB STATS_PERSISTENT=1; ALTER TABLE test_ps_flag STATS_PERSISTENT=0; # restart SHOW CREATE TABLE test_ps_flag; Table Create Table test_ps_flag CREATE TABLE `test_ps_flag` ( `a` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 STATS_PERSISTENT=0 DELETE FROM mysql.innodb_index_stats WHERE table_name = 'test_ps_flag'; DELETE FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; SELECT COUNT(*) AS cnt_before FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; cnt_before 0 ANALYZE TABLE test_ps_flag; Table Op Msg_type Msg_text test.test_ps_flag analyze status OK SELECT COUNT(*) AS cnt_after FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; cnt_after 0 ALTER TABLE test_ps_flag STATS_PERSISTENT=1; SHOW CREATE TABLE test_ps_flag; Table Create Table test_ps_flag CREATE TABLE `test_ps_flag` ( `a` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 STATS_PERSISTENT=1 DELETE FROM mysql.innodb_index_stats WHERE table_name = 'test_ps_flag'; DELETE FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; SELECT COUNT(*) AS cnt_before FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; cnt_before 0 ANALYZE TABLE test_ps_flag; Table Op Msg_type Msg_text test.test_ps_flag analyze status OK SELECT COUNT(*) AS cnt_after FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; cnt_after 1 ALTER TABLE test_ps_flag STATS_PERSISTENT=default; SHOW CREATE TABLE test_ps_flag; Table Create Table test_ps_flag CREATE TABLE `test_ps_flag` ( `a` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 DELETE FROM mysql.innodb_index_stats WHERE table_name = 'test_ps_flag'; DELETE FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; SELECT COUNT(*) AS cnt_before FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; cnt_before 0 ANALYZE TABLE test_ps_flag; Table Op Msg_type Msg_text test.test_ps_flag analyze status OK SELECT COUNT(*) AS cnt_after FROM mysql.innodb_table_stats WHERE table_name = 'test_ps_flag'; cnt_after 1 DROP TABLE test_ps_flag;