1 SET SESSION transaction_prealloc_size=1024*1024*1024*1;
3 Id User Host db Command Time State Info
4 <Id> root <Host> test Query <Time> NULL SHOW PROCESSLIST
5 SET SESSION transaction_prealloc_size=1024*1024*1024*2;
7 Id User Host db Command Time State Info
8 <Id> root <Host> test Query <Time> NULL SHOW PROCESSLIST
9 SET SESSION transaction_prealloc_size=1024*1024*1024*3;
11 Id User Host db Command Time State Info
12 <Id> root <Host> test Query <Time> NULL SHOW PROCESSLIST
13 SET SESSION transaction_prealloc_size=1024*1024*1024*4;
15 Id User Host db Command Time State Info
16 <Id> root <Host> test Query <Time> NULL SHOW PROCESSLIST
17 SET SESSION transaction_prealloc_size=1024*1024*1024*5;
19 Id User Host db Command Time State Info
20 <Id> root <Host> test Query <Time> NULL SHOW PROCESSLIST