← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/global_status.result

  • Committer: Monty Taylor
  • Date: 2010-09-26 21:24:15 UTC
  • mto: (1796.1.2 build)
  • mto: This revision was merged to the branch mainline in revision 1797.
  • Revision ID: mordred@inaugust.com-20100926212415-5fn3p3q75pgiei7r
Moved protocol doc into the docs.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/global_status.result
1
 
flush global status;
2
 
use test;
3
 
drop table if exists t1;
4
 
create table t1 (a int);
5
 
insert into t1 values (1),(2),(3);
6
 
select * from t1;
7
 
a
8
 
1
9
 
2
10
 
3
11
 
select * from t1;
12
 
a
13
 
1
14
 
2
15
 
3
16
 
select * from t1;
17
 
a
18
 
1
19
 
2
20
 
3
21
 
show global status like 'Handler%';
22
 
Variable_name   Value
23
 
Handler_commit  0
24
 
Handler_delete  0
25
 
Handler_prepare 0
26
 
Handler_read_first      3
27
 
Handler_read_key        6
28
 
Handler_read_next       0
29
 
Handler_read_prev       0
30
 
Handler_read_rnd        0
31
 
Handler_read_rnd_next   12
32
 
Handler_rollback        0
33
 
Handler_savepoint       0
34
 
Handler_savepoint_rollback      0
35
 
Handler_update  0
36
 
Handler_write   3
37
 
use test;
38
 
select * from t1;
39
 
a
40
 
1
41
 
2
42
 
3
43
 
select * from t1;
44
 
a
45
 
1
46
 
2
47
 
3
48
 
select * from t1;
49
 
a
50
 
1
51
 
2
52
 
3
53
 
show global status like 'Handler%';
54
 
Variable_name   Value
55
 
Handler_commit  0
56
 
Handler_delete  0
57
 
Handler_prepare 0
58
 
Handler_read_first      6
59
 
Handler_read_key        12
60
 
Handler_read_next       0
61
 
Handler_read_prev       0
62
 
Handler_read_rnd        0
63
 
Handler_read_rnd_next   39
64
 
Handler_rollback        0
65
 
Handler_savepoint       0
66
 
Handler_savepoint_rollback      0
67
 
Handler_update  0
68
 
Handler_write   3
69
 
flush global status;
70
 
show global status like 'Handler%';
71
 
Variable_name   Value
72
 
Handler_commit  0
73
 
Handler_delete  0
74
 
Handler_prepare 0
75
 
Handler_read_first      0
76
 
Handler_read_key        0
77
 
Handler_read_next       0
78
 
Handler_read_prev       0
79
 
Handler_read_rnd        0
80
 
Handler_read_rnd_next   0
81
 
Handler_rollback        0
82
 
Handler_savepoint       0
83
 
Handler_savepoint_rollback      0
84
 
Handler_update  0
85
 
Handler_write   0