Debian Codegraph @

mysql-test/suite/sys_vars/t/transaction_prealloc_size_bug27322.test

raw
1 #
2 # test variables big
3 #
4
5 --source include/big_test.inc
6 # The test would allocate and initialize 5GB of memory
7 # if compiled with debug. It can take a lot of time
8 # of for paging/swapping.
9 --source include/not_debug.inc
10
11 #
12 # Bug#27322 failure to allocate transaction_prealloc_size causes crash
13 #
14 #
15 # Manual (6.0):
16 # Platform Bit Size Range Default
17 # 32 1024-4294967295 (4 Gi - 1) 4096
18 # 64 1024-18446744073709547520 4096
19 #
20 # Observation(mleich):
21 # 1. - Linux 64 Bit, MySQL 64 Bit, 4 GiB RAM, 8 GiB swap
22 # - SET SESSION transaction_prealloc_size=1099511627776;
23 # SHOW PROCESSLIST;
24 # Id User ... Info
25 # <Id> root ... SHOW PROCESSLIST
26 # SELECT @@session.transaction_prealloc_size;
27 # @@session.transaction_prealloc_size
28 # 1099511627776
29 # very short runtime in 5.0
30 # excessive resource consumption + long runtime in 5.1 and 6.0
31 # 2. - Win in VM, slightly older version of this test, MySQL 5.0
32 # - testcase timeout after 900s
33 # analyze-timeout-mysqld.1.err :
34 # Id User ... Time Info
35 # 83 root ... 542 set session transaction_prealloc_size=1024*1024*1024*2
36 # 84 root ... 1 SHOW PROCESSLIST
37 #
38 # There is a significant probablitity that this tests fails with testcase
39 # timeout if the testing box is not powerful enough.
40 #
41 SET @def_var= @@session.transaction_prealloc_size;
42
43 --disable_warnings
44 SET SESSION transaction_prealloc_size=1024*1024*1024*1;
45 # Embedded server is shows "cleaning up" as STATE, while non-embedded shows "init"
46 --replace_column 1 <Id> 3 <Host> 6 <Time> 7 <State>
47 --replace_result Execute Query
48 SHOW PROCESSLIST;
49 SET SESSION transaction_prealloc_size=1024*1024*1024*2;
50 --replace_column 1 <Id> 3 <Host> 6 <Time> 7 <State>
51 --replace_result Execute Query
52 SHOW PROCESSLIST;
53 SET SESSION transaction_prealloc_size=1024*1024*1024*3;
54 --replace_column 1 <Id> 3 <Host> 6 <Time> 7 <State>
55 --replace_result Execute Query
56 SHOW PROCESSLIST;
57 SET SESSION transaction_prealloc_size=1024*1024*1024*4;
58 --replace_column 1 <Id> 3 <Host> 6 <Time> 7 <State>
59 --replace_result Execute Query
60 SHOW PROCESSLIST;
61 SET SESSION transaction_prealloc_size=1024*1024*1024*5;
62 --replace_column 1 <Id> 3 <Host> 6 <Time> 7 <State>
63 --replace_result Execute Query
64 SHOW PROCESSLIST;
65 --enable_warnings
66