Debian Codegraph @

test/slow-logs/slow002.log

raw
1 # Time: 071218 11:48:27 # User@Host: [SQL_SLAVE] @ []
2 # Thread_id: 10
3 # Query_time: 0.000012 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
4 # QC_Hit: No Full_scan: No Full_join: No Tmp_table: No Tmp_table_on_disk: No
5 # Filesort: No Filesort_on_disk: No Merge_passes: 0
6 # No InnoDB statistics available for this query
7 BEGIN;
8 # User@Host: [SQL_SLAVE] @ []
9 # Thread_id: 10
10 # Query_time: 0.726052 Lock_time: 0.000091 Rows_sent: 0 Rows_examined: 62951
11 # QC_Hit: No Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
12 # Filesort: No Filesort_on_disk: No Merge_passes: 0
13 # No InnoDB statistics available for this query
14 use db1;
15 SET timestamp=1197996507;
16 update db2.tuningdetail_21_265507 n
17 inner join db1.gonzo a using(gonzo)
18 set n.column1 = a.column1, n.word3 = a.word3;
19 # User@Host: [SQL_SLAVE] @ []
20 # Thread_id: 10
21 # Query_time: 0.000512 Lock_time: 0.000077 Rows_sent: 0 Rows_examined: 0
22 # QC_Hit: No Full_scan: No Full_join: No Tmp_table: No Tmp_table_on_disk: No
23 # Filesort: No Filesort_on_disk: No Merge_passes: 0
24 # InnoDB_IO_r_ops: 0 InnoDB_IO_r_bytes: 0 InnoDB_IO_r_wait: 0.000000
25 # InnoDB_rec_lock_wait: 0.000000 InnoDB_queue_wait: 0.000000
26 # InnoDB_pages_distinct: 24
27 SET timestamp=1197996507;
28 INSERT INTO db3.vendor11gonzo (makef, bizzle)
29 VALUES ('', 'Exact');
30 # User@Host: [SQL_SLAVE] @ []
31 # Thread_id: 10
32 # Query_time: 0.033384 Lock_time: 0.000028 Rows_sent: 0 Rows_examined: 0
33 # QC_Hit: No Full_scan: No Full_join: No Tmp_table: No Tmp_table_on_disk: No
34 # Filesort: No Filesort_on_disk: No Merge_passes: 0
35 # InnoDB_IO_r_ops: 0 InnoDB_IO_r_bytes: 0 InnoDB_IO_r_wait: 0.000000
36 # InnoDB_rec_lock_wait: 0.000000 InnoDB_queue_wait: 0.000000
37 # InnoDB_pages_distinct: 11
38 UPDATE db4.vab3concept1upload
39 SET vab3concept1id = '91848182522'
40 WHERE vab3concept1upload='6994465';
41 # User@Host: [SQL_SLAVE] @ []
42 # Thread_id: 10
43 # Query_time: 0.000530 Lock_time: 0.000027 Rows_sent: 0 Rows_examined: 0
44 # QC_Hit: No Full_scan: No Full_join: No Tmp_table: No Tmp_table_on_disk: No
45 # Filesort: No Filesort_on_disk: No Merge_passes: 0
46 # InnoDB_IO_r_ops: 0 InnoDB_IO_r_bytes: 0 InnoDB_IO_r_wait: 0.000000
47 # InnoDB_rec_lock_wait: 0.000000 InnoDB_queue_wait: 0.000000
48 # InnoDB_pages_distinct: 18
49 SET insert_id=34484549,timestamp=1197996507;
50 INSERT INTO db1.conch (word3, vid83)
51 VALUES ('211', '18');
52 # User@Host: [SQL_SLAVE] @ []
53 # Thread_id: 10
54 # Query_time: 0.000530 Lock_time: 0.000027 Rows_sent: 0 Rows_examined: 0
55 # QC_Hit: No Full_scan: No Full_join: No Tmp_table: No Tmp_table_on_disk: No
56 # Filesort: No Filesort_on_disk: No Merge_passes: 0
57 # InnoDB_IO_r_ops: 0 InnoDB_IO_r_bytes: 0 InnoDB_IO_r_wait: 0.000000
58 # InnoDB_rec_lock_wait: 0.000000 InnoDB_queue_wait: 0.000000
59 # InnoDB_pages_distinct: 18
60 UPDATE foo.bar
61 SET biz = '91848182522';
62 # User@Host: [SQL_SLAVE] @ []
63 # Thread_id: 10
64 # Query_time: 0.000530 Lock_time: 0.000027 Rows_sent: 0 Rows_examined: 0
65 # QC_Hit: No Full_scan: No Full_join: No Tmp_table: No Tmp_table_on_disk: No
66 # Filesort: No Filesort_on_disk: No Merge_passes: 0
67 # InnoDB_IO_r_ops: 0 InnoDB_IO_r_bytes: 0 InnoDB_IO_r_wait: 0.000000
68 # InnoDB_rec_lock_wait: 0.000000 InnoDB_queue_wait: 0.000000
69 # InnoDB_pages_distinct: 18
70 SET timestamp=1197996508;
71 UPDATE bizzle.bat
72 SET boop='bop: 899'
73 WHERE fillze='899';
74 # User@Host: [SQL_SLAVE] @ []
75 # Thread_id: 10
76 # Query_time: 0.000530 Lock_time: 0.000027 Rows_sent: 0 Rows_examined: 0
77 # QC_Hit: No Full_scan: No Full_join: No Tmp_table: No Tmp_table_on_disk: No
78 # Filesort: No Filesort_on_disk: No Merge_passes: 0
79 # InnoDB_IO_r_ops: 0 InnoDB_IO_r_bytes: 0 InnoDB_IO_r_wait: 0.000000
80 # InnoDB_rec_lock_wait: 0.000000 InnoDB_queue_wait: 0.000000
81 # InnoDB_pages_distinct: 18
82 UPDATE foo.bar
83 SET biz = '91848182522';