Debian Codegraph @

mysql-test/suite/special/t/innodb_dedicated_server_gcov.test

raw
1 #####################################################################################
2 # Test for autoscaling based on innodb_dedicated_server variable. #
3 # #
4 # #
5 # This test checks autoscaling of following variables based on value of #
6 # innodb_dedicated_server option #
7 # - innodb_buffer_pool_size #
8 # - innodb_redo_log_capacity #
9 # #
10 # This test also does basic testing for new variable innodb_dedicated_server #
11 #####################################################################################
12
13 # Make sure to run only on Linux
14 --source include/linux.inc
15 # Make sure this test is not run on PB2 machines
16 --source include/is_local_machine.inc
17 # Make sure that there are no other tests running in parallel
18 --source include/not_parallel.inc
19 # Make sure UNIV_DEBUG_DEDICATED is defined and debug_sys_mem_size is available
20 let $have_debug_dedicated = `SELECT * FROM performance_schema.global_variables where VARIABLE_NAME LIKE "%debug_sys_mem_size%"`;
21 if (!$have_debug_dedicated) {
22 --skip Test requires 'debug_dedicated'
23 }
24
25 --disable_query_log
26 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* Resizing redo log");
27 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* Starting to delete and rewrite redo log files.");
28 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* New redo log files created");
29 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* Option innodb_dedicated_server is ignored ");
30 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* No argument was provided to --log-bin, and --log-bin-index was not used");
31 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* option 'innodb-buffer-pool-size': signed value");
32 --enable_query_log
33
34 ##############################################################################
35 # Autoscaling is done as per below formula: #
36 # innodb_buffer_pool_size #
37 # server_memory < 1G ? 128M (same as current default) #
38 # server_memory <= 4G ? server_memory * 0.5 #
39 # server_memory > 4G ? server_memory * 0.75 #
40 # #
41 # innodb_redo_log_capacity #
42 # buf_pool_size < 1G ? 100M (same as current default) #
43 # buf_pool_size < 8G ? ROUND(buf_pool_size * 0.5) G #
44 # buf_pool_size <= 128G ? ROUND(buf_pool_size * 0.75) G #
45 # buf_pool_size > 128G ? 128G #
46 # #
47 # Following Perl module calculates server memory and evaluates #
48 # innodb_buffer_pool_size and #
49 # innodb_redo_log_capacity #
50 # based on above formula. #
51 # #
52 # NOTE : Please build the server with UNIV_DEBUG_DEDICATED!!!!!! #
53 ##############################################################################
54
55 # Test 1: 1G
56 let $debug_sys_mem_size=1;
57 --source suite/special/t/innodb_dedicated_server_gcov.inc
58
59 # Test 2: 4G
60 let $debug_sys_mem_size=4;
61 --source suite/special/t/innodb_dedicated_server_gcov.inc
62
63 # Test 3: 16G
64 let $debug_sys_mem_size=16;
65 --source suite/special/t/innodb_dedicated_server_gcov.inc
66
67 # Test 4: 200G
68 let $debug_sys_mem_size=200;
69 --source suite/special/t/innodb_dedicated_server_gcov.inc