# Query 1: 0.25 QPS, 3.70x concurrency, ID 0x9F4BD2F4FF885D88 at byte 791108
# This item is included in the report because it matches --limit.
# Scores: Apdex = 0.07 [1.0], V/M = 5.24
# Query_time sparkline: | _^|
# Time range: 2012-02-27 10:00:30 to 2012-03-18 18:48:40
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 35 431327
# Exec time 69 6507934s 2s 102s 15s 29s 9s 15s
# Lock time 23 534s 39us 7s 1ms 761us 62ms 273us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 15 3.46G 0 8.58k 8.41k 8.46k 403.81 8.46k
# Query size 1 127.11M 309 309 309 309 0 309
# String:
# Databases nova
# Hosts
# Users nova
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ####################################
# 10s+ ################################################################
# Tables
# SHOW TABLE STATUS FROM `nova` LIKE 'fixed_ips'\G
# SHOW CREATE TABLE `nova`.`fixed_ips`\G
# SHOW TABLE STATUS FROM `nova` LIKE 'networks'\G
# SHOW CREATE TABLE `nova`.`networks`\G
UPDATE fixed_ips SET updated_at='2012-02-29 06:26:34', instance_id=NULL, leased=0 WHERE fixed_ips.network_id IN (SELECT networks.id
FROM networks
WHERE networks.host = 'nv-aw2az2-compute0306') AND fixed_ips.updated_at < '2012-02-29 06:16:34' AND fixed_ips.instance_id IS NOT NULL AND fixed_ips.allocated = 0\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select updated_at='2012-02-29 06:26:34', instance_id=NULL, leased=0 from fixed_ips where fixed_ips.network_id IN (SELECT networks.id
FROM networks
WHERE networks.host = 'nv-aw2az2-compute0306') AND fixed_ips.updated_at < '2012-02-29 06:16:34' AND fixed_ips.instance_id IS NOT NULL AND fixed_ips.allocated = 0\G
# Query 2: 1.21 QPS, 3.99x concurrency, ID 0x7A871E4AA50C9E7F at byte 8450394920
# This item is included in the report because it matches --limit.
# Scores: Apdex = 0.39 [1.0], V/M = 0.26
# Query_time sparkline: | ^ |
# Time range: 2012-03-14 10:02:30 to 2012-03-18 18:48:27
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 37 454970
# Exec time 16 1505835s 2s 7s 3s 5s 936ms 3s