数据库基本知识在各行各业，都是必须要掌握的基本技能呀。
今天在家休息一天，作了几个样例测试。
参考书籍是 MYSQL COOKBOOK第二版。
服务器端是MYSQL SERVER5.5.
CLIENT为SQLYOG 8.7.
~~~~~~~
/*[8:21:21][ 78 ms]*/ SHOW VARIABLES LIKE 'lower_case_table_names';
/*[8:21:21][ 15 ms]*/ SET NAMES 'utf8';
/*[8:21:21][ 0 ms]*/ SET SQL_MODE='';
/*[8:21:21][ 16 ms]*/ SHOW DATABASES;
/*[8:37:03][ 0 ms]*/ SELECT DATABASE();
/*[8:37:14][ 0 ms]*/ SHOW CHARSET;
/*[8:37:14][ 0 ms]*/ SHOW COLLATION;
/*[8:37:23][ 0 ms]*/ CREATE DATABASE `cookbook`;
/*[8:37:24][ 0 ms]*/ USE `cookbook`;
/*[8:37:24][ 0 ms]*/ SHOW DATABASES;
/*[8:37:24][ 0 ms]*/ USE `cookbook`;
/*[8:37:32][ 0 ms]*/ USE cookbook;
/*[8:37:32][ 0 ms]*/ SELECT DATABASE();
/*[8:37:38][ 0 ms]*/ SELECT DATABASE();
/*[8:38:19][ 16 ms]*/ SHOW VARIABLES LIKE 'profiling';
/*[8:38:19][ 0 ms]*/ SET PROFILING = 1;
/*[8:38:19][ 0 ms]*/ SET profiling_history_size = 0;
/*[8:38:19][ 0 ms]*/ SET profiling_history_size = 15;
/*[8:38:19][ 0 ms]*/ SHOW STATUS;
/*[8:38:19][ 0 ms]*/ SHOW STATUS;
/*[8:38:19][ 0 ms]*/ SELECT * FROM taxpayer LIMIT 0, 1000;
/*[8:38:19][ 0 ms]*/ SHOW STATUS;
/*[8:38:19][ 0 ms]*/ SHOW PROFILES;
/*[8:38:19][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 5 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[8:38:19][ 0 ms]*/ SET PROFILING = 0;
/*[8:38:19][ 0 ms]*/ EXPLAIN SELECT * FROM taxpayer LIMIT 0, 1000;
/*[8:38:47][ 0 ms]*/ SET PROFILING = 1;
/*[8:38:47][ 0 ms]*/ SET profiling_history_size = 0;
/*[8:38:47][ 0 ms]*/ SET profiling_history_size = 15;
/*[8:38:47][ 15 ms]*/ SHOW STATUS;
/*[8:38:47][ 0 ms]*/ SELECT * FROM taxpayer WHERE id = NULL LIMIT 0, 1000;
/*[8:38:47][ 0 ms]*/ SHOW STATUS;
/*[8:38:47][ 0 ms]*/ SHOW PROFILES;
/*[8:38:47][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 11 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[8:38:47][ 0 ms]*/ SET PROFILING = 0;
/*[8:38:47][ 0 ms]*/ EXPLAIN SELECT * FROM taxpayer WHERE id = NULL LIMIT 0, 1000;
/*[8:38:48][ 0 ms]*/ SET PROFILING = 1;
/*[8:38:48][ 0 ms]*/ SET profiling_history_size = 0;
/*[8:38:48][ 0 ms]*/ SET profiling_history_size = 15;
/*[8:38:48][ 0 ms]*/ SHOW STATUS;
/*[8:38:48][ 16 ms]*/ SELECT * FROM taxpayer WHERE id = NULL LIMIT 0, 1000;
/*[8:38:48][ 0 ms]*/ SHOW STATUS;
/*[8:38:48][ 0 ms]*/ SHOW PROFILES;
/*[8:38:48][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 17 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[8:38:48][ 0 ms]*/ SET PROFILING = 0;
/*[8:38:48][ 16 ms]*/ EXPLAIN SELECT * FROM taxpayer WHERE id = NULL LIMIT 0, 1000;
/*[8:38:54][ 0 ms]*/ SET PROFILING = 1;
/*[8:38:54][ 0 ms]*/ SET profiling_history_size = 0;
/*[8:38:54][ 0 ms]*/ SET profiling_history_size = 15;
/*[8:38:54][ 15 ms]*/ SHOW STATUS;
/*[8:38:54][ 0 ms]*/ SELECT * FROM taxpayer WHERE id != NULL LIMIT 0, 1000;
/*[8:38:54][ 0 ms]*/ SHOW STATUS;
/*[8:38:54][ 0 ms]*/ SHOW PROFILES;
/*[8:38:54][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 23 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[8:38:54][ 0 ms]*/ SET PROFILING = 0;
/*[8:38:54][ 0 ms]*/ EXPLAIN SELECT * FROM taxpayer WHERE id != NULL LIMIT 0, 1000;
/*[8:38:54][ 0 ms]*/ SET PROFILING = 1;
/*[8:38:54][ 0 ms]*/ SET profiling_history_size = 0;
/*[8:38:54][ 0 ms]*/ SET profiling_history_size = 15;
/*[8:38:54][ 16 ms]*/ SHOW STATUS;
/*[8:38:54][ 0 ms]*/ SELECT * FROM taxpayer WHERE id != NULL LIMIT 0, 1000;
/*[8:38:54][ 0 ms]*/ SHOW STATUS;
/*[8:38:54][ 0 ms]*/ SHOW PROFILES;
/*[8:38:54][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 29 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[8:38:54][ 16 ms]*/ SET PROFILING = 0;
/*[8:38:54][ 0 ms]*/ EXPLAIN SELECT * FROM taxpayer WHERE id != NULL LIMIT 0, 1000;
/*[8:39:16][ 0 ms]*/ SET PROFILING = 1;
/*[8:39:16][ 0 ms]*/ SET profiling_history_size = 0;
/*[8:39:16][ 0 ms]*/ SET profiling_history_size = 15;
/*[8:39:16][ 15 ms]*/ SHOW STATUS;
/*[8:39:16][ 0 ms]*/ SELECT * FROM taxpayer WHERE id IS NULL LIMIT 0, 1000;
/*[8:39:16][ 16 ms]*/ SHOW STATUS;
/*[8:39:16][ 0 ms]*/ SHOW PROFILES;
/*[8:39:16][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 35 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[8:39:16][ 0 ms]*/ SET PROFILING = 0;
/*[8:39:16][ 0 ms]*/ EXPLAIN SELECT * FROM taxpayer WHERE id IS NULL LIMIT 0, 1000;
/*[8:39:22][ 0 ms]*/ SET PROFILING = 1;
/*[8:39:22][ 0 ms]*/ SET profiling_history_size = 0;
/*[8:39:22][ 15 ms]*/ SET profiling_history_size = 15;
/*[8:39:22][ 0 ms]*/ SHOW STATUS;
/*[8:39:22][ 0 ms]*/ SELECT * FROM taxpayer WHERE id NOT IS NULL LIMIT 0, 1000;
/*[8:39:32][ 0 ms]*/ SET PROFILING = 1;
/*[8:39:32][ 0 ms]*/ SET profiling_history_size = 0;
/*[8:39:32][ 0 ms]*/ SET profiling_history_size = 15;
/*[8:39:32][ 15 ms]*/ SHOW STATUS;
/*[8:39:32][ 0 ms]*/ SELECT * FROM taxpayer WHERE id !IS NULL LIMIT 0, 1000;
/*[8:39:32][ 15 ms]*/ SET PROFILING = 1;
/*[8:39:32][ 0 ms]*/ SET profiling_history_size = 0;
/*[8:39:32][ 0 ms]*/ SET profiling_history_size = 15;
/*[8:39:32][ 0 ms]*/ SHOW STATUS;
/*[8:39:32][ 0 ms]*/ SELECT * FROM taxpayer WHERE id !IS NULL LIMIT 0, 1000;
/*[8:39:44][ 0 ms]*/ SET PROFILING = 1;
/*[8:39:44][ 0 ms]*/ SET profiling_history_size = 0;
/*[8:39:44][ 0 ms]*/ SET profiling_history_size = 15;
/*[8:39:44][ 0 ms]*/ SHOW STATUS;
/*[8:39:44][ 0 ms]*/ SELECT * FROM taxpayer WHERE id IS NOT NULL LIMIT 0, 1000;
/*[8:39:44][ 16 ms]*/ SHOW STATUS;
/*[8:39:44][ 0 ms]*/ SHOW PROFILES;
/*[8:39:44][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 56 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[8:39:44][ 0 ms]*/ SET PROFILING = 0;
/*[8:39:44][ 0 ms]*/ EXPLAIN SELECT * FROM taxpayer WHERE id IS NOT NULL LIMIT 0, 1000;
/*[8:40:21][ 0 ms]*/ SET PROFILING = 1;
/*[8:40:21][ 0 ms]*/ SET profiling_history_size = 0;
/*[8:40:21][ 0 ms]*/ SET profiling_history_size = 15;
/*[8:40:21][ 16 ms]*/ SHOW STATUS;
/*[8:40:21][ 16 ms]*/ SELECT * FROM taxpayer WHERE id <=> NULL LIMIT 0, 1000;
/*[8:40:21][ 0 ms]*/ SHOW STATUS;
/*[8:40:21][ 0 ms]*/ SHOW PROFILES;
/*[8:40:21][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 62 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[8:40:21][ 0 ms]*/ SET PROFILING = 0;
/*[8:40:21][ 0 ms]*/ EXPLAIN SELECT * FROM taxpayer WHERE id <=> NULL LIMIT 0, 1000;
/*[8:40:27][ 0 ms]*/ SET PROFILING = 1;
/*[8:40:27][ 0 ms]*/ SET profiling_history_size = 0;
/*[8:40:27][ 0 ms]*/ SET profiling_history_size = 15;
/*[8:40:27][ 15 ms]*/ SHOW STATUS;
/*[8:40:27][ 0 ms]*/ SELECT * FROM taxpayer WHERE id <!=> NULL LIMIT 0, 1000;
/*[8:40:32][ 0 ms]*/ SET PROFILING = 1;
/*[8:40:32][ 0 ms]*/ SET profiling_history_size = 0;
/*[8:40:32][ 0 ms]*/ SET profiling_history_size = 15;
/*[8:40:32][ 16 ms]*/ SHOW STATUS;
/*[8:40:32][ 0 ms]*/ SELECT * FROM taxpayer WHERE id !<=> NULL LIMIT 0, 1000;
/*[8:40:33][ 0 ms]*/ SET PROFILING = 1;
/*[8:40:33][ 0 ms]*/ SET profiling_history_size = 0;
/*[8:40:33][ 0 ms]*/ SET profiling_history_size = 15;
/*[8:40:33][ 16 ms]*/ SHOW STATUS;
/*[8:40:33][ 0 ms]*/ SELECT * FROM taxpayer WHERE id !<=> NULL LIMIT 0, 1000;
/*[8:41:01][ 0 ms]*/ SET PROFILING = 1;
/*[8:41:01][ 0 ms]*/ SET profiling_history_size = 0;
/*[8:41:01][ 0 ms]*/ SET profiling_history_size = 15;
/*[8:41:01][ 16 ms]*/ SHOW STATUS;
/*[8:41:01][ 0 ms]*/ SELECT NULL = NULL ,NULL <=> NULL;
/*[8:41:01][ 0 ms]*/ SHOW STATUS;
/*[8:41:01][ 0 ms]*/ SHOW PROFILES;
/*[8:41:01][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 83 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[8:41:01][ 0 ms]*/ SET PROFILING = 0;
/*[8:41:01][ 0 ms]*/ EXPLAIN SELECT NULL = NULL ,NULL <=> NULL;
/*[8:42:05][ 0 ms]*/ SET PROFILING = 1;
/*[8:42:05][ 0 ms]*/ SET profiling_history_size = 0;
/*[8:42:05][ 0 ms]*/ SET profiling_history_size = 15;
/*[8:42:05][ 16 ms]*/ SHOW STATUS;
/*[8:42:05][ 0 ms]*/ SELECT NAME,IF(id IS NULL,'Unkown',id) AS 'id' FROM taxpayer LIMIT 0, 1000;
/*[8:42:05][ 15 ms]*/ SHOW STATUS;
/*[8:42:05][ 0 ms]*/ SHOW PROFILES;
/*[8:42:05][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 89 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[8:42:05][ 0 ms]*/ SET PROFILING = 0;
/*[8:42:05][ 0 ms]*/ EXPLAIN SELECT NAME,IF(id IS NULL,'Unkown',id) AS 'id' FROM taxpayer LIMIT 0, 1000;
/*[8:43:44][ 0 ms]*/ SET PROFILING = 1;
/*[8:43:44][ 0 ms]*/ SET profiling_history_size = 0;
/*[8:43:44][ 0 ms]*/ SET profiling_history_size = 15;
/*[8:43:44][ 0 ms]*/ SHOW STATUS;
/*[8:43:44][ 0 ms]*/ SELECT NAME,IFNULL(id ,'Unkown',) AS 'id' FROM taxpayer LIMIT 0, 1000;
/*[8:43:49][ 0 ms]*/ SET PROFILING = 1;
/*[8:43:49][ 0 ms]*/ SET profiling_history_size = 0;
/*[8:43:49][ 0 ms]*/ SET profiling_history_size = 15;
/*[8:43:49][ 15 ms]*/ SHOW STATUS;
/*[8:43:49][ 16 ms]*/ SELECT NAME,IFNULL(id ,'Unkown') AS 'id' FROM taxpayer LIMIT 0, 1000;
/*[8:43:49][ 0 ms]*/ SHOW STATUS;
/*[8:43:49][ 0 ms]*/ SHOW PROFILES;
/*[8:43:49][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 100 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[8:43:49][ 0 ms]*/ SET PROFILING = 0;
/*[8:43:49][ 0 ms]*/ EXPLAIN SELECT NAME,IFNULL(id ,'Unkown') AS 'id' FROM taxpayer LIMIT 0, 1000;
/*[8:46:24][ 0 ms]*/ SELECT DATABASE();
/*[8:46:43][ 0 ms]*/ SET PROFILING = 1;
/*[8:46:43][ 0 ms]*/ SET profiling_history_size = 0;
/*[8:46:43][ 0 ms]*/ SET profiling_history_size = 15;
/*[8:46:43][ 0 ms]*/ SHOW STATUS;
/*[8:46:43][ 0 ms]*/ SELECT * FROM mail LIMIT 0, 1000;
/*[8:46:43][ 0 ms]*/ SHOW STATUS;
/*[8:46:43][ 0 ms]*/ SHOW PROFILES;
/*[8:46:43][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 106 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[8:46:43][ 15 ms]*/ SET PROFILING = 0;
/*[8:46:43][ 0 ms]*/ EXPLAIN SELECT * FROM mail LIMIT 0, 1000;
/*[8:47:13][ 0 ms]*/ SET PROFILING = 1;
/*[8:47:13][ 0 ms]*/ SET profiling_history_size = 0;
/*[8:47:13][ 0 ms]*/ SET profiling_history_size = 15;
/*[8:47:13][ 0 ms]*/ SHOW STATUS;
/*[8:47:13][ 0 ms]*/ SELECT * FROM mail WHERE size > 100000 ORDER BY size LIMIT 0, 1000;
/*[8:47:13][ 15 ms]*/ SHOW STATUS;
/*[8:47:13][ 0 ms]*/ SHOW PROFILES;
/*[8:47:13][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 112 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[8:47:13][ 0 ms]*/ SET PROFILING = 0;
/*[8:47:13][ 0 ms]*/ EXPLAIN SELECT * FROM mail WHERE size > 100000 ORDER BY size LIMIT 0, 1000;
/*[8:47:19][ 0 ms]*/ SET PROFILING = 1;
/*[8:47:19][ 0 ms]*/ SET profiling_history_size = 0;
/*[8:47:19][ 0 ms]*/ SET profiling_history_size = 15;
/*[8:47:19][ 0 ms]*/ SHOW STATUS;
/*[8:47:19][ 0 ms]*/ SELECT * FROM mail WHERE size > 100000 ORDER BY size DESC LIMIT 0, 1000;
/*[8:47:19][ 0 ms]*/ SHOW STATUS;
/*[8:47:19][ 0 ms]*/ SHOW PROFILES;
/*[8:47:19][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 118 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[8:47:19][ 0 ms]*/ SET PROFILING = 0;
/*[8:47:19][ 0 ms]*/ EXPLAIN SELECT * FROM mail WHERE size > 100000 ORDER BY size DESC LIMIT 0, 1000;
/*[8:48:27][ 0 ms]*/ SET PROFILING = 1;
/*[8:48:27][ 0 ms]*/ SET profiling_history_size = 0;
/*[8:48:27][ 0 ms]*/ SET profiling_history_size = 15;
/*[8:48:27][ 0 ms]*/ SHOW STATUS;
/*[8:48:27][ 0 ms]*/ SELECT * FROM mail WHERE dstuser = 'tricia' ORDER BY srchost,srcuser LIMIT 0, 1000;
/*[8:48:27][ 15 ms]*/ SHOW STATUS;
/*[8:48:27][ 0 ms]*/ SHOW PROFILES;
/*[8:48:27][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 124 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[8:48:27][ 0 ms]*/ SET PROFILING = 0;
/*[8:48:27][ 0 ms]*/ EXPLAIN SELECT * FROM mail WHERE dstuser = 'tricia' ORDER BY srchost,srcuser LIMIT 0, 1000;
/*[8:49:15][ 0 ms]*/ SET PROFILING = 1;
/*[8:49:15][ 0 ms]*/ SET profiling_history_size = 0;
/*[8:49:15][ 0 ms]*/ SET profiling_history_size = 15;
/*[8:49:15][ 0 ms]*/ SHOW STATUS;
/*[8:49:15][ 0 ms]*/ SELECT * FROM mail WHERE dstuser = 'tricia' ORDER BY srchost,srcuser DESC LIMIT 0, 1000;
/*[8:49:15][ 0 ms]*/ SHOW STATUS;
/*[8:49:15][ 16 ms]*/ SHOW PROFILES;
/*[8:49:15][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 130 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[8:49:15][ 0 ms]*/ SET PROFILING = 0;
/*[8:49:15][ 0 ms]*/ EXPLAIN SELECT * FROM mail WHERE dstuser = 'tricia' ORDER BY srchost,srcuser DESC LIMIT 0, 1000;
/*[8:52:22][ 0 ms]*/ SET PROFILING = 1;
/*[8:52:22][ 0 ms]*/ SET profiling_history_size = 0;
/*[8:52:22][ 15 ms]*/ SET profiling_history_size = 15;
/*[8:52:22][ 0 ms]*/ SHOW STATUS;
/*[8:52:22][ 0 ms]*/ SELECT DATE_FORMAT(t,'%M %e, %Y') AS date_sent, CONCAT(srcuser,'@',srchost) AS sender, CONCAT(dstuser,'@',dsthost) AS recipient, size FROM mail LIMIT 0, 1000;
/*[8:52:22][ 16 ms]*/ SHOW STATUS;
/*[8:52:22][ 0 ms]*/ SHOW PROFILES;
/*[8:52:22][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 136 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[8:52:22][ 0 ms]*/ SET PROFILING = 0;
/*[8:52:22][ 0 ms]*/ EXPLAIN SELECT DATE_FORMAT(t,'%M %e, %Y') AS date_sent, CONCAT(srcuser,'@',srchost) AS sender, CONCAT(dstuser,'@',dsthost) AS recipient, size FROM mail LIMIT 0, 1000;
/*[8:53:42][ 47 ms]*/ CREATE VIEW mail_view AS SELECT DATE_FORMAT(t,'%M %e, %Y') AS date_sent, CONCAT(srcuser,'@',srchost) AS sender, CONCAT(dstuser,'@',dsthost) AS recipient, size FROM mail;
/*[8:53:54][ 0 ms]*/ SELECT `TABLE_NAME` FROM `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA` = 'cookbook' AND `TABLE_TYPE` = 'VIEW';
/*[8:53:58][ 15 ms]*/ SHOW FULL TABLES FROM `cookbook` WHERE table_type = 'BASE TABLE';
/*[8:54:01][ 31 ms]*/ DESCRIBE `cookbook`.`mail`;
/*[8:54:01][ 32 ms]*/ SHOW INDEX FROM `cookbook`.`mail`;
/*[8:54:57][ 0 ms]*/ SET PROFILING = 1;
/*[8:54:57][ 0 ms]*/ SET profiling_history_size = 0;
/*[8:54:57][ 0 ms]*/ SET profiling_history_size = 15;
/*[8:54:57][ 16 ms]*/ SHOW STATUS;
/*[8:54:57][ 0 ms]*/ SELECT date_sent,sender,size FROM mail_view WHERE size > 100000 ORDER BY size DESC LIMIT 0, 1000;
/*[8:54:57][ 16 ms]*/ SHOW STATUS;
/*[8:54:57][ 0 ms]*/ SHOW PROFILES;
/*[8:54:57][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 142 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[8:54:57][ 0 ms]*/ SET PROFILING = 0;
/*[8:54:57][ 0 ms]*/ EXPLAIN SELECT date_sent,sender,size FROM mail_view WHERE size > 100000 ORDER BY size DESC LIMIT 0, 1000;
/*[9:17:07][ 811 ms]*/ SELECT DATABASE();
/*[9:17:42][ 0 ms]*/ SELECT DATABASE();
/*[9:18:01][ 171 ms]*/ SHOW FULL TABLES FROM `cookbook` WHERE table_type = 'BASE TABLE';
/*[9:18:05][ 234 ms]*/ DESCRIBE `cookbook`.`profile`;
/*[9:18:05][ 31 ms]*/ SHOW INDEX FROM `cookbook`.`profile`;
/*[9:18:07][ 359 ms]*/ SHOW FULL FIELDS FROM `cookbook`.`profile`;
/*[9:18:07][ 0 ms]*/ SHOW KEYS FROM `cookbook`.`profile`;
/*[9:18:07][ 0 ms]*/ SELECT * FROM `cookbook`.`profile` LIMIT 0, 100;
/*[9:18:15][ 125 ms]*/ SHOW FULL FIELDS FROM `cookbook`.`profile_contact`;
/*[9:18:15][ 0 ms]*/ SHOW KEYS FROM `cookbook`.`profile_contact`;
/*[9:18:15][ 0 ms]*/ SELECT * FROM `cookbook`.`profile_contact` LIMIT 0, 100;
/*[9:18:27][ 62 ms]*/ SHOW FULL FIELDS FROM `cookbook`.`profile`;
/*[9:18:27][ 16 ms]*/ SHOW KEYS FROM `cookbook`.`profile`;
/*[9:18:27][ 0 ms]*/ SELECT * FROM `cookbook`.`profile` LIMIT 0, 100;
/*[9:20:49][ 0 ms]*/ SET PROFILING = 1;
/*[9:20:49][ 0 ms]*/ SET profiling_history_size = 0;
/*[9:20:49][ 0 ms]*/ SET profiling_history_size = 15;
/*[9:20:49][ 16 ms]*/ SHOW STATUS;
/*[9:20:49][ 0 ms]*/ SELECT id,NAME,service,contact_name FROM PROFILE INNER JOIN profile_contact ON id = profile_id LIMIT 0, 1000;
/*[9:20:49][ 0 ms]*/ SHOW STATUS;
/*[9:20:49][ 0 ms]*/ SHOW PROFILES;
/*[9:20:49][ 16 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 148 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[9:20:49][ 0 ms]*/ SET PROFILING = 0;
/*[9:20:49][ 0 ms]*/ EXPLAIN SELECT id,NAME,service,contact_name FROM PROFILE INNER JOIN profile_contact ON id = profile_id LIMIT 0, 1000;
/*[9:21:51][ 0 ms]*/ SET PROFILING = 1;
/*[9:21:51][ 0 ms]*/ SET profiling_history_size = 0;
/*[9:21:51][ 0 ms]*/ SET profiling_history_size = 15;
/*[9:21:51][ 15 ms]*/ SHOW STATUS;
/*[9:21:51][ 125 ms]*/ SELECT id,NAME,service,contact_name FROM PROFILE INNER JOIN profile_contact ON id = profile_id WHERE id > 2 AND service = 'AIM' LIMIT 0, 1000;
/*[9:21:51][ 0 ms]*/ SHOW STATUS;
/*[9:21:51][ 0 ms]*/ SHOW PROFILES;
/*[9:21:51][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 154 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[9:21:51][ 0 ms]*/ SET PROFILING = 0;
/*[9:21:51][ 16 ms]*/ EXPLAIN SELECT id,NAME,service,contact_name FROM PROFILE INNER JOIN profile_contact ON id = profile_id WHERE id > 2 AND service = 'AIM' LIMIT 0, 1000;
/*[9:22:18][ 0 ms]*/ SET PROFILING = 1;
/*[9:22:18][ 0 ms]*/ SET profiling_history_size = 0;
/*[9:22:18][ 0 ms]*/ SET profiling_history_size = 15;
/*[9:22:18][ 0 ms]*/ SHOW STATUS;
/*[9:22:18][ 16 ms]*/ SELECT id,NAME,service,contact_name FROM PROFILE INNER JOIN profile_contact ON id = profile_id WHERE id > 2 LIMIT 0, 1000;
/*[9:22:18][ 0 ms]*/ SHOW STATUS;
/*[9:22:18][ 0 ms]*/ SHOW PROFILES;
/*[9:22:18][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 160 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[9:22:18][ 0 ms]*/ SET PROFILING = 0;
/*[9:22:18][ 0 ms]*/ EXPLAIN SELECT id,NAME,service,contact_name FROM PROFILE INNER JOIN profile_contact ON id = profile_id WHERE id > 2 LIMIT 0, 1000;
/*[9:22:35][ 0 ms]*/ SET PROFILING = 1;
/*[9:22:35][ 0 ms]*/ SET profiling_history_size = 0;
/*[9:22:35][ 0 ms]*/ SET profiling_history_size = 15;
/*[9:22:35][ 0 ms]*/ SHOW STATUS;
/*[9:22:35][ 0 ms]*/ SELECT id,NAME,service,contact_name FROM PROFILE INNER JOIN profile_contact ON id = profile_id WHERE id > 1 AND service = 'AIM' LIMIT 0, 1000;
/*[9:22:35][ 16 ms]*/ SHOW STATUS;
/*[9:22:35][ 0 ms]*/ SHOW PROFILES;
/*[9:22:35][ 15 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 166 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[9:22:35][ 0 ms]*/ SET PROFILING = 0;
/*[9:22:35][ 0 ms]*/ EXPLAIN SELECT id,NAME,service,contact_name FROM PROFILE INNER JOIN profile_contact ON id = profile_id WHERE id > 1 AND service = 'AIM' LIMIT 0, 1000;
/*[9:24:54][ 0 ms]*/ SET PROFILING = 1;
/*[9:24:54][ 0 ms]*/ SET profiling_history_size = 0;
/*[9:24:54][ 0 ms]*/ SET profiling_history_size = 15;
/*[9:24:54][ 16 ms]*/ SHOW STATUS;
/*[9:24:54][ 15 ms]*/ SELECT * FROM profile_contact WHERE profile_id = (SELECT id FROM PROFILE WHERE NAME = 'Mort') LIMIT 0, 1000;
/*[9:24:54][ 0 ms]*/ SHOW STATUS;
/*[9:24:54][ 16 ms]*/ SHOW PROFILES;
/*[9:24:54][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 172 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[9:24:54][ 0 ms]*/ SET PROFILING = 0;
/*[9:24:54][ 15 ms]*/ EXPLAIN SELECT * FROM profile_contact WHERE profile_id = (SELECT id FROM PROFILE WHERE NAME = 'Mort') LIMIT 0, 1000;
/*[9:25:27][ 0 ms]*/ SET PROFILING = 1;
/*[9:25:27][ 0 ms]*/ SET profiling_history_size = 0;
/*[9:25:27][ 0 ms]*/ SET profiling_history_size = 15;
/*[9:25:27][ 15 ms]*/ SHOW STATUS;
/*[9:25:27][ 0 ms]*/ SELECT * FROM profile_contact WHERE profile_id = (SELECT id FROM PROFILE ) LIMIT 0, 1000;
/*[13:22:31][ 0 ms]*/ SET PROFILING = 1;
/*[13:22:31][ 0 ms]*/ SET profiling_history_size = 0;
/*[13:22:31][ 0 ms]*/ SET profiling_history_size = 15;
/*[13:22:31][ 0 ms]*/ SHOW STATUS;
/*[13:22:31][ 78 ms]*/ SELECT * FROM PROFILE LIMIT 0, 1000;
/*[13:22:31][ 0 ms]*/ SHOW STATUS;
/*[13:22:31][ 0 ms]*/ SHOW PROFILES;
/*[13:22:31][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 183 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[13:22:31][ 0 ms]*/ SET PROFILING = 0;
/*[13:22:31][ 16 ms]*/ EXPLAIN SELECT * FROM PROFILE LIMIT 0, 1000;
/*[13:23:05][ 0 ms]*/ SET PROFILING = 1;
/*[13:23:05][ 0 ms]*/ SET profiling_history_size = 0;
/*[13:23:05][ 0 ms]*/ SET profiling_history_size = 15;
/*[13:23:05][ 15 ms]*/ SHOW STATUS;
/*[13:23:05][ 0 ms]*/ SELECT * FROM PROFILE LIMIT 1;
/*[13:23:05][ 16 ms]*/ SHOW STATUS;
/*[13:23:05][ 0 ms]*/ SHOW PROFILES;
/*[13:23:05][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 189 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[13:23:05][ 0 ms]*/ SET PROFILING = 0;
/*[13:23:05][ 0 ms]*/ EXPLAIN SELECT * FROM PROFILE LIMIT 1;
/*[13:23:27][ 0 ms]*/ SET PROFILING = 1;
/*[13:23:27][ 0 ms]*/ SET profiling_history_size = 0;
/*[13:23:27][ 0 ms]*/ SET profiling_history_size = 15;
/*[13:23:27][ 0 ms]*/ SHOW STATUS;
/*[13:23:27][ 0 ms]*/ SELECT * FROM PROFILE LIMIT 5;
/*[13:23:27][ 16 ms]*/ SHOW STATUS;
/*[13:23:27][ 0 ms]*/ SHOW PROFILES;
/*[13:23:27][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 195 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[13:23:27][ 0 ms]*/ SET PROFILING = 0;
/*[13:23:27][ 15 ms]*/ EXPLAIN SELECT * FROM PROFILE LIMIT 5;
/*[13:24:14][ 15 ms]*/ SET PROFILING = 1;
/*[13:24:14][ 15 ms]*/ SET profiling_history_size = 0;
/*[13:24:14][ 0 ms]*/ SET profiling_history_size = 15;
/*[13:24:14][ 0 ms]*/ SHOW STATUS;
/*[13:24:14][ 0 ms]*/ SELECT * FROM PROFILE ORDER BY birth LIMIT 5;
/*[13:24:14][ 16 ms]*/ SHOW STATUS;
/*[13:24:14][ 0 ms]*/ SHOW PROFILES;
/*[13:24:14][ 15 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 201 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[13:24:14][ 0 ms]*/ SET PROFILING = 0;
/*[13:24:14][ 15 ms]*/ EXPLAIN SELECT * FROM PROFILE ORDER BY birth LIMIT 5;
/*[13:24:21][ 0 ms]*/ SET PROFILING = 1;
/*[13:24:21][ 0 ms]*/ SET profiling_history_size = 0;
/*[13:24:21][ 0 ms]*/ SET profiling_history_size = 15;
/*[13:24:21][ 0 ms]*/ SHOW STATUS;
/*[13:24:21][ 0 ms]*/ SELECT * FROM PROFILE ORDER BY birth LIMIT 1;
/*[13:24:21][ 16 ms]*/ SHOW STATUS;
/*[13:24:21][ 0 ms]*/ SHOW PROFILES;
/*[13:24:21][ 15 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 207 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[13:24:21][ 0 ms]*/ SET PROFILING = 0;
/*[13:24:21][ 0 ms]*/ EXPLAIN SELECT * FROM PROFILE ORDER BY birth LIMIT 1;
/*[13:24:40][ 0 ms]*/ SET PROFILING = 1;
/*[13:24:40][ 0 ms]*/ SET profiling_history_size = 0;
/*[13:24:40][ 16 ms]*/ SET profiling_history_size = 15;
/*[13:24:40][ 0 ms]*/ SHOW STATUS;
/*[13:24:40][ 171 ms]*/ SELECT * FROM PROFILE ORDER BY birth DESC LIMIT 1;
/*[13:24:40][ 32 ms]*/ SHOW STATUS;
/*[13:24:40][ 0 ms]*/ SHOW PROFILES;
/*[13:24:41][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 213 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[13:24:41][ 0 ms]*/ SET PROFILING = 0;
/*[13:24:41][ 0 ms]*/ EXPLAIN SELECT * FROM PROFILE ORDER BY birth DESC LIMIT 1;
/*[13:26:08][ 0 ms]*/ SET PROFILING = 1;
/*[13:26:08][ 0 ms]*/ SET profiling_history_size = 0;
/*[13:26:08][ 0 ms]*/ SET profiling_history_size = 15;
/*[13:26:08][ 16 ms]*/ SHOW STATUS;
/*[13:26:08][ 16 ms]*/ SELECT * FROM PROFILE ORDER BY birth DESC LIMIT 2-3;
/*[13:26:15][ 0 ms]*/ SET PROFILING = 1;
/*[13:26:15][ 0 ms]*/ SET profiling_history_size = 0;
/*[13:26:15][ 0 ms]*/ SET profiling_history_size = 15;
/*[13:26:15][ 16 ms]*/ SHOW STATUS;
/*[13:26:15][ 16 ms]*/ SELECT * FROM PROFILE ORDER BY birth DESC LIMIT 2,4;
/*[13:26:15][ 0 ms]*/ SHOW STATUS;
/*[13:26:15][ 0 ms]*/ SHOW PROFILES;
/*[13:26:15][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 224 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[13:26:15][ 0 ms]*/ SET PROFILING = 0;
/*[13:26:15][ 15 ms]*/ EXPLAIN SELECT * FROM PROFILE ORDER BY birth DESC LIMIT 2,4;
/*[13:28:01][ 0 ms]*/ SET PROFILING = 1;
/*[13:28:01][ 0 ms]*/ SET profiling_history_size = 0;
/*[13:28:01][ 0 ms]*/ SET profiling_history_size = 15;
/*[13:28:01][ 16 ms]*/ SHOW STATUS;
/*[13:28:01][ 31 ms]*/ SELECT COUNT(*) FROM PROFILE LIMIT 0, 1000;
/*[13:28:02][ 16 ms]*/ SHOW STATUS;
/*[13:28:02][ 0 ms]*/ SHOW PROFILES;
/*[13:28:02][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 230 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[13:28:02][ 0 ms]*/ SET PROFILING = 0;
/*[13:28:02][ 0 ms]*/ EXPLAIN SELECT COUNT(*) FROM PROFILE LIMIT 0, 1000;
/*[13:28:45][ 0 ms]*/ SET PROFILING = 1;
/*[13:28:45][ 0 ms]*/ SET profiling_history_size = 0;
/*[13:28:45][ 15 ms]*/ SET profiling_history_size = 15;
/*[13:28:45][ 0 ms]*/ SHOW STATUS;
/*[13:28:45][ 16 ms]*/ SELECT * FROM PROFILE ORDER BY NAME LIMIT 0,4;
/*[13:28:45][ 0 ms]*/ SHOW STATUS;
/*[13:28:45][ 0 ms]*/ SHOW PROFILES;
/*[13:28:45][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 236 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[13:28:45][ 0 ms]*/ SET PROFILING = 0;
/*[13:28:45][ 0 ms]*/ EXPLAIN SELECT * FROM PROFILE ORDER BY NAME LIMIT 0,4;
/*[13:28:54][ 0 ms]*/ SET PROFILING = 1;
/*[13:28:54][ 0 ms]*/ SET profiling_history_size = 0;
/*[13:28:54][ 0 ms]*/ SET profiling_history_size = 15;
/*[13:28:54][ 15 ms]*/ SHOW STATUS;
/*[13:28:54][ 0 ms]*/ SELECT * FROM PROFILE ORDER BY NAME LIMIT 4,4;
/*[13:28:54][ 0 ms]*/ SHOW STATUS;
/*[13:28:54][ 0 ms]*/ SHOW PROFILES;
/*[13:28:54][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 242 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[13:28:54][ 0 ms]*/ SET PROFILING = 0;
/*[13:28:54][ 0 ms]*/ EXPLAIN SELECT * FROM PROFILE ORDER BY NAME LIMIT 4,4;
/*[13:28:57][ 0 ms]*/ SET PROFILING = 1;
/*[13:28:57][ 0 ms]*/ SET profiling_history_size = 0;
/*[13:28:57][ 0 ms]*/ SET profiling_history_size = 15;
/*[13:28:57][ 15 ms]*/ SHOW STATUS;
/*[13:28:57][ 16 ms]*/ SELECT * FROM PROFILE ORDER BY NAME LIMIT 8,4;
/*[13:28:57][ 31 ms]*/ SHOW STATUS;
/*[13:28:57][ 0 ms]*/ SHOW PROFILES;
/*[13:28:57][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 248 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[13:28:57][ 0 ms]*/ SET PROFILING = 0;
/*[13:28:58][ 0 ms]*/ EXPLAIN SELECT * FROM PROFILE ORDER BY NAME LIMIT 8,4;
/*[13:30:15][ 0 ms]*/ SET PROFILING = 1;
/*[13:30:15][ 0 ms]*/ SET profiling_history_size = 0;
/*[13:30:15][ 0 ms]*/ SET profiling_history_size = 15;
/*[13:30:15][ 16 ms]*/ SHOW STATUS;
/*[13:30:15][ 0 ms]*/ SELECT SQL_CALC_FOUND_ROWS * FROM PROFILE ORDER BY NAME LIMIT 4;
/*[13:30:15][ 0 ms]*/ SHOW STATUS;
/*[13:30:15][ 0 ms]*/ SHOW PROFILES;
/*[13:30:15][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 254 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[13:30:15][ 16 ms]*/ SET PROFILING = 0;
/*[13:30:15][ 15 ms]*/ EXPLAIN SELECT SQL_CALC_FOUND_ROWS * FROM PROFILE ORDER BY NAME LIMIT 4;
/*[13:30:56][ 0 ms]*/ SET PROFILING = 1;
/*[13:30:56][ 0 ms]*/ SET profiling_history_size = 0;
/*[13:30:56][ 0 ms]*/ SET profiling_history_size = 15;
/*[13:30:56][ 15 ms]*/ SHOW STATUS;
/*[13:30:56][ 32 ms]*/ SELECT FOUND_ROWS();
/*[13:30:56][ 15 ms]*/ SHOW STATUS;
/*[13:30:56][ 0 ms]*/ SHOW PROFILES;
/*[13:30:56][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 260 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[13:30:56][ 0 ms]*/ SET PROFILING = 0;
/*[13:30:56][ 0 ms]*/ EXPLAIN SELECT FOUND_ROWS();
/*[13:30:58][ 0 ms]*/ SET PROFILING = 1;
/*[13:30:58][ 0 ms]*/ SET profiling_history_size = 0;
/*[13:30:58][ 0 ms]*/ SET profiling_history_size = 15;
/*[13:30:58][ 0 ms]*/ SHOW STATUS;
/*[13:30:58][ 0 ms]*/ SELECT FOUND_ROWS();
/*[13:30:58][ 0 ms]*/ SHOW STATUS;
/*[13:30:58][ 0 ms]*/ SHOW PROFILES;
/*[13:30:58][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 266 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[13:30:58][ 0 ms]*/ SET PROFILING = 0;
/*[13:30:58][ 0 ms]*/ EXPLAIN SELECT FOUND_ROWS();
/*[13:30:59][ 0 ms]*/ SET PROFILING = 1;
/*[13:30:59][ 15 ms]*/ SET profiling_history_size = 0;
/*[13:30:59][ 0 ms]*/ SET profiling_history_size = 15;
/*[13:30:59][ 0 ms]*/ SHOW STATUS;
/*[13:30:59][ 0 ms]*/ SELECT FOUND_ROWS();
/*[13:30:59][ 0 ms]*/ SHOW STATUS;
/*[13:30:59][ 0 ms]*/ SHOW PROFILES;
/*[13:30:59][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 272 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[13:30:59][ 0 ms]*/ SET PROFILING = 0;
/*[13:30:59][ 0 ms]*/ EXPLAIN SELECT FOUND_ROWS();
/*[13:31:00][ 0 ms]*/ SET PROFILING = 1;
/*[13:31:00][ 0 ms]*/ SET profiling_history_size = 0;
/*[13:31:00][ 0 ms]*/ SET profiling_history_size = 15;
/*[13:31:00][ 0 ms]*/ SHOW STATUS;
/*[13:31:00][ 0 ms]*/ SELECT FOUND_ROWS();
/*[13:31:00][ 15 ms]*/ SHOW STATUS;
/*[13:31:00][ 0 ms]*/ SHOW PROFILES;
/*[13:31:00][ 16 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 278 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[13:31:00][ 0 ms]*/ SET PROFILING = 0;
/*[13:31:00][ 0 ms]*/ EXPLAIN SELECT FOUND_ROWS();
/*[13:31:03][ 0 ms]*/ SET PROFILING = 1;
/*[13:31:03][ 0 ms]*/ SET profiling_history_size = 0;
/*[13:31:03][ 0 ms]*/ SET profiling_history_size = 15;
/*[13:31:03][ 15 ms]*/ SHOW STATUS;
/*[13:31:03][ 0 ms]*/ SELECT SQL_CALC_FOUND_ROWS * FROM PROFILE ORDER BY NAME LIMIT 4;
/*[13:31:03][ 0 ms]*/ SHOW STATUS;
/*[13:31:03][ 16 ms]*/ SHOW PROFILES;
/*[13:31:03][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 284 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[13:31:03][ 16 ms]*/ SET PROFILING = 0;
/*[13:31:04][ 0 ms]*/ EXPLAIN SELECT SQL_CALC_FOUND_ROWS * FROM PROFILE ORDER BY NAME LIMIT 4;
/*[13:31:24][ 15 ms]*/ SET PROFILING = 1;
/*[13:31:24][ 0 ms]*/ SET profiling_history_size = 0;
/*[13:31:24][ 0 ms]*/ SET profiling_history_size = 15;
/*[13:31:24][ 15 ms]*/ SHOW STATUS;
/*[13:31:24][ 0 ms]*/ SELECT SQL_CALC_FOUND_ROWS * FROM PROFILE ORDER BY NAME LIMIT 4;
/*[13:31:24][ 15 ms]*/ SHOW STATUS;
/*[13:31:24][ 0 ms]*/ SHOW PROFILES;
/*[13:31:24][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 290 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[13:31:24][ 0 ms]*/ SET PROFILING = 0;
/*[13:31:24][ 0 ms]*/ SELECT FOUND_ROWS();
/*[13:31:24][ 0 ms]*/ EXPLAIN SELECT SQL_CALC_FOUND_ROWS * FROM PROFILE ORDER BY NAME LIMIT 4;
/*[13:33:42][ 0 ms]*/ SELECT DATABASE();
/*[13:33:58][ 93 ms]*/ DESCRIBE `cookbook`.`profile`;
/*[13:33:58][ 0 ms]*/ SHOW INDEX FROM `cookbook`.`profile`;
/*[13:34:04][ 297 ms]*/ SHOW FULL TABLES FROM `cookbook` WHERE table_type = 'BASE TABLE';
/*[13:34:07][ 47 ms]*/ DESCRIBE `cookbook`.`al_winner`;
/*[13:34:07][ 0 ms]*/ SHOW INDEX FROM `cookbook`.`al_winner`;
/*[13:35:03][ 0 ms]*/ SET PROFILING = 1;
/*[13:35:03][ 0 ms]*/ SET profiling_history_size = 0;
/*[13:35:03][ 0 ms]*/ SET profiling_history_size = 15;
/*[13:35:03][ 0 ms]*/ SHOW STATUS;
/*[13:35:03][ 0 ms]*/ SELECT NAME,wins FROM al_winner ORDER BY wins DESC,NAME LIMIT 0, 1000;
/*[13:35:03][ 0 ms]*/ SHOW STATUS;
/*[13:35:03][ 0 ms]*/ SHOW PROFILES;
/*[13:35:03][ 15 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 296 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[13:35:03][ 0 ms]*/ SET PROFILING = 0;
/*[13:35:03][ 16 ms]*/ EXPLAIN SELECT NAME,wins FROM al_winner ORDER BY wins DESC,NAME LIMIT 0, 1000;
/*[13:35:51][ 16 ms]*/ SET PROFILING = 1;
/*[13:35:51][ 0 ms]*/ SET profiling_history_size = 0;
/*[13:35:51][ 0 ms]*/ SET profiling_history_size = 15;
/*[13:35:51][ 16 ms]*/ SHOW STATUS;
/*[13:35:51][ 0 ms]*/ SELECT NAME,wins FROM al_winner ORDER BY wins DESC,NAME LIMIT 4;
/*[13:35:51][ 0 ms]*/ SHOW STATUS;
/*[13:35:51][ 0 ms]*/ SHOW PROFILES;
/*[13:35:51][ 16 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 302 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[13:35:51][ 0 ms]*/ SET PROFILING = 0;
/*[13:35:51][ 16 ms]*/ EXPLAIN SELECT NAME,wins FROM al_winner ORDER BY wins DESC,NAME LIMIT 4;
/*[13:36:43][ 0 ms]*/ SET PROFILING = 1;
/*[13:36:43][ 16 ms]*/ SET profiling_history_size = 0;
/*[13:36:43][ 0 ms]*/ SET profiling_history_size = 15;
/*[13:36:43][ 15 ms]*/ SHOW STATUS;
/*[13:36:43][ 0 ms]*/ SELECT NAME,wins FROM al_winner ORDER BY wins DESC,NAME LIMIT 3,1;
/*[13:36:44][ 0 ms]*/ SHOW STATUS;
/*[13:36:44][ 0 ms]*/ SHOW PROFILES;
/*[13:36:44][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 308 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[13:36:44][ 0 ms]*/ SET PROFILING = 0;
/*[13:36:44][ 0 ms]*/ EXPLAIN SELECT NAME,wins FROM al_winner ORDER BY wins DESC,NAME LIMIT 3,1;
/*[13:37:12][ 15 ms]*/ SET PROFILING = 1;
/*[13:37:12][ 0 ms]*/ SET profiling_history_size = 0;
/*[13:37:12][ 16 ms]*/ SET profiling_history_size = 15;
/*[13:37:12][ 0 ms]*/ SHOW STATUS;
/*[13:37:12][ 0 ms]*/ SELECT NAME,wins FROM al_winner WHERE wins >= 18 ORDER BY wins DESC,NAME LIMIT 0, 1000;
/*[13:37:13][ 0 ms]*/ SHOW STATUS;
/*[13:37:13][ 0 ms]*/ SHOW PROFILES;
/*[13:37:13][ 16 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 314 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[13:37:13][ 0 ms]*/ SET PROFILING = 0;
/*[13:37:13][ 0 ms]*/ EXPLAIN SELECT NAME,wins FROM al_winner WHERE wins >= 18 ORDER BY wins DESC,NAME LIMIT 0, 1000;
/*[13:40:07][ 0 ms]*/ SET PROFILING = 1;
/*[13:40:07][ 15 ms]*/ SET profiling_history_size = 0;
/*[13:40:07][ 0 ms]*/ SET profiling_history_size = 15;
/*[13:40:07][ 16 ms]*/ SHOW STATUS;
/*[13:40:07][ 16 ms]*/ SELECT * FROM (SELECT NAME,birth FROM PROFILE ORDER BY birth DESC LIMIT 4) AS t ORDER BY birth LIMIT 0, 1000;
/*[13:40:07][ 15 ms]*/ SHOW STATUS;
/*[13:40:07][ 16 ms]*/ SHOW PROFILES;
/*[13:40:07][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 320 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[13:40:07][ 0 ms]*/ SET PROFILING = 0;
/*[13:40:07][ 16 ms]*/ EXPLAIN SELECT * FROM (SELECT NAME,birth FROM PROFILE ORDER BY birth DESC LIMIT 4) AS t ORDER BY birth LIMIT 0, 1000;
/*[13:43:53][ 172 ms]*/ CREATE TABLE mail2 LIKE mail;
/*[13:44:32][ 78 ms]*/ INSERT INTO mail2 SELECT * FROM mail WHERE srcuser = 'barb';
/*[13:44:48][ 0 ms]*/ SET PROFILING = 1;
/*[13:44:48][ 0 ms]*/ SET profiling_history_size = 0;
/*[13:44:48][ 0 ms]*/ SET profiling_history_size = 15;
/*[13:44:48][ 0 ms]*/ SHOW STATUS;
/*[13:44:48][ 16 ms]*/ SELECT * FROM mail2 LIMIT 0, 1000;
/*[13:44:48][ 15 ms]*/ SHOW STATUS;
/*[13:44:48][ 0 ms]*/ SHOW PROFILES;
/*[13:44:48][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 326 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[13:44:48][ 0 ms]*/ SET PROFILING = 0;
/*[13:44:48][ 15 ms]*/ EXPLAIN SELECT * FROM mail2 LIMIT 0, 1000;
/*[14:01:53][ 374 ms]*/ CREATE TEMPORARY TABLE mail SELECT * FROM mail;
/*[14:02:10][ 0 ms]*/ SET PROFILING = 1;
/*[14:02:10][ 0 ms]*/ SET profiling_history_size = 0;
/*[14:02:10][ 0 ms]*/ SET profiling_history_size = 15;
/*[14:02:10][ 0 ms]*/ SHOW STATUS;
/*[14:02:10][ 0 ms]*/ SELECT COUNT(*) FROM mail LIMIT 0, 1000;
/*[14:02:10][ 0 ms]*/ SHOW STATUS;
/*[14:02:10][ 0 ms]*/ SHOW PROFILES;
/*[14:02:10][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 332 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[14:02:10][ 16 ms]*/ SET PROFILING = 0;
/*[14:02:10][ 0 ms]*/ EXPLAIN SELECT COUNT(*) FROM mail LIMIT 0, 1000;
/*[14:02:23][ 172 ms]*/ DELETE FROM mail;
/*[14:02:24][ 0 ms]*/ DELETE FROM mail;
/*[14:02:37][ 0 ms]*/ SET PROFILING = 1;
/*[14:02:37][ 16 ms]*/ SET profiling_history_size = 0;
/*[14:02:37][ 0 ms]*/ SET profiling_history_size = 15;
/*[14:02:37][ 0 ms]*/ SHOW STATUS;
/*[14:02:37][ 15 ms]*/ SELECT COUNT(*) FROM mail LIMIT 0, 1000;
/*[14:02:37][ 0 ms]*/ SHOW STATUS;
/*[14:02:37][ 0 ms]*/ SHOW PROFILES;
/*[14:02:37][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 338 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[14:02:37][ 0 ms]*/ SET PROFILING = 0;
/*[14:02:37][ 16 ms]*/ EXPLAIN SELECT COUNT(*) FROM mail LIMIT 0, 1000;
/*[14:02:52][ 375 ms]*/ DROP TABLE mail;
/*[14:03:06][ 0 ms]*/ SET PROFILING = 1;
/*[14:03:06][ 0 ms]*/ SET profiling_history_size = 0;
/*[14:03:06][ 0 ms]*/ SET profiling_history_size = 15;
/*[14:03:06][ 0 ms]*/ SHOW STATUS;
/*[14:03:06][ 15 ms]*/ SELECT COUNT(*) FROM mail LIMIT 0, 1000;
/*[14:03:06][ 16 ms]*/ SHOW STATUS;
/*[14:03:06][ 0 ms]*/ SHOW PROFILES;
/*[14:03:06][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 344 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[14:03:06][ 0 ms]*/ SET PROFILING = 0;
/*[14:03:06][ 15 ms]*/ EXPLAIN SELECT COUNT(*) FROM mail LIMIT 0, 1000;
/*[14:04:43][ 63 ms]*/ SELECT `SPECIFIC_NAME` FROM `INFORMATION_SCHEMA`.`ROUTINES` WHERE `ROUTINE_SCHEMA` = 'cookbook' AND ROUTINE_TYPE = 'PROCEDURE';
/*[14:04:43][ 15 ms]*/ SELECT `SPECIFIC_NAME` FROM `INFORMATION_SCHEMA`.`ROUTINES` WHERE `ROUTINE_SCHEMA` = 'cookbook' AND ROUTINE_TYPE = 'FUNCTION';
/*[14:04:44][ 62 ms]*/ SHOW TRIGGERS FROM `cookbook`;
/*[14:04:45][ 47 ms]*/ SELECT `EVENT_NAME` FROM `INFORMATION_SCHEMA`.`EVENTS` WHERE `EVENT_SCHEMA` = 'cookbook' ORDER BY EVENT_NAME;
/*[14:06:40][ 0 ms]*/ SET PROFILING = 1;
/*[14:06:40][ 31 ms]*/ SET profiling_history_size = 0;
/*[14:06:40][ 0 ms]*/ SET profiling_history_size = 15;
/*[14:06:40][ 16 ms]*/ SHOW STATUS;
/*[14:06:40][ 0 ms]*/ SELECT ENGINE fromj information_schema.TABLES WHERE table_schema = 'cookbook' AND table_name = 'mail';
/*[14:06:52][ 0 ms]*/ SET PROFILING = 1;
/*[14:06:52][ 0 ms]*/ SET profiling_history_size = 0;
/*[14:06:52][ 0 ms]*/ SET profiling_history_size = 15;
/*[14:06:52][ 15 ms]*/ SHOW STATUS;
/*[14:06:52][ 0 ms]*/ SELECT ENGINE FROM information_schema.TABLES WHERE table_schema = 'cookbook' AND table_name = 'mail' LIMIT 0, 1000;
/*[14:06:52][ 0 ms]*/ SHOW STATUS;
/*[14:06:52][ 0 ms]*/ SHOW PROFILES;
/*[14:06:52][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 355 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[14:06:52][ 0 ms]*/ SET PROFILING = 0;
/*[14:06:52][ 0 ms]*/ EXPLAIN SELECT ENGINE FROM information_schema.TABLES WHERE table_schema = 'cookbook' AND table_name = 'mail' LIMIT 0, 1000;
/*[14:07:35][ 15 ms]*/ USE `information_schema`;
/*[14:07:37][ 0 ms]*/ SHOW TABLES FROM `information_schema`;
/*[14:07:44][ 31 ms]*/ DESCRIBE `information_schema`.`TABLES`;
/*[14:07:44][ 16 ms]*/ SHOW INDEX FROM `information_schema`.`TABLES`;
/*[14:07:47][ 94 ms]*/ SHOW FULL FIELDS FROM `information_schema`.`TABLES`;
/*[14:07:47][ 0 ms]*/ SHOW KEYS FROM `information_schema`.`TABLES`;
/*[14:07:49][1825 ms]*/ SELECT * FROM `information_schema`.`TABLES` LIMIT 0, 100;
/*[14:08:45][ 0 ms]*/ SET PROFILING = 1;
/*[14:08:45][ 0 ms]*/ SET profiling_history_size = 0;
/*[14:08:45][ 16 ms]*/ SET profiling_history_size = 15;
/*[14:08:45][ 15 ms]*/ SHOW STATUS;
/*[14:08:45][ 0 ms]*/ SELECT ENGINE FROM information_schema.TABLES WHERE table_schema = 'cookbook' AND table_name = 'mail' LIMIT 0, 1000;
/*[14:08:45][ 0 ms]*/ SHOW STATUS;
/*[14:08:45][ 0 ms]*/ SHOW PROFILES;
/*[14:08:45][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 361 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[14:08:45][ 15 ms]*/ SET PROFILING = 0;
/*[14:08:45][ 0 ms]*/ EXPLAIN SELECT ENGINE FROM information_schema.TABLES WHERE table_schema = 'cookbook' AND table_name = 'mail' LIMIT 0, 1000;
/*[14:09:22][ 16 ms]*/ SHOW TABLE STATUS LIKE 'mail';
/*[14:09:45][ 0 ms]*/ SHOW TABLE STATUS LIKE 'mail'G ;
/*[14:10:27][ 0 ms]*/ SHOW CREATE TABLE mailG;
/*[14:10:34][ 15 ms]*/ SHOW CREATE TABLE mail;
/*[14:16:10][ 78 ms]*/ SHOW CHARACTER SET;
/*[18:45:10][ 0 ms]*/ USE `cookbook`;
/*[18:45:13][ 0 ms]*/ SELECT DATABASE();
/*[18:45:28][ 0 ms]*/ SELECT DATABASE();
/*[18:47:06][ 187 ms]*/ SHOW FULL TABLES FROM `cookbook` WHERE table_type = 'BASE TABLE';
/*[18:47:07][ 0 ms]*/ SHOW FULL TABLES FROM `cookbook` WHERE table_type = 'BASE TABLE';
/*[18:47:09][ 31 ms]*/ DESCRIBE `cookbook`.`artist`;
/*[18:47:09][ 16 ms]*/ SHOW INDEX FROM `cookbook`.`artist`;
/*[18:47:12][ 31 ms]*/ SHOW FULL FIELDS FROM `cookbook`.`artist`;
/*[18:47:12][ 0 ms]*/ SHOW KEYS FROM `cookbook`.`artist`;
/*[18:47:12][ 0 ms]*/ SELECT * FROM `cookbook`.`artist` LIMIT 0, 100;
/*[18:47:19][ 62 ms]*/ SHOW FULL FIELDS FROM `cookbook`.`painting`;
/*[18:47:19][ 0 ms]*/ SHOW KEYS FROM `cookbook`.`painting`;
/*[18:47:19][ 0 ms]*/ SELECT * FROM `cookbook`.`painting` LIMIT 0, 100;
/*[18:47:20][ 47 ms]*/ DESCRIBE `cookbook`.`painting`;
/*[18:47:20][ 0 ms]*/ SHOW INDEX FROM `cookbook`.`painting`;
/*[18:48:13][ 0 ms]*/ SET PROFILING = 1;
/*[18:48:13][ 0 ms]*/ SET profiling_history_size = 0;
/*[18:48:13][ 0 ms]*/ SET profiling_history_size = 15;
/*[18:48:13][ 16 ms]*/ SHOW STATUS;
/*[18:48:13][ 0 ms]*/ SELECT * FROM artist ORDER BY a_id LIMIT 0, 1000;
/*[18:48:13][ 0 ms]*/ SHOW STATUS;
/*[18:48:13][ 15 ms]*/ SHOW PROFILES;
/*[18:48:13][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 367 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[18:48:13][ 0 ms]*/ SET PROFILING = 0;
/*[18:48:13][ 0 ms]*/ EXPLAIN SELECT * FROM artist ORDER BY a_id LIMIT 0, 1000;
/*[18:48:41][ 0 ms]*/ SET PROFILING = 1;
/*[18:48:41][ 0 ms]*/ SET profiling_history_size = 0;
/*[18:48:41][ 0 ms]*/ SET profiling_history_size = 15;
/*[18:48:41][ 0 ms]*/ SHOW STATUS;
/*[18:48:41][ 16 ms]*/ SELECT * FROM painting ORDER BY a_id,p_id LIMIT 0, 1000;
/*[18:48:41][ 16 ms]*/ SHOW STATUS;
/*[18:48:41][ 0 ms]*/ SHOW PROFILES;
/*[18:48:41][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 373 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[18:48:41][ 0 ms]*/ SET PROFILING = 0;
/*[18:48:41][ 0 ms]*/ EXPLAIN SELECT * FROM painting ORDER BY a_id,p_id LIMIT 0, 1000;
/*[18:50:09][ 0 ms]*/ SET PROFILING = 1;
/*[18:50:09][ 0 ms]*/ SET profiling_history_size = 0;
/*[18:50:09][ 0 ms]*/ SET profiling_history_size = 15;
/*[18:50:09][ 0 ms]*/ SHOW STATUS;
/*[18:50:09][ 0 ms]*/ SELECT * FROM painting ,artist LIMIT 0, 1000;
/*[18:50:09][ 0 ms]*/ SHOW STATUS;
/*[18:50:09][ 0 ms]*/ SHOW PROFILES;
/*[18:50:09][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 379 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[18:50:09][ 0 ms]*/ SET PROFILING = 0;
/*[18:50:09][ 0 ms]*/ EXPLAIN SELECT * FROM painting ,artist LIMIT 0, 1000;
/*[19:37:30][ 0 ms]*/ SET PROFILING = 1;
/*[19:37:30][ 0 ms]*/ SET profiling_history_size = 0;
/*[19:37:30][ 0 ms]*/ SET profiling_history_size = 15;
/*[19:37:30][ 15 ms]*/ SHOW STATUS;
/*[19:37:30][ 0 ms]*/ SELECT * FROM artist,paiting WHERE artist.a_id = painting.a_id LIMIT 0, 1000;
/*[19:37:54][ 0 ms]*/ SET PROFILING = 1;
/*[19:37:54][ 0 ms]*/ SET profiling_history_size = 0;
/*[19:37:54][ 0 ms]*/ SET profiling_history_size = 15;
/*[19:37:54][ 16 ms]*/ SHOW STATUS;
/*[19:37:54][ 0 ms]*/ SELECT * FROM artist,painting WHERE artist.a_id = painting.a_id LIMIT 0, 1000;
/*[19:37:54][ 15 ms]*/ SHOW STATUS;
/*[19:37:54][ 0 ms]*/ SHOW PROFILES;
/*[19:37:54][ 16 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 390 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[19:37:54][ 0 ms]*/ SET PROFILING = 0;
/*[19:37:54][ 0 ms]*/ EXPLAIN SELECT * FROM artist,painting WHERE artist.a_id = painting.a_id LIMIT 0, 1000;
/*[19:41:34][ 46 ms]*/ DESCRIBE `cookbook`.`painting`;
/*[19:41:34][ 0 ms]*/ SHOW INDEX FROM `cookbook`.`painting`;
/*[19:41:39][ 0 ms]*/ SET PROFILING = 1;
/*[19:41:39][ 0 ms]*/ SET profiling_history_size = 0;
/*[19:41:39][ 0 ms]*/ SET profiling_history_size = 15;
/*[19:41:39][ 0 ms]*/ SHOW STATUS;
/*[19:41:39][ 0 ms]*/ SELECT * FROM artist INNER JOIN painting ON artist.a_id = painting.a_id LIMIT 0, 1000;
/*[19:41:39][ 0 ms]*/ SHOW STATUS;
/*[19:41:39][ 0 ms]*/ SHOW PROFILES;
/*[19:41:39][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 396 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[19:41:39][ 0 ms]*/ SET PROFILING = 0;
/*[19:41:39][ 0 ms]*/ EXPLAIN SELECT * FROM artist INNER JOIN painting ON artist.a_id = painting.a_id LIMIT 0, 1000;
/*[19:41:40][ 0 ms]*/ SET PROFILING = 1;
/*[19:41:40][ 0 ms]*/ SET profiling_history_size = 0;
/*[19:41:40][ 0 ms]*/ SET profiling_history_size = 15;
/*[19:41:40][ 0 ms]*/ SHOW STATUS;
/*[19:41:40][ 0 ms]*/ SELECT * FROM artist INNER JOIN painting ON artist.a_id = painting.a_id LIMIT 0, 1000;
/*[19:41:40][ 16 ms]*/ SHOW STATUS;
/*[19:41:40][ 0 ms]*/ SHOW PROFILES;
/*[19:41:40][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 402 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[19:41:40][ 0 ms]*/ SET PROFILING = 0;
/*[19:41:40][ 0 ms]*/ EXPLAIN SELECT * FROM artist INNER JOIN painting ON artist.a_id = painting.a_id LIMIT 0, 1000;
/*[19:43:15][ 0 ms]*/ SET PROFILING = 1;
/*[19:43:15][ 0 ms]*/ SET profiling_history_size = 0;
/*[19:43:15][ 0 ms]*/ SET profiling_history_size = 15;
/*[19:43:15][ 0 ms]*/ SHOW STATUS;
/*[19:43:15][ 0 ms]*/ SELECT * FROM artist INNER JOIN painting USING(a_id) LIMIT 0, 1000;
/*[19:43:15][ 0 ms]*/ SHOW STATUS;
/*[19:43:15][ 0 ms]*/ SHOW PROFILES;
/*[19:43:15][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 408 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[19:43:15][ 0 ms]*/ SET PROFILING = 0;
/*[19:43:15][ 0 ms]*/ EXPLAIN SELECT * FROM artist INNER JOIN painting USING(a_id) LIMIT 0, 1000;
/*[19:46:13][ 0 ms]*/ SET PROFILING = 1;
/*[19:46:13][ 0 ms]*/ SET profiling_history_size = 0;
/*[19:46:13][ 0 ms]*/ SET profiling_history_size = 15;
/*[19:46:13][ 16 ms]*/ SHOW STATUS;
/*[19:46:13][ 0 ms]*/ SELECT * FROM artist INNER JOIN painting ON artist.a_id = painting.a_id WHERE painting.state = 'KY' LIMIT 0, 1000;
/*[19:46:13][ 0 ms]*/ SHOW STATUS;
/*[19:46:13][ 0 ms]*/ SHOW PROFILES;
/*[19:46:13][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 414 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[19:46:13][ 0 ms]*/ SET PROFILING = 0;
/*[19:46:13][ 0 ms]*/ EXPLAIN SELECT * FROM artist INNER JOIN painting ON artist.a_id = painting.a_id WHERE painting.state = 'KY' LIMIT 0, 1000;
/*[19:47:19][ 63 ms]*/ DESCRIBE `cookbook`.`painting`;
/*[19:47:19][ 0 ms]*/ SHOW INDEX FROM `cookbook`.`painting`;
/*[19:47:21][ 0 ms]*/ SET PROFILING = 1;
/*[19:47:21][ 0 ms]*/ SET profiling_history_size = 0;
/*[19:47:21][ 0 ms]*/ SET profiling_history_size = 15;
/*[19:47:21][ 0 ms]*/ SHOW STATUS;
/*[19:47:21][ 15 ms]*/ SELECT artist.NAME,painting.title,painting.state,painting.price FROM artist INNER JOIN painting ON artist.a_id = painting.a_id WHERE painting.state = 'KY' LIMIT 0, 1000;
/*[19:47:21][ 0 ms]*/ SHOW STATUS;
/*[19:47:21][ 0 ms]*/ SHOW PROFILES;
/*[19:47:21][ 16 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 420 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[19:47:21][ 0 ms]*/ SET PROFILING = 0;
/*[19:47:21][ 0 ms]*/ EXPLAIN SELECT artist.NAME,painting.title,painting.state,painting.price FROM artist INNER JOIN painting ON artist.a_id = painting.a_id WHERE painting.state = 'KY' LIMIT 0, 1000;
/*[19:49:13][ 0 ms]*/ SELECT DATABASE();
/*[19:50:52][ 0 ms]*/ SET PROFILING = 1;
/*[19:50:52][ 15 ms]*/ SET profiling_history_size = 0;
/*[19:50:52][ 0 ms]*/ SET profiling_history_size = 15;
/*[19:50:52][ 0 ms]*/ SHOW STATUS;
/*[19:50:52][ 0 ms]*/ SELECT artist.NAME,painting.title,states.state,painting.price FROM artist INNER JOIN painting INNER JOIN states ON artist.a_id = painting.a_id AND painting.state = states.abbrev WHERE painting.state = 'KY' LIMIT 0, 1000;
/*[19:51:24][ 0 ms]*/ SET PROFILING = 1;
/*[19:51:24][ 0 ms]*/ SET profiling_history_size = 0;
/*[19:51:24][ 0 ms]*/ SET profiling_history_size = 15;
/*[19:51:24][ 0 ms]*/ SHOW STATUS;
/*[19:51:24][ 16 ms]*/ SELECT artist.NAME,painting.title,states.NAME,painting.price FROM artist INNER JOIN painting INNER JOIN states ON artist.a_id = painting.a_id AND painting.state = states.abbrev WHERE painting.state = 'KY' LIMIT 0, 1000;
/*[19:51:24][ 0 ms]*/ SHOW STATUS;
/*[19:51:24][ 0 ms]*/ SHOW PROFILES;
/*[19:51:24][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 431 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[19:51:24][ 0 ms]*/ SET PROFILING = 0;
/*[19:51:24][ 0 ms]*/ EXPLAIN SELECT artist.NAME,painting.title,states.NAME,painting.price FROM artist INNER JOIN painting INNER JOIN states ON artist.a_id = painting.a_id AND painting.state = states.abbrev WHERE painting.state = 'KY' LIMIT 0, 1000;
/*[19:51:33][ 0 ms]*/ SET PROFILING = 1;
/*[19:51:33][ 0 ms]*/ SET profiling_history_size = 0;
/*[19:51:33][ 0 ms]*/ SET profiling_history_size = 15;
/*[19:51:33][ 16 ms]*/ SHOW STATUS;
/*[19:51:33][ 0 ms]*/ SELECT artist.NAME,painting.title,states.NAME,painting.price FROM artist INNER JOIN painting INNER JOIN states ON artist.a_id = painting.a_id AND painting.state = states.abbrev LIMIT 0, 1000;
/*[19:51:33][ 0 ms]*/ SHOW STATUS;
/*[19:51:33][ 0 ms]*/ SHOW PROFILES;
/*[19:51:33][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 437 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[19:51:33][ 0 ms]*/ SET PROFILING = 0;
/*[19:51:33][ 0 ms]*/ EXPLAIN SELECT artist.NAME,painting.title,states.NAME,painting.price FROM artist INNER JOIN painting INNER JOIN states ON artist.a_id = painting.a_id AND painting.state = states.abbrev LIMIT 0, 1000;
/*[19:57:46][ 0 ms]*/ SET PROFILING = 1;
/*[19:57:46][ 0 ms]*/ SET profiling_history_size = 0;
/*[19:57:46][ 0 ms]*/ SET profiling_history_size = 15;
/*[19:57:46][ 0 ms]*/ SHOW STATUS;
/*[19:57:46][ 0 ms]*/ SELECT artist.NAME, COUNT(*) AS 'number of paintings', SUM(painting.price) AS 'total price', AVG(painting.price) AS 'average price', FROM artist INNER JOIN painting ON artist.a_id = painting.az-id GROUP BY artist.NAME LIMIT 0, 1000;
/*[19:58:25][ 0 ms]*/ SET PROFILING = 1;
/*[19:58:25][ 0 ms]*/ SET profiling_history_size = 0;
/*[19:58:25][ 0 ms]*/ SET profiling_history_size = 15;
/*[19:58:25][ 0 ms]*/ SHOW STATUS;
/*[19:58:25][ 0 ms]*/ SELECT artist.NAME, COUNT(*) AS 'number of paintings', SUM(painting.price) AS 'total price', AVG(painting.price) AS 'average price', FROM artist INNER JOIN painting ON artist.a_id = painting.a_id GROUP BY artist.NAME LIMIT 0, 1000;
/*[19:59:38][ 0 ms]*/ SET PROFILING = 1;
/*[19:59:38][ 0 ms]*/ SET profiling_history_size = 0;
/*[19:59:38][ 0 ms]*/ SET profiling_history_size = 15;
/*[19:59:38][ 16 ms]*/ SHOW STATUS;
/*[19:59:38][ 0 ms]*/ SELECT artist.NAME, COUNT(*) AS 'number of paintings', SUM(painting.price) AS 'total price', AVG(painting.price) AS 'average price', FROM artist INNER JOIN painting ON artist.a_id = painting.a_id GROUP BY artist.NAME LIMIT 0, 1000;
/*[19:59:39][ 0 ms]*/ SET PROFILING = 1;
/*[19:59:39][ 0 ms]*/ SET profiling_history_size = 0;
/*[19:59:39][ 0 ms]*/ SET profiling_history_size = 15;
/*[19:59:39][ 15 ms]*/ SHOW STATUS;
/*[19:59:39][ 0 ms]*/ SELECT artist.NAME, COUNT(*) AS 'number of paintings', SUM(painting.price) AS 'total price', AVG(painting.price) AS 'average price', FROM artist INNER JOIN painting ON artist.a_id = painting.a_id GROUP BY artist.NAME LIMIT 0, 1000;
/*[19:59:39][ 0 ms]*/ SET PROFILING = 1;
/*[19:59:39][ 0 ms]*/ SET profiling_history_size = 0;
/*[19:59:39][ 0 ms]*/ SET profiling_history_size = 15;
/*[19:59:39][ 16 ms]*/ SHOW STATUS;
/*[19:59:39][ 0 ms]*/ SELECT artist.NAME, COUNT(*) AS 'number of paintings', SUM(painting.price) AS 'total price', AVG(painting.price) AS 'average price', FROM artist INNER JOIN painting ON artist.a_id = painting.a_id GROUP BY artist.NAME LIMIT 0, 1000;
/*[19:59:39][ 0 ms]*/ SET PROFILING = 1;
/*[19:59:39][ 0 ms]*/ SET profiling_history_size = 0;
/*[19:59:39][ 0 ms]*/ SET profiling_history_size = 15;
/*[19:59:39][ 0 ms]*/ SHOW STATUS;
/*[19:59:39][ 0 ms]*/ SELECT artist.NAME, COUNT(*) AS 'number of paintings', SUM(painting.price) AS 'total price', AVG(painting.price) AS 'average price', FROM artist INNER JOIN painting ON artist.a_id = painting.a_id GROUP BY artist.NAME LIMIT 0, 1000;
/*[19:59:39][ 0 ms]*/ SET PROFILING = 1;
/*[19:59:39][ 0 ms]*/ SET profiling_history_size = 0;
/*[19:59:39][ 0 ms]*/ SET profiling_history_size = 15;
/*[19:59:39][ 0 ms]*/ SHOW STATUS;
/*[19:59:39][ 16 ms]*/ SELECT artist.NAME, COUNT(*) AS 'number of paintings', SUM(painting.price) AS 'total price', AVG(painting.price) AS 'average price', FROM artist INNER JOIN painting ON artist.a_id = painting.a_id GROUP BY artist.NAME LIMIT 0, 1000;
/*[20:00:07][ 0 ms]*/ SET PROFILING = 1;
/*[20:00:07][ 0 ms]*/ SET profiling_history_size = 0;
/*[20:00:07][ 0 ms]*/ SET profiling_history_size = 15;
/*[20:00:07][ 15 ms]*/ SHOW STATUS;
/*[20:00:07][ 0 ms]*/ SELECT artist.NAME, COUNT(*) AS 'number of paintings', SUM(painting.price) AS 'total price', AVG(painting.price) AS 'average price', FROM artist INNER JOIN painting ON artist.a_id = painting.a_id LIMIT 0, 1000;
/*[20:01:35][ 15 ms]*/ SET PROFILING = 1;
/*[20:01:35][ 0 ms]*/ SET profiling_history_size = 0;
/*[20:01:35][ 0 ms]*/ SET profiling_history_size = 15;
/*[20:01:35][ 0 ms]*/ SHOW STATUS;
/*[20:01:35][ 15 ms]*/ SELECT artist.NAME, COUNT(*) AS 'number of paintings', SUM(painting.price) AS 'total price', AVG(painting.price) AS 'average price', FROM artist INNER JOIN painting ON artist.a_id = painting.p_id GROUP BY artist.NAME LIMIT 0, 1000;
/*[20:01:39][ 0 ms]*/ SET PROFILING = 1;
/*[20:01:39][ 15 ms]*/ SET profiling_history_size = 0;
/*[20:01:39][ 0 ms]*/ SET profiling_history_size = 15;
/*[20:01:39][ 0 ms]*/ SHOW STATUS;
/*[20:01:39][ 0 ms]*/ SELECT artist.NAME, COUNT(*) AS 'number of paintings', SUM(painting.price) AS 'total price', AVG(painting.price) AS 'average price', FROM artist INNER JOIN painting ON artist.a_id = painting.a_id GROUP BY artist.NAME LIMIT 0, 1000;
/*[20:02:15][ 0 ms]*/ SET PROFILING = 1;
/*[20:02:15][ 0 ms]*/ SET profiling_history_size = 0;
/*[20:02:15][ 0 ms]*/ SET profiling_history_size = 15;
/*[20:02:15][ 16 ms]*/ SHOW STATUS;
/*[20:02:15][ 15 ms]*/ SELECT artist.NAME, COUNT(*) AS 'number of paintings', SUM(painting.price) AS 'total price', AVG(painting.price) AS 'average price' FROM artist INNER JOIN painting ON artist.a_id = painting.a_id GROUP BY artist.NAME LIMIT 0, 1000;
/*[20:02:15][ 0 ms]*/ SHOW STATUS;
/*[20:02:15][ 0 ms]*/ SHOW PROFILES;
/*[20:02:15][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 493 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[20:02:15][ 16 ms]*/ SET PROFILING = 0;
/*[20:02:15][ 0 ms]*/ EXPLAIN SELECT artist.NAME, COUNT(*) AS 'number of paintings', SUM(painting.price) AS 'total price', AVG(painting.price) AS 'average price' FROM artist INNER JOIN painting ON artist.a_id = painting.a_id GROUP BY artist.NAME LIMIT 0, 1000;
/*[20:02:34][ 0 ms]*/ SET PROFILING = 1;
/*[20:02:34][ 0 ms]*/ SET profiling_history_size = 0;
/*[20:02:34][ 0 ms]*/ SET profiling_history_size = 15;
/*[20:02:34][ 16 ms]*/ SHOW STATUS;
/*[20:02:34][ 0 ms]*/ SELECT artist.NAME, COUNT(*) AS 'number of paintings', SUM(painting.price) AS 'total price', AVG(painting.price) AS 'average price' FROM artist INNER JOIN painting ON artist.a_id = painting.a_id LIMIT 0, 1000;
/*[20:02:34][ 15 ms]*/ SHOW STATUS;
/*[20:02:34][ 0 ms]*/ SHOW PROFILES;
/*[20:02:34][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 499 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[20:02:34][ 0 ms]*/ SET PROFILING = 0;
/*[20:02:34][ 0 ms]*/ EXPLAIN SELECT artist.NAME, COUNT(*) AS 'number of paintings', SUM(painting.price) AS 'total price', AVG(painting.price) AS 'average price' FROM artist INNER JOIN painting ON artist.a_id = painting.a_id LIMIT 0, 1000;
/*[20:02:52][ 0 ms]*/ SET PROFILING = 1;
/*[20:02:52][ 0 ms]*/ SET profiling_history_size = 0;
/*[20:02:52][ 0 ms]*/ SET profiling_history_size = 15;
/*[20:02:52][ 15 ms]*/ SHOW STATUS;
/*[20:02:52][ 0 ms]*/ SELECT artist.NAME, COUNT(*) AS 'number of paintings', SUM(painting.price) AS 'total price', AVG(painting.price) AS 'average price' FROM artist INNER JOIN painting ON artist.a_id = painting.a_id GROUP BY artist.NAME LIMIT 0, 1000;
/*[20:02:52][ 16 ms]*/ SHOW STATUS;
/*[20:02:52][ 0 ms]*/ SHOW PROFILES;
/*[20:02:52][ 15 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 505 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[20:02:52][ 0 ms]*/ SET PROFILING = 0;
/*[20:02:52][ 0 ms]*/ EXPLAIN SELECT artist.NAME, COUNT(*) AS 'number of paintings', SUM(painting.price) AS 'total price', AVG(painting.price) AS 'average price' FROM artist INNER JOIN painting ON artist.a_id = painting.a_id GROUP BY artist.NAME LIMIT 0, 1000;
/*[20:06:06][ 0 ms]*/ SET PROFILING = 1;
/*[20:06:06][ 0 ms]*/ SET profiling_history_size = 0;
/*[20:06:06][ 0 ms]*/ SET profiling_history_size = 15;
/*[20:06:06][ 16 ms]*/ SHOW STATUS;
/*[20:06:06][ 0 ms]*/ SELECT a.NAME,p.title,s.NAME,p.price FROM artist AS a INNER JOIN painting AS p INNER JOIN states AS s ON a.a_id = p.a_id AND p.state = s.abbrev LIMIT 0, 1000;
/*[20:06:06][ 15 ms]*/ SHOW STATUS;
/*[20:06:06][ 0 ms]*/ SHOW PROFILES;
/*[20:06:06][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 511 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[20:06:06][ 0 ms]*/ SET PROFILING = 0;
/*[20:06:06][ 0 ms]*/ EXPLAIN SELECT a.NAME,p.title,s.NAME,p.price FROM artist AS a INNER JOIN painting AS p INNER JOIN states AS s ON a.a_id = p.a_id AND p.state = s.abbrev LIMIT 0, 1000;
/*[20:18:44][ 47 ms]*/ SHOW FULL FIELDS FROM `cookbook`.`painting`;
/*[20:22:44][ 0 ms]*/ USE `information_schema`;
/*[20:22:47][ 0 ms]*/ USE `cookbook`;
/*[20:22:51][ 0 ms]*/ SET PROFILING = 1;
/*[20:22:51][ 0 ms]*/ SET profiling_history_size = 0;
/*[20:22:51][ 0 ms]*/ SET profiling_history_size = 15;
/*[20:22:51][ 0 ms]*/ SHOW STATUS;
/*[20:22:51][ 0 ms]*/ SELECT a.NAME,p.title,s.NAME,p.price FROM artist AS a INNER JOIN painting AS p INNER JOIN states AS s ON a.a_id = p.a_id AND p.state = s.abbrev LIMIT 0, 1000;
/*[20:22:51][ 0 ms]*/ SHOW STATUS;
/*[20:22:51][ 0 ms]*/ SHOW PROFILES;
/*[20:22:51][ 0 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 517 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[20:22:51][ 0 ms]*/ SET PROFILING = 0;
/*[20:22:51][ 0 ms]*/ EXPLAIN SELECT a.NAME,p.title,s.NAME,p.price FROM artist AS a INNER JOIN painting AS p INNER JOIN states AS s ON a.a_id = p.a_id AND p.state = s.abbrev LIMIT 0, 1000;
/*[20:22:52][ 0 ms]*/ SET PROFILING = 1;
/*[20:22:52][ 0 ms]*/ SET profiling_history_size = 0;
/*[20:22:52][ 0 ms]*/ SET profiling_history_size = 15;
/*[20:22:52][ 15 ms]*/ SHOW STATUS;
/*[20:22:52][ 0 ms]*/ SELECT a.NAME,p.title,s.NAME,p.price FROM artist AS a INNER JOIN painting AS p INNER JOIN states AS s ON a.a_id = p.a_id AND p.state = s.abbrev LIMIT 0, 1000;
/*[20:22:52][ 0 ms]*/ SHOW STATUS;
/*[20:22:52][ 0 ms]*/ SHOW PROFILES;
/*[20:22:52][ 16 ms]*/ SELECT state, ROUND(SUM(duration),5) AS `duration (summed) in sec` FROM information_schema.profiling WHERE query_id = 523 GROUP BY state ORDER BY `duration (summed) in sec` DESC;
/*[20:22:52][ 0 ms]*/ SET PROFILING = 0;
/*[20:22:52][ 0 ms]*/ EXPLAIN SELECT a.NAME,p.title,s.NAME,p.price FROM artist AS a INNER JOIN painting AS p INNER JOIN states AS s ON a.a_id = p.a_id AND p.state = s.abbrev LIMIT 0, 1000;
/*[20:23:32][ 0 ms]*/ SHOW TABLE STATUS FROM `cookbook` WHERE ENGINE IS NOT NULL;
/*[20:23:32][ 62 ms]*/ SELECT `TABLE_NAME` AS View_name,`View_definition`,`Check_option`,`Is_updatable`,`Definer`,`Security_type` FROM `INFORMATION_SCHEMA`.`VIEWS` WHERE `TABLE_SCHEMA` = 'cookbook';
/*[20:23:32][ 15 ms]*/ SHOW PROCEDURE STATUS WHERE Db = 'cookbook';
/*[20:23:32][ 0 ms]*/ SHOW FUNCTION STATUS WHERE Db='cookbook';
/*[20:23:32][ 0 ms]*/ SHOW TRIGGERS FROM `cookbook`;
/*[20:23:32][ 0 ms]*/ SELECT `Event_name`,`Definer`,`Event_type`,`Execute_at`,`Interval_value`,`Interval_field`,`Starts`,`Ends`,`Status` FROM `INFORMATION_SCHEMA`.`EVENTS` WHERE `EVENT_SCHEMA` = 'cookbook';
/*[20:23:32][ 0 ms]*/ SHOW CREATE DATABASE `cookbook`;
~~~~~~~~