← Back to branch summary

~vkolesnikov/pbxt/pbxt-preload-test-bug

« back to all changes in this revision

Viewing changes to pbxt/mysql-test-update/mysql-test/r/status.result

  • Committer: paul-mccullagh
  • Date: 2008-03-10 11:36:34 UTC
  • Revision ID: paul-mccullagh-417ebf175a9c8ee6e5b3777d9e2398e1fb197391
Implemented full durability

Show diffs side-by-side

added added

removed removed

Lines of Context:
pbxt/mysql-test-update/mysql-test/r/status.result
1
1
flush status;
2
2
show status like 'Table_lock%';
3
3
Variable_name   Value
4
 
Table_locks_immediate   0
 
4
Table_locks_immediate   1
5
5
Table_locks_waited      0
6
6
select * from information_schema.session_status where variable_name like 'Table_lock%';
7
7
VARIABLE_NAME   VARIABLE_VALUE
8
 
TABLE_LOCKS_IMMEDIATE   0.0000000
9
 
TABLE_LOCKS_WAITED      0.0000000
 
8
TABLE_LOCKS_IMMEDIATE   2
 
9
TABLE_LOCKS_WAITED      0
10
10
SET SQL_LOG_BIN=0;
11
11
drop table if exists t1;
12
12
create table t1(n int) engine=myisam;
18
18
unlock tables;
19
19
show status like 'Table_lock%';
20
20
Variable_name   Value
21
 
Table_locks_immediate   3
 
21
Table_locks_immediate   15
22
22
Table_locks_waited      1
23
23
select * from information_schema.session_status where variable_name like 'Table_lock%';
24
24
VARIABLE_NAME   VARIABLE_VALUE
25
 
TABLE_LOCKS_IMMEDIATE   3.0000000
26
 
TABLE_LOCKS_WAITED      1.0000000
 
25
TABLE_LOCKS_IMMEDIATE   16
 
26
TABLE_LOCKS_WAITED      1
27
27
drop table t1;
28
28
select 1;
29
29
1
63
63
Max_used_connections    1
64
64
SELECT * FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME LIKE 'max_used_connections';
65
65
VARIABLE_NAME   VARIABLE_VALUE
66
 
MAX_USED_CONNECTIONS    1.0000000
 
66
MAX_USED_CONNECTIONS    1
67
67
SET @save_thread_cache_size=@@thread_cache_size;
68
68
SET GLOBAL thread_cache_size=3;
69
69
SHOW STATUS LIKE 'max_used_connections';
71
71
Max_used_connections    3
72
72
SELECT * FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME LIKE 'max_used_connections';
73
73
VARIABLE_NAME   VARIABLE_VALUE
74
 
MAX_USED_CONNECTIONS    3.0000000
 
74
MAX_USED_CONNECTIONS    3
75
75
FLUSH STATUS;
76
76
SHOW STATUS LIKE 'max_used_connections';
77
77
Variable_name   Value
78
78
Max_used_connections    2
79
79
SELECT * FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME LIKE 'max_used_connections';
80
80
VARIABLE_NAME   VARIABLE_VALUE
81
 
MAX_USED_CONNECTIONS    2.0000000
 
81
MAX_USED_CONNECTIONS    2
82
82
SHOW STATUS LIKE 'max_used_connections';
83
83
Variable_name   Value
84
84
Max_used_connections    3
85
85
SELECT * FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME LIKE 'max_used_connections';
86
86
VARIABLE_NAME   VARIABLE_VALUE
87
 
MAX_USED_CONNECTIONS    3.0000000
 
87
MAX_USED_CONNECTIONS    3
88
88
SHOW STATUS LIKE 'max_used_connections';
89
89
Variable_name   Value
90
90
Max_used_connections    4
91
91
SELECT * FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME LIKE 'max_used_connections';
92
92
VARIABLE_NAME   VARIABLE_VALUE
93
 
MAX_USED_CONNECTIONS    4.0000000
 
93
MAX_USED_CONNECTIONS    4
94
94
SET GLOBAL thread_cache_size=@save_thread_cache_size;
95
95
show status like 'com_show_status';
96
96
Variable_name   Value
97
97
Com_show_status 3
98
98
show status like 'hand%write%';
99
99
Variable_name   Value
100
 
Handler_write   0
 
100
Handler_write   5
101
101
show status like '%tmp%';
102
102
Variable_name   Value
103
103
Created_tmp_disk_tables 0
105
105
Created_tmp_tables      0
106
106
show status like 'hand%write%';
107
107
Variable_name   Value
108
 
Handler_write   0
 
108
Handler_write   7
109
109
show status like '%tmp%';
110
110
Variable_name   Value
111
111
Created_tmp_disk_tables 0