1
set session transaction_prealloc_size=1024*1024*1024*1;
3
Id User Host db Command Time State Info
4
1 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
1 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
1 root 127.0.0.1 test Query 0 NULL show processlist
13
set session transaction_prealloc_size=1024*1024*1024*4;
15
Warning 1292 Truncated incorrect transaction_prealloc_size value: '4294967296'
17
Id User Host db Command Time State Info
18
1 root 127.0.0.1 test Query 0 NULL show processlist
19
set session transaction_prealloc_size=1024*1024*1024*5;
21
Warning 1292 Truncated incorrect transaction_prealloc_size value: '5368709120'
23
Id User Host db Command Time State Info
24
1 root 127.0.0.1 test Query 0 NULL show processlist