1
# Time: 071218 11:48:27 # User@Host: [SQL_SLAVE] @ []
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 Disk_tmp_table: No
5
# Filesort: No Disk_filesort: No Merge_passes: 0
6
# No InnoDB statistics available for this query
8
# User@Host: [SQL_SLAVE] @ []
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 Disk_tmp_table: No
12
# Filesort: No Disk_filesort: No Merge_passes: 0
13
# No InnoDB statistics available for this query
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] @ []
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 Disk_tmp_table: No
23
# Filesort: No Disk_filesort: 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)
30
# User@Host: [SQL_SLAVE] @ []
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 Disk_tmp_table: No
34
# Filesort: No Disk_filesort: 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] @ []
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 Disk_tmp_table: No
45
# Filesort: No Disk_filesort: 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)
52
# User@Host: [SQL_SLAVE] @ []
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 Disk_tmp_table: No
56
# Filesort: No Disk_filesort: 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
61
SET biz = '91848182522';
62
# User@Host: [SQL_SLAVE] @ []
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 Disk_tmp_table: No
66
# Filesort: No Disk_filesort: 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;
74
# User@Host: [SQL_SLAVE] @ []
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 Disk_tmp_table: No
78
# Filesort: No Disk_filesort: 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
83
SET biz = '91848182522';