1
set session transaction_prealloc_size=1024*1024*1024*1;
3
Id User Host db Command Time State Info
4
# # # test Query # # show processlist
5
set session transaction_prealloc_size=1024*1024*1024*2;
7
Id User Host db Command Time State Info
8
# # # test Query # # show processlist
9
set session transaction_prealloc_size=1024*1024*1024*3;
11
Id User Host db Command Time State Info
12
# # # test Query # # show processlist
13
set session transaction_prealloc_size=1024*1024*1024*4;
15
Error 1292 Truncated incorrect transaction_prealloc_size value: '4294967296'
17
Id User Host db Command Time State Info
18
# # # test Query # # show processlist
19
set session transaction_prealloc_size=1024*1024*1024*5;
21
Error 1292 Truncated incorrect transaction_prealloc_size value: '5368709120'
23
Id User Host db Command Time State Info
24
# # # test Query # # show processlist