1
set session transaction_prealloc_size=1024*1024*1024*1;
3
Id User Host db Command Time State Info
4
# root 127.0.0.1 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
# root 127.0.0.1 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
# root 127.0.0.1 test Query 0 NULL show processlist