Slide 19
Slide 19 text
[11 Jul 2012 00:08:42.066] [WARN.org.dasein.persist.jdbc.Loader] SLOW QUERY: SELECT
`region`.`account`, `region`.`active`, `region`.`keypair`, `region`.`provider_region`,
`region`.`provider_region_id`, `region`.`region_id` FROM `region` WHERE `region`.`account`
= ? ORDER BY `region`.`provider_region_id`
[11 Jul 2012 00:08:42.116] [WARN.org.dasein.persist.jdbc.Loader] SLOW QUERY: SELECT
`region`.`account`, `region`.`active`, `region`.`keypair`, `region`.`provider_region`,
`region`.`provider_region_id`, `region`.`region_id` FROM `region` WHERE `region`.`account`
= ? ORDER BY `region`.`provider_region_id`
[11 Jul 2012 00:08:42.105] [WARN.org.dasein.persist.jdbc.Loader] SLOW QUERY: SELECT
`region`.`account`, `region`.`active`, `region`.`keypair`, `region`.`provider_region`,
`region`.`provider_region_id`, `region`.`region_id` FROM `region` WHERE `region`.`account`
= ? ORDER BY `region`.`provider_region_id`
[11 Jul 2012 00:08:42.105] [WARN.org.dasein.persist.jdbc.Loader] SLOW QUERY: SELECT
`region`.`account`, `region`.`active`, `region`.`keypair`, `region`.`provider_region`,
`region`.`provider_region_id`, `region`.`region_id` FROM `region` WHERE `region`.`account`
= ? ORDER BY `region`.`provider_region_id`
[11 Jul 2012 00:08:42.140] [WARN.org.dasein.persist.jdbc.Loader] SLOW QUERY: SELECT
`region`.`account`, `region`.`active`, `region`.`keypair`, `region`.`provider_region`,
`region`.`provider_region_id`, `region`.`region_id` FROM `region` WHERE `region`.`account`
= ? ORDER BY `region`.`provider_region_id`
[11 Jul 2012 00:39:02.078] [WARN.org.dasein.persist.jdbc.Loader] SLOW QUERY: SELECT
`provider_rdbms`.`admin_user`, `provider_rdbms`.`cloud_id`,
`provider_rdbms`.`creation_timestamp`, `provider_rdbms`.`current_state`,
`provider_rdbms`.`database_engine`, `provider_rdbms`.`description`,
`provider_rdbms`.`dns_name`, `provider_rdbms`.`enstratus_rdbms_id`, `provider_rdbms`.`ha`,
`provider_rdbms`.`host_port`, `provider_rdbms`.`maintenance_end_day`,
`provider_rdbms`.`maintenance_end_hour`, `provider_rdbms`.`maintenance_end_minute`,
`provider_rdbms`.`maintenance_start_day`, `provider_rdbms`.`maintenance_start_hour`,
`provider_rdbms`.`maintenance_start_minute`, `provider_rdbms`.`name`,
`provider_rdbms`.`product_size`, `provider_rdbms`.`provider_configuration_id`,
`provider_rdbms`.`provider_data_center_id`, `provider_rdbms`.`provider_owner_id`,
`provider_rdbms`.`provider_rdbms_id`, `provider_rdbms`.`provider_region_id`,
`provider_rdbms`.`recovery_point_timestamp`, `provider_rdbms`.`snapshot_end_day`,
`provider_rdbms`.`snapshot_end_hour`, `provider_rdbms`.`snapshot_end_minute`,
`provider_rdbms`.`snapshot_retention_in_days`, `provider_rdbms`.`snapshot_start_day`,
`provider_rdbms`.`snapshot_start_hour`, `provider_rdbms`.`snapshot_start_minute`,
`provider_rdbms`.`storage_in_gb` FROM `provider_rdbms` WHERE `provider_rdbms`.`cloud_id` = ?
AND `provider_rdbms`.`provider_owner_id` = ? AND `provider_rdbms`.`provider_region_id` = ?
AND `provider_rdbms`.`provider_rdbms_id` = ?