|
1
by brian
clean slate |
1 |
set session transaction_prealloc_size=1024*1024*1024*1;
|
2 |
show processlist;
|
|
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;
|
|
6 |
show processlist;
|
|
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;
|
|
10 |
show processlist;
|
|
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;
|
|
14 |
show processlist;
|
|
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;
|
|
18 |
show processlist;
|
|
19 |
Id User Host db Command Time State Info
|
|
20 |
1 root localhost test Query 0 NULL show processlist
|