This file is indexed.

/usr/lib/mysql-testsuite/t/variables-big.test is in percona-xtradb-cluster-testsuite-5.5 5.5.34-25.9+dfsg-0ubuntu4.

This file is owned by root:root, with mode 0o644.

The actual contents of the file can be viewed below.

 1
 2
 3
 4
 5
 6
 7
 8
 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
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
#
# test variables big
#

--source include/big_test.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;
--replace_column 1 <Id> 3 <Host> 6 <Time>
SHOW PROCESSLIST;
SET SESSION transaction_prealloc_size=1024*1024*1024*2;
--replace_column 1 <Id> 3 <Host> 6 <Time>
SHOW PROCESSLIST;
SET SESSION transaction_prealloc_size=1024*1024*1024*3;
--replace_column 1 <Id> 3 <Host> 6 <Time>
SHOW PROCESSLIST;
SET SESSION transaction_prealloc_size=1024*1024*1024*4;
--replace_column 1 <Id> 3 <Host> 6 <Time>
SHOW PROCESSLIST;
SET SESSION transaction_prealloc_size=1024*1024*1024*5;
--replace_column 1 <Id> 3 <Host> 6 <Time>
SHOW PROCESSLIST;
--enable_warnings

SET @@session.transaction_prealloc_size= @def_var;