5
"attribute" : "fingerprint",
6
"checksum" : "66825DDC008FFA89",
7
"distillate" : "UPDATE db?.tuningdetail_?_? db?.gonzo",
9
"as_select" : "select n.column1 = a.column1, n.word3 = a.word3 from db2.tuningdetail_21_265507 n\n inner join db1.gonzo a using(gonzo) ",
10
"query" : "update db2.tuningdetail_21_265507 n\n inner join db1.gonzo a using(gonzo) \n set n.column1 = a.column1, n.word3 = a.word3",
11
"ts" : "2007-12-18 11:48:27"
13
"fingerprint" : "update d?tuningdetail_?_? n inner join d?gonzo a using(gonzo) set n.column? = a.column?, n.word? = a.word?",
18
"Filesort_on_disk" : {
30
"median" : "0.000091",
33
"pct_95" : "0.000091",
34
"stddev" : "0.000000",
63
"median" : "0.726052",
66
"pct_95" : "0.726052",
67
"stddev" : "0.000000",
93
"Tmp_table_on_disk" : {
103
"value" : "[SQL_SLAVE]"
109
"create" : "SHOW CREATE TABLE `db2`.`tuningdetail_21_265507`\\G",
110
"status" : "SHOW TABLE STATUS FROM `db2` LIKE 'tuningdetail_21_265507'\\G"
113
"create" : "SHOW CREATE TABLE `db1`.`gonzo`\\G",
114
"status" : "SHOW TABLE STATUS FROM `db1` LIKE 'gonzo'\\G"
117
"ts_max" : "2007-12-18 11:48:27",
118
"ts_min" : "2007-12-18 11:48:27"
124
"name" : "/Users/daniel/p/release-2.2.3/t/lib/samples/slowlogs/slow002.txt",
16
132
"Filesort_on_disk" : {
141
"InnoDB_IO_r_bytes" : {
150
"InnoDB_IO_r_ops" : {
159
"InnoDB_IO_r_wait" : {
162
"median" : "0.000000",
164
"pct_95" : "0.000000",
165
"stddev" : "0.000000",
168
"InnoDB_pages_distinct" : {
177
"InnoDB_queue_wait" : {
180
"median" : "0.000000",
182
"pct_95" : "0.000000",
183
"stddev" : "0.000000",
186
"InnoDB_rec_lock_wait" : {
189
"median" : "0.000000",
191
"pct_95" : "0.000000",
192
"stddev" : "0.000000",
52
197
"max" : "0.000091",
53
"median" : "0.000091",
56
"pct_95" : "0.000091",
198
"median" : "0.000026",
200
"pct_95" : "0.000089",
201
"stddev" : "0.000028",
60
204
"Merge_passes" : {
85
227
"max" : "0.726052",
86
"median" : "0.726052",
89
"pct_95" : "0.726052",
228
"median" : "0.000516",
230
"pct_95" : "0.705093",
231
"stddev" : "0.231765",
93
234
"Rows_examined" : {
94
"avg" : "62951.000000",
96
"max" : "62951.000000",
97
"median" : "62951.000000",
98
"min" : "62951.000000",
100
"pct_95" : "62951.000000",
102
"sum" : "62951.000000"
126
255
"Tmp_table_on_disk" : {
150
"value" : "[SQL_SLAVE]"
154
"checksum" : "66825DDC008FFA89",
156
"fingerprint" : "update d?tuningdetail_?_? n inner join d?gonzo a using(gonzo) set n.column? = a.column?, n.word? = a.word?",
157
"sample" : "update db2.tuningdetail_21_265507 n\n inner join db1.gonzo a using(gonzo) \n set n.column1 = a.column1, n.word3 = a.word3",
158
"ts_max" : "2007-12-18 11:48:27",
159
"ts_min" : "2007-12-18 11:48:27"
260
"unique_query_count" : 7