# 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