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
|
# Query 1: 0 QPS, 0x concurrency, ID 0x45FE45AEC222350466825DDC008FFA89 at byte 338
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2007-12-18 11:48:27
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 12 1
# Exec time 95 726ms 726ms 726ms 726ms 726ms 0 726ms
# Lock time 29 91us 91us 91us 91us 91us 0 91us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 100 61.48k 61.48k 61.48k 61.48k 61.48k 0 61.48k
# Merge passes 0 0 0 0 0 0 0 0
# Query size 25 129 129 129 129 129 0 129
# Boolean:
# Full scan 100% yes, 0% no
# String:
# Databases db1
# Hosts
# Users [SQL_SLAVE]
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `db2` LIKE 'tuningdetail_21_265507'\G
# SHOW CREATE TABLE `db2`.`tuningdetail_21_265507`\G
# SHOW TABLE STATUS FROM `db1` LIKE 'gonzo'\G
# SHOW CREATE TABLE `db1`.`gonzo`\G
update db2.tuningdetail_21_265507 n
inner join db1.gonzo a using(gonzo)
set n.column1 = a.column1, n.word3 = a.word3\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select n.column1 = a.column1, n.word3 = a.word3 from db2.tuningdetail_21_265507 n
inner join db1.gonzo a using(gonzo) \G
# Profile
# Rank Query ID Response time Calls R/Call V/M
# ==== ================================= ============= ===== ====== =====
# 1 0x45FE45AEC222350466825DDC008F... 0.7261 95.3% 1 0.7261 0.00 UPDATE db?.tuningdetail_?_? db?.gonzo
# MISC 0xMISC 0.0360 4.7% 7 0.0051 0.0 <6 ITEMS>
|
