| 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'; |