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