When Load QPS Slow QCacheHit KCacheHit BpsIn BpsOut
Now 0.01 1.04k 29 0.00% 67.37% 2.14M 3.93M
Total 0.00 1.01k 276.51k 0.00% 74.22% 2.04M 4.90M
Cmd ID State User Host DB Time Query
Query 122253 Sending data nova 15.185.141.44 nova 09:46 SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted
Query 121259 Sending data nova 15.185.140.32 nova 06:06 SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted
Query 122098 Sending data nova 15.185.140.24 nova 03:37 SELECT anon_1.instance_types_created_at AS anon_1_instance_types_created_at, anon_1.instance_types_updated_at AS anon_1_instance_types_updated_at, anon_1.instance
Query 122376 Sending data nova 15.185.140.21 nova 01:28 SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted
Query 121238 Sending data nova 15.185.140.15 nova 01:27 SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted
Query 122377 Sending data nova 15.185.141.3 nova 01:10 SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted
Query 121323 Sending data nova 15.185.141.16 nova 00:55 SELECT anon_1.instance_types_created_at AS anon_1_instance_types_created_at, anon_1.instance_types_updated_at AS anon_1_instance_types_updated_at, anon_1.instance
Query 121492 Sending data nova 15.185.140.89 nova 00:29 SELECT anon_1.instance_types_created_at AS anon_1_instance_types_created_at, anon_1.instance_types_updated_at AS anon_1_instance_types_updated_at, anon_1.instance
Query 122309 Copying to tmp tab nova 15.185.140.96 nova 00:05 SELECT instance_types.created_at AS instance_types_created_at, instance_types.updated_at AS instance_types_updated_at, instance_types.deleted_at AS instance_types
Query 122369 Sending data nova 15.185.140.24 nova 00:02 SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted
Query 121805 Sending data nova 15.185.140.67 nova 00:02 SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted
Query 122284 Sending data nova 15.185.140.91 nova 00:02 SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted
Query 122119 Sending data nova 15.185.140.13 nova 00:01 SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted
Query 121254 Sending data nova 15.185.140.18 nova 00:01 SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted
Query 122380 Sending data nova 15.185.140.24 nova 00:01 SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted
Query 121738 Sending data nova 15.185.141.10 nova 00:01 SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted
Query 121916 Sending data nova 15.185.141.11 nova 00:01 SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted
Query 122090 Sending data nova 15.185.141.12 nova 00:01 SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted
Query 122336 Sending data nova 15.185.141.14 nova 00:01 SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted
Query 121752 Sending data nova 15.185.141.20 nova 00:01 SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted
Query 121699 Sending data nova 15.185.141.22 nova 00:01 SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted
Query 122066 Sending data nova 15.185.141.22 nova 00:01 SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted
Query 122171 Sending data nova 15.185.141.25 nova 00:01 SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted
Query 122089 Sending data nova 15.185.141.36 nova 00:01 SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted
Query 121229 Sending data nova 15.185.141.74 nova 00:01 SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted
Query 121388 Sending data nova 15.185.140.10 nova 00:00 SELECT anon_1.fixed_ips_created_at AS anon_1_fixed_ips_created_at, anon_1.fixed_ips_updated_at AS anon_1_fixed_ips_updated_at, anon_1.fixed_ips_deleted_at AS anon
Query 121369 statistics nova 15.185.140.11 nova 00:00 SELECT anon_1.fixed_ips_created_at AS anon_1_fixed_ips_created_at, anon_1.fixed_ips_updated_at AS anon_1_fixed_ips_updated_at, anon_1.fixed_ips_deleted_at AS anon
Query 121936 Sending data nova 15.185.140.11 nova 00:00 SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted
Query 121379 Sending data nova 15.185.140.13 nova 00:00 SELECT anon_1.fixed_ips_created_at AS anon_1_fixed_ips_created_at, anon_1.fixed_ips_updated_at AS anon_1_fixed_ips_updated_at, anon_1.fixed_ips_deleted_at AS anon
Query 122331 Sending data nova 15.185.140.13 nova 00:00 SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted
Query 121394 Sending data nova 15.185.140.13 nova 00:00 SELECT anon_1.fixed_ips_created_at AS anon_1_fixed_ips_created_at, anon_1.fixed_ips_updated_at AS anon_1_fixed_ips_updated_at, anon_1.fixed_ips_deleted_at AS anon
Query 122120 Sending data nova 15.185.140.13 nova 00:00 SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted
Query 121650 Sending data nova 15.185.140.14 nova 00:00 SELECT anon_1.fixed_ips_created_at AS anon_1_fixed_ips_created_at, anon_1.fixed_ips_updated_at AS anon_1_fixed_ips_updated_at, anon_1.fixed_ips_deleted_at AS anon
Query 121478 Updating nova 15.185.140.14 nova 00:00 UPDATE services SET updated_at='2012-03-20 20:21:59', report_count=594404 WHERE services.id = 394
Query 121989 Sending data nova 15.185.140.15 nova 00:00 SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted
Query 122164 Sending data nova 15.185.140.15 nova 00:00 SELECT anon_1.fixed_ips_created_at AS anon_1_fixed_ips_created_at, anon_1.fixed_ips_updated_at AS anon_1_fixed_ips_updated_at, anon_1.fixed_ips_deleted_at AS anon
Query 121366 Sending data nova 15.185.140.15 nova 00:00 SELECT anon_1.fixed_ips_created_at AS anon_1_fixed_ips_created_at, anon_1.fixed_ips_updated_at AS anon_1_fixed_ips_updated_at, anon_1.fixed_ips_deleted_at AS anon
Query 121333 Sending data nova 15.185.140.15 nova 00:00 SELECT anon_1.fixed_ips_created_at AS anon_1_fixed_ips_created_at, anon_1.fixed_ips_updated_at AS anon_1_fixed_ips_updated_at, anon_1.fixed_ips_deleted_at AS anon
Query 121604 Sending data nova 15.185.140.15 nova 00:00 SELECT anon_1.fixed_ips_created_at AS anon_1_fixed_ips_created_at, anon_1.fixed_ips_updated_at AS anon_1_fixed_ips_updated_at, anon_1.fixed_ips_deleted_at AS anon
Query 121344 Sending data nova 15.185.140.15 nova 00:00 SELECT anon_1.fixed_ips_created_at AS anon_1_fixed_ips_created_at, anon_1.fixed_ips_updated_at AS anon_1_fixed_ips_updated_at, anon_1.fixed_ips_deleted_at AS anon
Query 121410 Sending data nova 15.185.140.16 nova 00:00 SELECT anon_1.services_created_at AS anon_1_services_created_at, anon_1.services_updated_at AS anon_1_services_updated_at, anon_1.services_deleted_at AS anon_1_se
Query 121557 Updating nova 15.185.140.16 nova 00:00 UPDATE fixed_ips SET updated_at='2012-03-20 20:21:59' WHERE fixed_ips.id = 130058
Query 121869 Sending data nova 15.185.140.18 nova 00:00 SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted
Query 121536 Sending data nova 15.185.140.19 nova 00:00 SELECT anon_1.fixed_ips_created_at AS anon_1_fixed_ips_created_at, anon_1.fixed_ips_updated_at AS anon_1_fixed_ips_updated_at, anon_1.fixed_ips_deleted_at AS anon
Query 121311 Sending data nova 15.185.140.19 nova 00:00 SELECT anon_1.fixed_ips_created_at AS anon_1_fixed_ips_created_at, anon_1.fixed_ips_updated_at AS anon_1_fixed_ips_updated_at, anon_1.fixed_ips_deleted_at AS anon
Query 121298 Sending data nova 15.185.140.19 nova 00:00 SELECT anon_1.fixed_ips_created_at AS anon_1_fixed_ips_created_at, anon_1.fixed_ips_updated_at AS anon_1_fixed_ips_updated_at, anon_1.fixed_ips_deleted_at AS anon
Query 122082 Sending data nova 15.185.140.20 nova 00:00 SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted
Query 121381 Sending data nova 15.185.140.20 nova 00:00 SELECT anon_1.fixed_ips_created_at AS anon_1_fixed_ips_created_at, anon_1.fixed_ips_updated_at AS anon_1_fixed_ips_updated_at, anon_1.fixed_ips_deleted_at AS anon
Query 121518 Sending data nova 15.185.140.21 nova 00:00 SELECT anon_1.fixed_ips_created_at AS anon_1_fixed_ips_created_at, anon_1.fixed_ips_updated_at AS anon_1_fixed_ips_updated_at, anon_1.fixed_ips_deleted_at AS anon
Query 121414 Sending data nova 15.185.140.22 nova 00:00 SELECT anon_1.fixed_ips_created_at AS anon_1_fixed_ips_created_at, anon_1.fixed_ips_updated_at AS anon_1_fixed_ips_updated_at, anon_1.fixed_ips_deleted_at AS anon
Query 122064 statistics nova 15.185.140.23 nova 00:00 SELECT anon_1.services_created_at AS anon_1_services_created_at, anon_1.services_updated_at AS anon_1_services_updated_at, anon_1.services_deleted_at AS anon_1_se
Query 121462 Sending data nova 15.185.140.24 nova 00:00 SELECT anon_1.fixed_ips_created_at AS anon_1_fixed_ips_created_at, anon_1.fixed_ips_updated_at AS anon_1_fixed_ips_updated_at, anon_1.fixed_ips_deleted_at AS anon
Query 122312 Sending data nova 15.185.140.24 nova 00:00 SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted AS ser
Query 122122 Sending data nova 15.185.140.25 nova 00:00 SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted AS ser
Query 121615 Sending data nova 15.185.140.29 nova 00:00 SELECT anon_1.services_created_at AS anon_1_services_created_at, anon_1.services_updated_at AS anon_1_services_updated_at, anon_1.services_deleted_at AS anon_1_se
Query 121496 Sending data nova 15.185.140.35 nova 00:00 SELECT anon_1.fixed_ips_created_at AS anon_1_fixed_ips_created_at, anon_1.fixed_ips_updated_at AS anon_1_fixed_ips_updated_at, anon_1.fixed_ips_deleted_at AS anon
Query 122254 Sending data nova 15.185.140.46 nova 00:00 SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted