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