Debian Codegraph @

mysql-test/suite/innodb/r/log_memory_pfs.result

raw
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;