diff options
Diffstat (limited to 'mysql-test/r/variables-big.result')
| -rw-r--r-- | mysql-test/r/variables-big.result | 40 |
1 files changed, 20 insertions, 20 deletions
diff --git a/mysql-test/r/variables-big.result b/mysql-test/r/variables-big.result index 960fc6d22f4..2c178999a2c 100644 --- a/mysql-test/r/variables-big.result +++ b/mysql-test/r/variables-big.result @@ -1,20 +1,20 @@ -SET SESSION transaction_prealloc_size=1024*1024*1024*1; -SHOW PROCESSLIST; -Id User Host db Command Time State Info -<Id> root localhost test Query <Time> NULL SHOW PROCESSLIST -SET SESSION transaction_prealloc_size=1024*1024*1024*2; -SHOW PROCESSLIST; -Id User Host db Command Time State Info -<Id> root localhost test Query <Time> NULL SHOW PROCESSLIST -SET SESSION transaction_prealloc_size=1024*1024*1024*3; -SHOW PROCESSLIST; -Id User Host db Command Time State Info -<Id> root localhost test Query <Time> NULL SHOW PROCESSLIST -SET SESSION transaction_prealloc_size=1024*1024*1024*4; -SHOW PROCESSLIST; -Id User Host db Command Time State Info -<Id> root localhost test Query <Time> NULL SHOW PROCESSLIST -SET SESSION transaction_prealloc_size=1024*1024*1024*5; -SHOW PROCESSLIST; -Id User Host db Command Time State Info -<Id> root localhost test Query <Time> NULL SHOW PROCESSLIST +set session transaction_prealloc_size=1024*1024*1024*1; +select @pid_temp = (select ID from information_schema.processlist) as 'TRUE'; +TRUE +1 +set session transaction_prealloc_size=1024*1024*1024*2; +select @pid_temp = (select ID from information_schema.processlist) as 'TRUE'; +TRUE +1 +set session transaction_prealloc_size=1024*1024*1024*3; +select @pid_temp = (select ID from information_schema.processlist) as 'TRUE'; +TRUE +1 +set session transaction_prealloc_size=1024*1024*1024*4; +select @pid_temp = (select ID from information_schema.processlist) as 'TRUE'; +TRUE +1 +set session transaction_prealloc_size=1024*1024*1024*5; +select @pid_temp = (select ID from information_schema.processlist) as 'TRUE'; +TRUE +1 |