1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
|
# Time: 090805 11:00:27
# Thread_id: 1
# Query_time: 0.726052 Lock_time: 0.100091 Rows_sent: 9 Rows_examined: 51
# QC_Hit: No Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
# Filesort: No Filesort_on_disk: No Merge_passes: 0
# No InnoDB statistics available for this query
use db1;
SELECT * FROM foo;
# Query_time: 1.726052 Lock_time: 0.010093 Rows_sent: 1 Rows_examined: 1
# QC_Hit: No Full_scan: No Full_join: No Tmp_table: No Tmp_table_on_disk: No
# Filesort: No Filesort_on_disk: No Merge_passes: 0
# No InnoDB statistics available for this query
use db1;
SELECT id FROM tbl WHERE id = 1;
# Query_time: 9.000052 Lock_time: 0.000001 Rows_sent: 900 Rows_examined: 10000
# QC_Hit: No Full_scan: Yes Full_join: No Tmp_table: Yes Tmp_table_on_disk: No
# Filesort: No Filesort_on_disk: Yes Merge_passes: 1
# No InnoDB statistics available for this query
use db1;
SELECT COUNT(*) FROM blah WHERE col > 2;
# Time: 090805 12:00:27
# Thread_id: 2
# Query_time: 0.726052 Lock_time: 0.100091 Rows_sent: 9 Rows_examined: 51
# QC_Hit: Yes Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
# Filesort: No Filesort_on_disk: No Merge_passes: 0
# No InnoDB statistics available for this query
use db1;
SELECT * FROM foo;
# Query_time: 0.726052 Lock_time: 0.100091 Rows_sent: 0 Rows_examined: 0
# QC_Hit: No Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
# Filesort: No Filesort_on_disk: No Merge_passes: 0
# No InnoDB statistics available for this query
use db2;
INSERT INTO tbl VALUES ('a', 'b');
# Query_time: 0.000052 Lock_time: 0.010091 Rows_sent: 0 Rows_examined: 0
# QC_Hit: No Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
# Filesort: No Filesort_on_disk: No Merge_passes: 0
# No InnoDB statistics available for this query
use db2;
INSERT INTO tbl VALUES ('c', 'd');
# Time: 090805 13:00:27
# Thread_id: 3
# Query_time: 1349.000052 Lock_time: 1349.000091 Rows_sent: 0 Rows_examined: 1928472
# QC_Hit: No Full_scan: Yes Full_join: No Tmp_table: Yes Tmp_table_on_disk: Yes
# Filesort: Yes Filesort_on_disk: Yes Merge_passes: 0
# No InnoDB statistics available for this query
use db3;
DELETE FROM forest WHERE animal = 'dead';
# Query_time: 0.926052 Lock_time: 0.097091 Rows_sent: 8 Rows_examined: 50
# QC_Hit: No Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
# Filesort: No Filesort_on_disk: No Merge_passes: 0
# No InnoDB statistics available for this query
use db3;
SELECT * FROM foo;
# Query_time: 0.526052 Lock_time: 0.037091 Rows_sent: 7 Rows_examined: 0
# QC_Hit: No Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
# Filesort: No Filesort_on_disk: No Merge_passes: 0
# No InnoDB statistics available for this query
use db3;
SELECT * FROM foo;
|
