| 1 |
# Preparation for using no_checkpoint_end.inc |
| 2 |
|
| 3 |
# no_checkpoint_flush: Set to trigger flushing the dirty pages from buffer pool |
| 4 |
# and checkpoint before the "no checkpoint" block. |
| 5 |
|
| 6 |
if ($no_checkpoint_flush) { |
| 7 |
--echo |
| 8 |
--echo # Flush all dirty pages from buffer pool |
| 9 |
SET @no_checkpoint_save_pct= @@GLOBAL.innodb_max_dirty_pages_pct; |
| 10 |
SET @no_checkpoint_save_pct_lwm= @@GLOBAL.innodb_max_dirty_pages_pct_lwm; |
| 11 |
|
| 12 |
SET GLOBAL innodb_max_dirty_pages_pct_lwm=0.0; |
| 13 |
SET GLOBAL innodb_max_dirty_pages_pct=0.0; |
| 14 |
|
| 15 |
let $wait_condition = |
| 16 |
SELECT variable_value = 0 |
| 17 |
FROM information_schema.global_status |
| 18 |
WHERE variable_name = 'INNODB_BUFFER_POOL_PAGES_DIRTY'; |
| 19 |
--source include/wait_condition.inc |
| 20 |
|
| 21 |
SET GLOBAL innodb_max_dirty_pages_pct= @no_checkpoint_save_pct; |
| 22 |
SET GLOBAL innodb_max_dirty_pages_pct_lwm= @no_checkpoint_save_pct_lwm; |
| 23 |
--echo |
| 24 |
} |
| 25 |
|
| 26 |
let MYSQLD_DATADIR= `select @@datadir`; |
| 27 |
--replace_regex /.*Last checkpoint at[ ]*([0-9]+).*/\1/ |
| 28 |
let CHECKPOINT_LSN=`SHOW ENGINE INNODB STATUS`; |