Debian Codegraph @

mysql-test/suite/sys_vars/r/transaction_prealloc_size_bug27322.result

raw
1 SET @def_var= @@session.transaction_prealloc_size;
2 SET SESSION transaction_prealloc_size=1024*1024*1024*1;
3 SHOW PROCESSLIST;
4 Id User Host db Command Time State Info Progress
5 <Id> root <Host> test Query <Time> <State> SHOW PROCESSLIST 0.000
6 SET SESSION transaction_prealloc_size=1024*1024*1024*2;
7 SHOW PROCESSLIST;
8 Id User Host db Command Time State Info Progress
9 <Id> root <Host> test Query <Time> <State> SHOW PROCESSLIST 0.000
10 SET SESSION transaction_prealloc_size=1024*1024*1024*3;
11 SHOW PROCESSLIST;
12 Id User Host db Command Time State Info Progress
13 <Id> root <Host> test Query <Time> <State> SHOW PROCESSLIST 0.000
14 SET SESSION transaction_prealloc_size=1024*1024*1024*4;
15 SHOW PROCESSLIST;
16 Id User Host db Command Time State Info Progress
17 <Id> root <Host> test Query <Time> <State> SHOW PROCESSLIST 0.000
18 SET SESSION transaction_prealloc_size=1024*1024*1024*5;
19 SHOW PROCESSLIST;
20 Id User Host db Command Time State Info Progress
21 <Id> root <Host> test Query <Time> <State> SHOW PROCESSLIST 0.000