1
SET @my_statusfile = @@global.innodb_status_file;
2
SHOW VARIABLES LIKE 'innodb_status_file';
3
SELECT * FROM DATA_DICTIONARY.INNODB_CONFIGURATION WHERE NAME='status_file';
4
SET GLOBAL innodb_status_file=1;
5
SHOW VARIABLES LIKE 'innodb_status_file';
6
SELECT * FROM DATA_DICTIONARY.INNODB_CONFIGURATION WHERE NAME='status_file';
7
SET GLOBAL innodb_status_file=0;
8
SHOW VARIABLES LIKE 'innodb_status_file';
9
SELECT * FROM DATA_DICTIONARY.INNODB_CONFIGURATION WHERE NAME='status_file';
10
SET GLOBAL innodb_status_file=1;
11
SHOW VARIABLES LIKE 'innodb_status_file';
12
SELECT * FROM DATA_DICTIONARY.INNODB_CONFIGURATION WHERE NAME='status_file';
13
SET GLOBAL innodb_status_file=0;
14
SHOW VARIABLES LIKE 'innodb_status_file';
15
SELECT * FROM DATA_DICTIONARY.INNODB_CONFIGURATION WHERE NAME='status_file';
16
SET GLOBAL innodb_status_file=@my_statusfile;