| 1 |
DELIMITER |; |
| 2 |
CREATE PROCEDURE check_memory(IN psi_key CHAR(64)) |
| 3 |
BEGIN |
| 4 |
SELECT ROUND((SUM_NUMBER_OF_BYTES_ALLOC-SUM_NUMBER_OF_BYTES_FREE)/1024.0) |
| 5 |
FROM performance_schema.memory_summary_global_by_event_name |
| 6 |
WHERE event_name = CONCAT("memory/innodb/", psi_key); |
| 7 |
END;| |
| 8 |
DELIMITER ;| |
| 9 |
|
| 10 |
--echo # |
| 11 |
--echo # Test memory allocations related to innodb_log_buffer_size changes |
| 12 |
--echo # |
| 13 |
|
| 14 |
--let $pfs_key = 'log_buffer_memory' |
| 15 |
|
| 16 |
--let $orig_log_buffer_size = `SELECT @@innodb_log_buffer_size` |
| 17 |
--eval CALL check_memory($pfs_key) |
| 18 |
|
| 19 |
SET GLOBAL innodb_log_buffer_size = 32*1024*1024; |
| 20 |
--eval CALL check_memory($pfs_key) |
| 21 |
|
| 22 |
SET GLOBAL innodb_log_buffer_size = 64*1024*1024; |
| 23 |
--eval CALL check_memory($pfs_key) |
| 24 |
|
| 25 |
SET GLOBAL innodb_log_buffer_size = 4*1024*1024; |
| 26 |
--eval CALL check_memory($pfs_key) |
| 27 |
|
| 28 |
--eval SET GLOBAL innodb_log_buffer_size = $orig_log_buffer_size |
| 29 |
--eval CALL check_memory($pfs_key) |
| 30 |
|
| 31 |
DROP PROCEDURE check_memory; |