1
SET @my_lru = @@global.innodb_lru_old_blocks_pct;
2
SHOW VARIABLES LIKE 'innodb_lru_old_blocks_pct';
3
SELECT * FROM DATA_DICTIONARY.INNODB_CONFIGURATION WHERE NAME='lru_old_blocks_pct';
4
SET GLOBAL innodb_lru_old_blocks_pct=20;
5
SHOW VARIABLES LIKE 'innodb_lru_old_blocks_pct';
6
SELECT * FROM DATA_DICTIONARY.INNODB_CONFIGURATION WHERE NAME='lru_old_blocks_pct';
7
SET GLOBAL innodb_lru_old_blocks_pct=200;
8
SHOW VARIABLES LIKE 'innodb_lru_old_blocks_pct';
9
SELECT * FROM DATA_DICTIONARY.INNODB_CONFIGURATION WHERE NAME='lru_old_blocks_pct';
10
SET GLOBAL innodb_lru_old_blocks_pct=95;
11
SHOW VARIABLES LIKE 'innodb_lru_old_blocks_pct';
12
SELECT * FROM DATA_DICTIONARY.INNODB_CONFIGURATION WHERE NAME='lru_old_blocks_pct';
13
SET GLOBAL innodb_lru_old_blocks_pct=5;
14
SHOW VARIABLES LIKE 'innodb_lru_old_blocks_pct';
15
SELECT * FROM DATA_DICTIONARY.INNODB_CONFIGURATION WHERE NAME='lru_old_blocks_pct';
16
SET GLOBAL innodb_lru_old_blocks_pct=@my_lru;