Debian Codegraph @

mysql-test/suite/innodb/t/log_memory_pfs.test

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