### 19 Queries ### Total time: 36.450469, Average time: 1.91844573684211 ### Taking 1.130470 to 3.415844 seconds to complete ### Rows analyzed 0 - 161 # User@Host: root[root] @ localhost [] # User@Host: root[root] @ localhost [] ### 19 Queries ### Total time: 28.491637, Average time: 1.49955984210526 ### Taking 1.008438 to 3.069463 seconds to complete ### Rows analyzed 0 - 131764 # User@Host: dbXXX_ecology[dbXXX_ecology] @ [XXX.XXX.XXX.XXX] # User@Host: db188109_ecology[db188109_ecology] @ [205.186.184.35] ### 10 Queries ### Total time: 17.17822, Average time: 1.717822 ### Taking 1.148817 , 1.264682 , 1.382759 , 1.397646 , 1.408770 , 1.502208 , 1.946751 , 2.001801 , 2.213685 , 2.911101 seconds to complete ### Rows analyzed 23, 23, 161, 161, 161, 161, 161, 161, 161 and 161 SET timestamp=XXX; show tables; SET timestamp=1404181987; show tables; ### 5 Queries ### Total time: 9.52917, Average time: 1.905834 ### Taking 1.035640 , 1.265126 , 2.000893 , 2.377746 , 2.849765 seconds to complete ### Rows analyzed 0, 0, 0, 0 and 0 SET timestamp=XXX; SHOW TRIGGERS LIKE 'XXX'; SET timestamp=1404122164; SHOW TRIGGERS LIKE 'columns\_priv'; ### 6 Queries ### Total time: 6.660724, Average time: 1.11012066666667 ### Taking 1.008438 , 1.058027 , 1.110414 , 1.117647 , 1.173057 , 1.193141 seconds to complete ### Rows analyzed 888, 888, 891, 896, 897 and 903 SET timestamp=XXX; SELECT option_name, option_value FROM wp_XXXMayoptions WHERE autoload = 'XXX'; SET timestamp=1404176224; SELECT option_name, option_value FROM wp_2013Mayoptions WHERE autoload = 'yes'; ### 2 Queries ### Total time: 5.48295, Average time: 2.741475 ### Taking 2.067106 , 3.415844 seconds to complete ### Rows analyzed 0 and 0 SET timestamp=XXX; SELECT LOGFILE_GROUP_NAME, FILE_NAME, TOTAL_EXTENTS, INITIAL_SIZE, ENGINE, EXTRA FROM INFORMATION_SCHEMA.FILES WHERE FILE_TYPE = 'XXX' AND FILE_NAME IS NOT NULL AND LOGFILE_GROUP_NAME IN (SELECT DISTINCT LOGFILE_GROUP_NAME FROM INFORMATION_SCHEMA.FILES WHERE FILE_TYPE = 'XXX' AND TABLESPACE_NAME IN (SELECT DISTINCT TABLESPACE_NAME FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_SCHEMA IN ('XXX'))) GROUP BY LOGFILE_GROUP_NAME, FILE_NAME, ENGINE ORDER BY LOGFILE_GROUP_NAME; SET timestamp=1404121444; SELECT LOGFILE_GROUP_NAME, FILE_NAME, TOTAL_EXTENTS, INITIAL_SIZE, ENGINE, EXTRA FROM INFORMATION_SCHEMA.FILES WHERE FILE_TYPE = 'UNDO LOG' AND FILE_NAME IS NOT NULL AND LOGFILE_GROUP_NAME IN (SELECT DISTINCT LOGFILE_GROUP_NAME FROM INFORMATION_SCHEMA.FILES WHERE FILE_TYPE = 'DATAFILE' AND TABLESPACE_NAME IN (SELECT DISTINCT TABLESPACE_NAME FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_SCHEMA IN ('mysql'))) GROUP BY LOGFILE_GROUP_NAME, FILE_NAME, ENGINE ORDER BY LOGFILE_GROUP_NAME; ### 2 Queries ### Total time: 5.445044, Average time: 2.722522 ### Taking 2.375581 , 3.069463 seconds to complete ### Rows analyzed 131764 and 131764 SET timestamp=XXX; SELECT /*!XXX SQL_NO_CACHE */ * FROM `wp_XXXMaymgk_accessed_urls`; SET timestamp=1404147692; SELECT /*!40001 SQL_NO_CACHE */ * FROM `wp_2013Maymgk_accessed_urls`; ### 3 Queries ### Total time: 5.18545, Average time: 1.72848333333333 ### Taking 1.130470 , 1.595269 , 2.459711 seconds to complete ### Rows analyzed 22, 22 and 22 SET timestamp=XXX; show fields from `db`; SET timestamp=1404121144; show fields from `db`; ### 2 Queries ### Total time: 3.913579, Average time: 1.9567895 ### Taking 1.028926 , 2.884653 seconds to complete ### Rows analyzed 0 and 0 SET timestamp=XXX; INSERT INTO `wp_XXXMayoptions` (`option_name`, `option_value`, `autoload`) VALUES ('XXX', 'XXX', 'XXX') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`); SET timestamp=1404168842; INSERT INTO `wp_2013Mayoptions` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_doing_cron', '1404168841.5084440708160400390625', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`); ### 2 Queries ### Total time: 3.516536, Average time: 1.758268 ### Taking 1.181518 , 2.335018 seconds to complete ### Rows analyzed 22 and 22 SET timestamp=XXX; show fields from `event`; SET timestamp=1404119405; show fields from `event`; ### 2 Queries ### Total time: 3.491041, Average time: 1.7455205 ### Taking 1.637582 , 1.853459 seconds to complete ### Rows analyzed 7 and 7 SET timestamp=XXX; show fields from `columns_priv`; SET timestamp=1404121323; show fields from `columns_priv`; ### 2 Queries ### Total time: 2.610937, Average time: 1.3054685 ### Taking 1.051961 , 1.558976 seconds to complete ### Rows analyzed 0 and 0 SET timestamp=XXX; UPDATE `wp_XXXMayoptions` SET `option_value` = 'XXX' WHERE `option_name` = 'XXX'; SET timestamp=1404161343; UPDATE `wp_2013Mayoptions` SET `option_value` = '1404766142' WHERE `option_name` = '_transient_timeout_dlm_categories'; ### 1 Query ### Total time: 2.135657, Average time: 2.135657 ### Taking 2.135657 seconds to complete ### Rows analyzed 5 SET timestamp=XXX; show fields from `time_zone_transition_type`; SET timestamp=1404121203; show fields from `time_zone_transition_type`; ### 1 Query ### Total time: 1.455787, Average time: 1.455787 ### Taking 1.455787 seconds to complete ### Rows analyzed 0 SET timestamp=XXX; SELECT DISTINCT TABLESPACE_NAME, FILE_NAME, LOGFILE_GROUP_NAME, EXTENT_SIZE, INITIAL_SIZE, ENGINE FROM INFORMATION_SCHEMA.FILES WHERE FILE_TYPE = 'XXX' AND TABLESPACE_NAME IN (SELECT DISTINCT TABLESPACE_NAME FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_SCHEMA IN ('XXX')) ORDER BY TABLESPACE_NAME, LOGFILE_GROUP_NAME; SET timestamp=1404121564; SELECT DISTINCT TABLESPACE_NAME, FILE_NAME, LOGFILE_GROUP_NAME, EXTENT_SIZE, INITIAL_SIZE, ENGINE FROM INFORMATION_SCHEMA.FILES WHERE FILE_TYPE = 'DATAFILE' AND TABLESPACE_NAME IN (SELECT DISTINCT TABLESPACE_NAME FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_SCHEMA IN ('mysql')) ORDER BY TABLESPACE_NAME, LOGFILE_GROUP_NAME; ### 1 Query ### Total time: 1.265493, Average time: 1.265493 ### Taking 1.265493 seconds to complete ### Rows analyzed 889 use dbXXX_influenceecology_wp; SET timestamp=XXX; SELECT option_name, option_value FROM wp_XXXMayoptions WHERE autoload = 'XXX'; use db188109_influenceecology_wp; SET timestamp=1404129903; SELECT option_name, option_value FROM wp_2013Mayoptions WHERE autoload = 'yes'; ### 1 Query ### Total time: 1.24649, Average time: 1.24649 ### Taking 1.246490 seconds to complete ### Rows analyzed 23 use mysql; SET timestamp=XXX; show tables; use mysql; SET timestamp=1404118810; show tables; ### 1 Query ### Total time: 1.134281, Average time: 1.134281 ### Taking 1.134281 seconds to complete ### Rows analyzed 161 use dbXXX_influenceecology_wp; SET timestamp=XXX; show tables; use db188109_influenceecology_wp; SET timestamp=1404118025; show tables;