5
--source include/big_test.inc
8
# Bug#27322 failure to allocate transaction_prealloc_size causes crash
12
# Platform Bit Size Range Default
13
# 32 1024-4294967295 (4 Gi - 1) 4096
14
# 64 1024-18446744073709547520 4096
16
# Observation(mleich):
17
# 1. - Linux 64 Bit, MySQL 64 Bit, 4 GiB RAM, 8 GiB swap
18
# - SET SESSION transaction_prealloc_size=1099511627776;
21
# <Id> root ... SHOW PROCESSLIST
22
# SELECT @@session.transaction_prealloc_size;
23
# @@session.transaction_prealloc_size
25
# very short runtime in 5.0
26
# excessive resource consumption + long runtime in 5.1 and 6.0
27
# 2. - Win in VM, slightly older version of this test, MySQL 5.0
28
# - testcase timeout after 900s
29
# analyze-timeout-mysqld.1.err :
30
# Id User ... Time Info
31
# 83 root ... 542 set session transaction_prealloc_size=1024*1024*1024*2
32
# 84 root ... 1 SHOW PROCESSLIST
34
# There is a significant probablitity that this tests fails with testcase
35
# timeout if the testing box is not powerful enough.
39
SET SESSION transaction_prealloc_size=1024*1024*1024*1;
40
--replace_column 1 <Id> 6 <Time>
42
SET SESSION transaction_prealloc_size=1024*1024*1024*2;
43
--replace_column 1 <Id> 6 <Time>
45
SET SESSION transaction_prealloc_size=1024*1024*1024*3;
46
--replace_column 1 <Id> 6 <Time>
48
SET SESSION transaction_prealloc_size=1024*1024*1024*4;
49
--replace_column 1 <Id> 6 <Time>
51
SET SESSION transaction_prealloc_size=1024*1024*1024*5;
52
--replace_column 1 <Id> 6 <Time>