1
SET SESSION transaction_prealloc_size=1024*1024*1024*1;
3
Id User Host db Command Time State Info
4
<Id> root localhost 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 localhost 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 localhost 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 localhost 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 localhost test Query <Time> NULL SHOW PROCESSLIST