diff options
Diffstat (limited to 'mysql-test/t/variables-big.test')
| -rw-r--r-- | mysql-test/t/variables-big.test | 76 |
1 files changed, 0 insertions, 76 deletions
diff --git a/mysql-test/t/variables-big.test b/mysql-test/t/variables-big.test deleted file mode 100644 index 58098f4c879..00000000000 --- a/mysql-test/t/variables-big.test +++ /dev/null @@ -1,76 +0,0 @@ -# -# test variables big -# - ---source include/big_test.inc -# The test would allocate and initialize 5GB of memory -# if compiled with debug. It can take a lot of time -# of for paging/swapping. ---source include/not_debug.inc - -# -# Bug#27322 failure to allocate transaction_prealloc_size causes crash -# -# -# 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. -# -SET @def_var= @@session.transaction_prealloc_size; - ---disable_warnings -SET SESSION transaction_prealloc_size=1024*1024*1024*1; -# Embedded server is hardcoded to show "Writing to net" as STATE. ---replace_result "Writing to net" "NULL" ---replace_column 1 <Id> 3 <Host> 6 <Time> -# Embedded server is hardcoded to show "Writing to net" as STATE. ---replace_result "Writing to net" "NULL" ---replace_regex /localhost[:0-9]*/localhost/ -SHOW PROCESSLIST; -SET SESSION transaction_prealloc_size=1024*1024*1024*2; ---replace_result "Writing to net" "NULL" ---replace_column 1 <Id> 3 <Host> 6 <Time> ---replace_result "Writing to net" "NULL" ---replace_regex /localhost[:0-9]*/localhost/ -SHOW PROCESSLIST; -SET SESSION transaction_prealloc_size=1024*1024*1024*3; ---replace_result "Writing to net" "NULL" ---replace_column 1 <Id> 3 <Host> 6 <Time> ---replace_result "Writing to net" "NULL" ---replace_regex /localhost[:0-9]*/localhost/ -SHOW PROCESSLIST; -SET SESSION transaction_prealloc_size=1024*1024*1024*4; ---replace_result "Writing to net" "NULL" ---replace_column 1 <Id> 3 <Host> 6 <Time> ---replace_result "Writing to net" "NULL" ---replace_regex /localhost[:0-9]*/localhost/ -SHOW PROCESSLIST; -SET SESSION transaction_prealloc_size=1024*1024*1024*5; ---replace_result "Writing to net" "NULL" ---replace_column 1 <Id> 3 <Host> 6 <Time> ---replace_result "Writing to net" "NULL" -SHOW PROCESSLIST; ---enable_warnings - |
