variables-big.test 2.15 KB
Newer Older
1 2 3 4 5 6 7
#
# test variables big
#

--source include/big_test.inc

#
unknown's avatar
unknown committed
8
# Bug#27322 failure to allocate transaction_prealloc_size causes crash
9
#
10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
#
# Manual (6.0):
# Platform Bit Size  Range                      Default
# 32                 1024-4294967295 (4 Gi - 1) 4096
# 64                 1024-18446744073709547520  4096
#
# Observation(mleich):
# 1. - Linux 64 Bit, MySQL 64 Bit, 4 GiB RAM, 8 GiB swap
#    - SET SESSION transaction_prealloc_size=1099511627776;
#      SHOW PROCESSLIST;
#      Id   User ... Info
#      <Id> root ... SHOW PROCESSLIST
#      SELECT @@session.transaction_prealloc_size;
#      @@session.transaction_prealloc_size
#      1099511627776
#      very short runtime in 5.0
#      excessive resource consumption + long runtime in 5.1 and 6.0
# 2. - Win in VM, slightly older version of this test, MySQL 5.0
#    - testcase timeout after 900s
#      analyze-timeout-mysqld.1.err :
#      Id User ... Time Info
#      83 root ... 542  set session transaction_prealloc_size=1024*1024*1024*2
#      84 root ... 1    SHOW PROCESSLIST
#
# There is a significant probablitity that this tests fails with testcase
# timeout if the testing box is not powerful enough.
#
37

unknown's avatar
unknown committed
38 39 40
--disable_warnings
SET SESSION transaction_prealloc_size=1024*1024*1024*1;
--replace_column 1 <Id> 6 <Time>
41 42
# Embedded server is hardcoded to show "Writing to net" as STATE.
--replace_result "Writing to net" "NULL"
Michael Widenius's avatar
Michael Widenius committed
43
--replace_regex /localhost[:0-9]*/localhost/
unknown's avatar
unknown committed
44 45 46
SHOW PROCESSLIST;
SET SESSION transaction_prealloc_size=1024*1024*1024*2;
--replace_column 1 <Id> 6 <Time>
47
--replace_result "Writing to net" "NULL"
Michael Widenius's avatar
Michael Widenius committed
48
--replace_regex /localhost[:0-9]*/localhost/
unknown's avatar
unknown committed
49 50 51
SHOW PROCESSLIST;
SET SESSION transaction_prealloc_size=1024*1024*1024*3;
--replace_column 1 <Id> 6 <Time>
52
--replace_result "Writing to net" "NULL"
Michael Widenius's avatar
Michael Widenius committed
53
--replace_regex /localhost[:0-9]*/localhost/
unknown's avatar
unknown committed
54 55 56
SHOW PROCESSLIST;
SET SESSION transaction_prealloc_size=1024*1024*1024*4;
--replace_column 1 <Id> 6 <Time>
57
--replace_result "Writing to net" "NULL"
Michael Widenius's avatar
Michael Widenius committed
58
--replace_regex /localhost[:0-9]*/localhost/
unknown's avatar
unknown committed
59 60 61
SHOW PROCESSLIST;
SET SESSION transaction_prealloc_size=1024*1024*1024*5;
--replace_column 1 <Id> 6 <Time>
62
--replace_result "Writing to net" "NULL"
unknown's avatar
unknown committed
63 64 65
SHOW PROCESSLIST;
--enable_warnings