| 1 |
set @old_innodb_buffer_pool_in_core_dump = @@innodb_buffer_pool_in_core_dump; |
| 2 |
# |
| 3 |
# Confirm innodb_buffer_pool_in_core_dump works |
| 4 |
# |
| 5 |
SELECT @@global.innodb_buffer_pool_in_core_dump; |
| 6 |
@@global.innodb_buffer_pool_in_core_dump |
| 7 |
0 |
| 8 |
Buffer pool not part of core dump. |
| 9 |
# |
| 10 |
# Confirm dynamicity of innodb_buffer_pool_in_core_dump |
| 11 |
# |
| 12 |
SET GLOBAL innodb_buffer_pool_in_core_dump = ON; |
| 13 |
Buffer pool part of core dump. |
| 14 |
SET GLOBAL innodb_buffer_pool_in_core_dump = OFF; |
| 15 |
Buffer pool not part of core dump. |
| 16 |
SET GLOBAL innodb_buffer_pool_in_core_dump = ON; |
| 17 |
Buffer pool part of core dump. |
| 18 |
SET GLOBAL innodb_buffer_pool_in_core_dump = OFF; |
| 19 |
Buffer pool not part of core dump. |
| 20 |
# |
| 21 |
# Confirm innodb_pool_in_core_dump works even |
| 22 |
# after resizing of buffer pool. |
| 23 |
# |
| 24 |
set @old_innodb_buffer_pool_size = @@innodb_buffer_pool_size; |
| 25 |
set global innodb_buffer_pool_size = 64*1024*1024; |
| 26 |
Buffer pool not part of core dump. |
| 27 |
set global innodb_buffer_pool_size = 96*1024*1024; |
| 28 |
Buffer pool not part of core dump. |
| 29 |
set global innodb_buffer_pool_size = @old_innodb_buffer_pool_size; |
| 30 |
set global innodb_buffer_pool_in_core_dump = @old_innodb_buffer_pool_in_core_dump; |
| 31 |
# End of 10.11 tests |