mysql-test/suite/sys_vars/r/innodb_buffer_pool_load_now_basic.result
raw| 1 | SET @orig = @@global.innodb_buffer_pool_load_now; |
| 2 | SELECT @orig; |
| 3 | @orig |
| 4 | 0 |
| 5 | SET GLOBAL innodb_buffer_pool_dump_now = ON; |
| 6 | SET GLOBAL innodb_fast_shutdown=0; |
| 7 | # restart |
| 8 | SET GLOBAL innodb_buffer_pool_load_now = ON; |
| 9 | SELECT variable_value |
| 10 | FROM performance_schema.global_status |
| 11 | WHERE LOWER(variable_name) = 'innodb_buffer_pool_load_status'; |
| 12 | variable_value |
| 13 | Buffer pool load completed or still running |