← Back to branch summary

~ubuntu-branches/ubuntu/trusty/mariadb-5.5/trusty-proposed

« back to all changes in this revision

Viewing changes to mysql-test/suite/sys_vars/r/transaction_prealloc_size_bug27322.result

  • Committer: Package Import Robot
  • Author(s): Otto Kekäläinen
  • Date: 2013-12-22 10:27:05 UTC
  • Revision ID: package-import@ubuntu.com-20131222102705-mndw7s12mz0szrcn
Tags: upstream-5.5.32
Import upstream version 5.5.32

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/sys_vars/r/transaction_prealloc_size_bug27322.result
 
1
SET @def_var= @@session.transaction_prealloc_size;
 
2
SET SESSION transaction_prealloc_size=1024*1024*1024*1;
 
3
SHOW PROCESSLIST;
 
4
Id      User    Host    db      Command Time    State   Info    Progress
 
5
<Id>    root    <Host>  test    Query   <Time>  NULL    SHOW PROCESSLIST        0.000
 
6
SET SESSION transaction_prealloc_size=1024*1024*1024*2;
 
7
SHOW PROCESSLIST;
 
8
Id      User    Host    db      Command Time    State   Info    Progress
 
9
<Id>    root    <Host>  test    Query   <Time>  NULL    SHOW PROCESSLIST        0.000
 
10
SET SESSION transaction_prealloc_size=1024*1024*1024*3;
 
11
SHOW PROCESSLIST;
 
12
Id      User    Host    db      Command Time    State   Info    Progress
 
13
<Id>    root    <Host>  test    Query   <Time>  NULL    SHOW PROCESSLIST        0.000
 
14
SET SESSION transaction_prealloc_size=1024*1024*1024*4;
 
15
SHOW PROCESSLIST;
 
16
Id      User    Host    db      Command Time    State   Info    Progress
 
17
<Id>    root    <Host>  test    Query   <Time>  NULL    SHOW PROCESSLIST        0.000
 
18
SET SESSION transaction_prealloc_size=1024*1024*1024*5;
 
19
SHOW PROCESSLIST;
 
20
Id      User    Host    db      Command Time    State   Info    Progress
 
21
<Id>    root    <Host>  test    Query   <Time>  NULL    SHOW PROCESSLIST        0.000