1
set session transaction_prealloc_size=1024*1024*1024*1;
3
Id User Host db Command Time State Info
4
1 root localhost test Query 0 NULL show processlist
5
set session transaction_prealloc_size=1024*1024*1024*2;
7
Id User Host db Command Time State Info
8
1 root localhost test Query 0 NULL show processlist
9
set session transaction_prealloc_size=1024*1024*1024*3;
11
Id User Host db Command Time State Info
12
1 root localhost test Query 0 NULL show processlist
13
set session transaction_prealloc_size=1024*1024*1024*4;
15
Id User Host db Command Time State Info
16
1 root localhost test Query 0 NULL show processlist
17
set session transaction_prealloc_size=1024*1024*1024*5;
19
Id User Host db Command Time State Info
20
1 root localhost test Query 0 NULL show processlist