-------------- create database tempor -------------- -------------- create table temp_a ( id integer primary key, nome varchar(50) ) -------------- -------------- create table temp_b ( id integer primary key, id_a integer, nome varchar(50), foreign key (id_a) references temp_a(id) ) -------------- -------------- insert into temp_a values ( 1, 'casa') -------------- -------------- insert into temp_a values ( 2, 'barco') -------------- -------------- insert into temp_a values ( 3, 'predio') -------------- -------------- insert into temp_a values ( 4, 'navio') -------------- -------------- insert into temp_b values ( 1 , 1 , 'triplex') -------------- -------------- insert into temp_b values ( 2 , 2 , 'lancha model B') -------------- -------------- insert into temp_b values ( 3 , 1 , 'sobrado') -------------- -------------- insert into temp_b values ( 4 , 1 , 'mansao') -------------- -------------- create ALGORITHM = MERGE view ab_view as ( select a.id as id_a, a.nome as nome_a, b.id as id_b, b.nome as nome_b from temp_a a, temp_b b where a.id = b.id_a ) -------------- -------------- select sleep(5) -------------- sleep(5) 0 -------------- select * from ab_view -------------- id_a nome_a id_b nome_b 1 casa 1 triplex 2 barco 2 lancha model B 1 casa 3 sobrado 1 casa 4 mansao -------------- select * from performance_schema.events_statements_summary_by_digest order by LAST_SEEN desc limit 5 -------------- *************************** 1. row *************************** SCHEMA_NAME: tempor DIGEST: cfdb68993eb89b400ec31f5f1f49493b DIGEST_TEXT: SELECT `sleep` (?) COUNT_STAR: 1 SUM_TIMER_WAIT: 5000409520000 MIN_TIMER_WAIT: 5000409520000 AVG_TIMER_WAIT: 5000409520000 MAX_TIMER_WAIT: 5000409520000 SUM_LOCK_TIME: 0 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 1 SUM_ROWS_EXAMINED: 0 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 0 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 0 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 0 SUM_SORT_SCAN: 0 SUM_NO_INDEX_USED: 0 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2018-02-08 17:18:15 LAST_SEEN: 2018-02-08 17:18:15 *************************** 2. row *************************** SCHEMA_NAME: tempor DIGEST: 89c4e1026cee35d60dd22568af23905f DIGEST_TEXT: ( SELECT `a` . `id` AS `id_a` , `a` . `nome` AS `nome_a` , `b` . `id` AS `id_b` , `b` . `nome` AS `nome_b` FROM `tempor` . `temp_a` `a` JOIN `tempor` . `temp_b` `b` WHERE ( `a` . `id` = `b` . `id_a` ) ) COUNT_STAR: 1 SUM_TIMER_WAIT: 1156607000 MIN_TIMER_WAIT: 1156607000 AVG_TIMER_WAIT: 1156607000 MAX_TIMER_WAIT: 1156607000 SUM_LOCK_TIME: 622000000 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 4 SUM_ROWS_EXAMINED: 8 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 1 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 1 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 0 SUM_SORT_SCAN: 0 SUM_NO_INDEX_USED: 1 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2018-02-08 17:18:15 LAST_SEEN: 2018-02-08 17:18:15 *************************** 3. row *************************** SCHEMA_NAME: tempor DIGEST: fb89697afcdcb4ad09beac190f157f2f DIGEST_TEXT: CREATE TABLE `temp_b` ( `id` INTEGER PRIMARY KEY , `id_a` INTEGER , `nome` VARCHARACTER (?) , FOREIGN KEY ( `id_a` ) REFERENCES `temp_a` ( `id` ) ) COUNT_STAR: 1 SUM_TIMER_WAIT: 23876251000 MIN_TIMER_WAIT: 23876251000 AVG_TIMER_WAIT: 23876251000 MAX_TIMER_WAIT: 23876251000 SUM_LOCK_TIME: 0 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 0 SUM_ROWS_EXAMINED: 0 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 0 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 0 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 0 SUM_SORT_SCAN: 0 SUM_NO_INDEX_USED: 0 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2018-02-08 17:18:10 LAST_SEEN: 2018-02-08 17:18:10 *************************** 4. row *************************** SCHEMA_NAME: tempor DIGEST: 0866630a0e22f0a079999ff53a2d5303 DIGEST_TEXT: INSERT INTO `temp_a` VALUES (...) COUNT_STAR: 4 SUM_TIMER_WAIT: 20219946000 MIN_TIMER_WAIT: 1392698000 AVG_TIMER_WAIT: 5054986000 MAX_TIMER_WAIT: 13566573000 SUM_LOCK_TIME: 11923000000 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 4 SUM_ROWS_SENT: 0 SUM_ROWS_EXAMINED: 0 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 0 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 0 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 0 SUM_SORT_SCAN: 0 SUM_NO_INDEX_USED: 0 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2018-02-08 17:18:10 LAST_SEEN: 2018-02-08 17:18:10 *************************** 5. row *************************** SCHEMA_NAME: tempor DIGEST: fafbe3291084d7bc9f7d821036af144a DIGEST_TEXT: INSERT INTO `temp_b` VALUES (...) COUNT_STAR: 4 SUM_TIMER_WAIT: 10413721000 MIN_TIMER_WAIT: 2297272000 AVG_TIMER_WAIT: 2603430000 MAX_TIMER_WAIT: 3030059000 SUM_LOCK_TIME: 688000000 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 4 SUM_ROWS_SENT: 0 SUM_ROWS_EXAMINED: 0 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 0 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 0 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 0 SUM_SORT_SCAN: 0 SUM_NO_INDEX_USED: 0 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2018-02-08 17:18:10 LAST_SEEN: 2018-02-08 17:18:10 -------------- select sleep(1) -------------- sleep(1) 0 -------------- select * from ab_view where nome_b like '%tri%' -------------- id_a nome_a id_b nome_b 1 casa 1 triplex -------------- select * from performance_schema.events_statements_summary_by_digest order by LAST_SEEN desc limit 5 -------------- *************************** 1. row *************************** SCHEMA_NAME: tempor DIGEST: cfdb68993eb89b400ec31f5f1f49493b DIGEST_TEXT: SELECT `sleep` (?) COUNT_STAR: 2 SUM_TIMER_WAIT: 6000669472000 MIN_TIMER_WAIT: 1000259952000 AVG_TIMER_WAIT: 3000334736000 MAX_TIMER_WAIT: 5000409520000 SUM_LOCK_TIME: 0 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 2 SUM_ROWS_EXAMINED: 0 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 0 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 0 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 0 SUM_SORT_SCAN: 0 SUM_NO_INDEX_USED: 0 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2018-02-08 17:18:15 LAST_SEEN: 2018-02-08 17:18:16 *************************** 2. row *************************** SCHEMA_NAME: tempor DIGEST: 89c4e1026cee35d60dd22568af23905f DIGEST_TEXT: ( SELECT `a` . `id` AS `id_a` , `a` . `nome` AS `nome_a` , `b` . `id` AS `id_b` , `b` . `nome` AS `nome_b` FROM `tempor` . `temp_a` `a` JOIN `tempor` . `temp_b` `b` WHERE ( `a` . `id` = `b` . `id_a` ) ) COUNT_STAR: 2 SUM_TIMER_WAIT: 2011660000 MIN_TIMER_WAIT: 855053000 AVG_TIMER_WAIT: 1005830000 MAX_TIMER_WAIT: 1156607000 SUM_LOCK_TIME: 1050000000 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 5 SUM_ROWS_EXAMINED: 13 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 1 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 2 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 0 SUM_SORT_SCAN: 0 SUM_NO_INDEX_USED: 2 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2018-02-08 17:18:15 LAST_SEEN: 2018-02-08 17:18:16 *************************** 3. row *************************** SCHEMA_NAME: tempor DIGEST: e0eb0b787886513f7d580e619bd0ee79 DIGEST_TEXT: SELECT * FROM `performance_schema` . `events_statements_summary_by_digest` ORDER BY `LAST_SEEN` DESC LIMIT ? COUNT_STAR: 1 SUM_TIMER_WAIT: 1012363000 MIN_TIMER_WAIT: 1012363000 AVG_TIMER_WAIT: 1012363000 MAX_TIMER_WAIT: 1012363000 SUM_LOCK_TIME: 156000000 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 5 SUM_ROWS_EXAMINED: 15 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 0 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 1 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 5 SUM_SORT_SCAN: 1 SUM_NO_INDEX_USED: 1 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2018-02-08 17:18:15 LAST_SEEN: 2018-02-08 17:18:15 *************************** 4. row *************************** SCHEMA_NAME: tempor DIGEST: fb89697afcdcb4ad09beac190f157f2f DIGEST_TEXT: CREATE TABLE `temp_b` ( `id` INTEGER PRIMARY KEY , `id_a` INTEGER , `nome` VARCHARACTER (?) , FOREIGN KEY ( `id_a` ) REFERENCES `temp_a` ( `id` ) ) COUNT_STAR: 1 SUM_TIMER_WAIT: 23876251000 MIN_TIMER_WAIT: 23876251000 AVG_TIMER_WAIT: 23876251000 MAX_TIMER_WAIT: 23876251000 SUM_LOCK_TIME: 0 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 0 SUM_ROWS_EXAMINED: 0 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 0 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 0 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 0 SUM_SORT_SCAN: 0 SUM_NO_INDEX_USED: 0 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2018-02-08 17:18:10 LAST_SEEN: 2018-02-08 17:18:10 *************************** 5. row *************************** SCHEMA_NAME: tempor DIGEST: 0866630a0e22f0a079999ff53a2d5303 DIGEST_TEXT: INSERT INTO `temp_a` VALUES (...) COUNT_STAR: 4 SUM_TIMER_WAIT: 20219946000 MIN_TIMER_WAIT: 1392698000 AVG_TIMER_WAIT: 5054986000 MAX_TIMER_WAIT: 13566573000 SUM_LOCK_TIME: 11923000000 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 4 SUM_ROWS_SENT: 0 SUM_ROWS_EXAMINED: 0 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 0 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 0 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 0 SUM_SORT_SCAN: 0 SUM_NO_INDEX_USED: 0 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2018-02-08 17:18:10 LAST_SEEN: 2018-02-08 17:18:10 -------------- select sleep(1) -------------- sleep(1) 0 -------------- select a.* from temp_a a , ab_view b where a.id = b.id_a -------------- id nome 1 casa 1 casa 1 casa 2 barco -------------- select * from performance_schema.events_statements_summary_by_digest order by LAST_SEEN desc limit 5 -------------- *************************** 1. row *************************** SCHEMA_NAME: tempor DIGEST: cfdb68993eb89b400ec31f5f1f49493b DIGEST_TEXT: SELECT `sleep` (?) COUNT_STAR: 3 SUM_TIMER_WAIT: 7000971425000 MIN_TIMER_WAIT: 1000259952000 AVG_TIMER_WAIT: 2333657141000 MAX_TIMER_WAIT: 5000409520000 SUM_LOCK_TIME: 0 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 3 SUM_ROWS_EXAMINED: 0 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 0 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 0 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 0 SUM_SORT_SCAN: 0 SUM_NO_INDEX_USED: 0 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2018-02-08 17:18:15 LAST_SEEN: 2018-02-08 17:18:17 *************************** 2. row *************************** SCHEMA_NAME: tempor DIGEST: 89c4e1026cee35d60dd22568af23905f DIGEST_TEXT: ( SELECT `a` . `id` AS `id_a` , `a` . `nome` AS `nome_a` , `b` . `id` AS `id_b` , `b` . `nome` AS `nome_b` FROM `tempor` . `temp_a` `a` JOIN `tempor` . `temp_b` `b` WHERE ( `a` . `id` = `b` . `id_a` ) ) COUNT_STAR: 3 SUM_TIMER_WAIT: 2805311000 MIN_TIMER_WAIT: 793651000 AVG_TIMER_WAIT: 935103000 MAX_TIMER_WAIT: 1156607000 SUM_LOCK_TIME: 1481000000 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 9 SUM_ROWS_EXAMINED: 25 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 2 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 3 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 0 SUM_SORT_SCAN: 0 SUM_NO_INDEX_USED: 3 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2018-02-08 17:18:15 LAST_SEEN: 2018-02-08 17:18:17 *************************** 3. row *************************** SCHEMA_NAME: tempor DIGEST: e0eb0b787886513f7d580e619bd0ee79 DIGEST_TEXT: SELECT * FROM `performance_schema` . `events_statements_summary_by_digest` ORDER BY `LAST_SEEN` DESC LIMIT ? COUNT_STAR: 2 SUM_TIMER_WAIT: 1961202000 MIN_TIMER_WAIT: 948839000 AVG_TIMER_WAIT: 980601000 MAX_TIMER_WAIT: 1012363000 SUM_LOCK_TIME: 271000000 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 10 SUM_ROWS_EXAMINED: 31 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 0 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 2 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 10 SUM_SORT_SCAN: 2 SUM_NO_INDEX_USED: 2 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2018-02-08 17:18:15 LAST_SEEN: 2018-02-08 17:18:16 *************************** 4. row *************************** SCHEMA_NAME: tempor DIGEST: fb89697afcdcb4ad09beac190f157f2f DIGEST_TEXT: CREATE TABLE `temp_b` ( `id` INTEGER PRIMARY KEY , `id_a` INTEGER , `nome` VARCHARACTER (?) , FOREIGN KEY ( `id_a` ) REFERENCES `temp_a` ( `id` ) ) COUNT_STAR: 1 SUM_TIMER_WAIT: 23876251000 MIN_TIMER_WAIT: 23876251000 AVG_TIMER_WAIT: 23876251000 MAX_TIMER_WAIT: 23876251000 SUM_LOCK_TIME: 0 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 0 SUM_ROWS_EXAMINED: 0 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 0 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 0 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 0 SUM_SORT_SCAN: 0 SUM_NO_INDEX_USED: 0 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2018-02-08 17:18:10 LAST_SEEN: 2018-02-08 17:18:10 *************************** 5. row *************************** SCHEMA_NAME: tempor DIGEST: 0866630a0e22f0a079999ff53a2d5303 DIGEST_TEXT: INSERT INTO `temp_a` VALUES (...) COUNT_STAR: 4 SUM_TIMER_WAIT: 20219946000 MIN_TIMER_WAIT: 1392698000 AVG_TIMER_WAIT: 5054986000 MAX_TIMER_WAIT: 13566573000 SUM_LOCK_TIME: 11923000000 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 4 SUM_ROWS_SENT: 0 SUM_ROWS_EXAMINED: 0 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 0 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 0 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 0 SUM_SORT_SCAN: 0 SUM_NO_INDEX_USED: 0 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2018-02-08 17:18:10 LAST_SEEN: 2018-02-08 17:18:10 -------------- select sleep(1) -------------- sleep(1) 0 -------------- select a.* from temp_a a , ab_view b where a.id = b.id_a and a.nome like '%bar%' -------------- id nome 2 barco -------------- select * from performance_schema.events_statements_summary_by_digest order by LAST_SEEN desc limit 5 -------------- *************************** 1. row *************************** SCHEMA_NAME: tempor DIGEST: cfdb68993eb89b400ec31f5f1f49493b DIGEST_TEXT: SELECT `sleep` (?) COUNT_STAR: 4 SUM_TIMER_WAIT: 8001266896000 MIN_TIMER_WAIT: 1000259952000 AVG_TIMER_WAIT: 2000316724000 MAX_TIMER_WAIT: 5000409520000 SUM_LOCK_TIME: 0 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 4 SUM_ROWS_EXAMINED: 0 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 0 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 0 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 0 SUM_SORT_SCAN: 0 SUM_NO_INDEX_USED: 0 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2018-02-08 17:18:15 LAST_SEEN: 2018-02-08 17:18:18 *************************** 2. row *************************** SCHEMA_NAME: tempor DIGEST: 89c4e1026cee35d60dd22568af23905f DIGEST_TEXT: ( SELECT `a` . `id` AS `id_a` , `a` . `nome` AS `nome_a` , `b` . `id` AS `id_b` , `b` . `nome` AS `nome_b` FROM `tempor` . `temp_a` `a` JOIN `tempor` . `temp_b` `b` WHERE ( `a` . `id` = `b` . `id_a` ) ) COUNT_STAR: 4 SUM_TIMER_WAIT: 3517330000 MIN_TIMER_WAIT: 712019000 AVG_TIMER_WAIT: 879332000 MAX_TIMER_WAIT: 1156607000 SUM_LOCK_TIME: 1828000000 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 10 SUM_ROWS_EXAMINED: 31 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 2 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 4 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 0 SUM_SORT_SCAN: 0 SUM_NO_INDEX_USED: 4 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2018-02-08 17:18:15 LAST_SEEN: 2018-02-08 17:18:18 *************************** 3. row *************************** SCHEMA_NAME: tempor DIGEST: e0eb0b787886513f7d580e619bd0ee79 DIGEST_TEXT: SELECT * FROM `performance_schema` . `events_statements_summary_by_digest` ORDER BY `LAST_SEEN` DESC LIMIT ? COUNT_STAR: 3 SUM_TIMER_WAIT: 2875489000 MIN_TIMER_WAIT: 914287000 AVG_TIMER_WAIT: 958496000 MAX_TIMER_WAIT: 1012363000 SUM_LOCK_TIME: 413000000 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 15 SUM_ROWS_EXAMINED: 47 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 0 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 3 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 15 SUM_SORT_SCAN: 3 SUM_NO_INDEX_USED: 3 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2018-02-08 17:18:15 LAST_SEEN: 2018-02-08 17:18:17 *************************** 4. row *************************** SCHEMA_NAME: tempor DIGEST: fb89697afcdcb4ad09beac190f157f2f DIGEST_TEXT: CREATE TABLE `temp_b` ( `id` INTEGER PRIMARY KEY , `id_a` INTEGER , `nome` VARCHARACTER (?) , FOREIGN KEY ( `id_a` ) REFERENCES `temp_a` ( `id` ) ) COUNT_STAR: 1 SUM_TIMER_WAIT: 23876251000 MIN_TIMER_WAIT: 23876251000 AVG_TIMER_WAIT: 23876251000 MAX_TIMER_WAIT: 23876251000 SUM_LOCK_TIME: 0 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 0 SUM_ROWS_EXAMINED: 0 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 0 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 0 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 0 SUM_SORT_SCAN: 0 SUM_NO_INDEX_USED: 0 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2018-02-08 17:18:10 LAST_SEEN: 2018-02-08 17:18:10 *************************** 5. row *************************** SCHEMA_NAME: tempor DIGEST: 0866630a0e22f0a079999ff53a2d5303 DIGEST_TEXT: INSERT INTO `temp_a` VALUES (...) COUNT_STAR: 4 SUM_TIMER_WAIT: 20219946000 MIN_TIMER_WAIT: 1392698000 AVG_TIMER_WAIT: 5054986000 MAX_TIMER_WAIT: 13566573000 SUM_LOCK_TIME: 11923000000 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 4 SUM_ROWS_SENT: 0 SUM_ROWS_EXAMINED: 0 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 0 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 0 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 0 SUM_SORT_SCAN: 0 SUM_NO_INDEX_USED: 0 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2018-02-08 17:18:10 LAST_SEEN: 2018-02-08 17:18:10 -------------- select sleep(1) -------------- sleep(1) 0 -------------- select a.* from temp_a a , ab_view b where a.id = b.id_a and a.nome like '%bar%' and a.id = 2 -------------- id nome 2 barco -------------- select * from performance_schema.events_statements_summary_by_digest order by LAST_SEEN desc limit 5 -------------- *************************** 1. row *************************** SCHEMA_NAME: tempor DIGEST: cfdb68993eb89b400ec31f5f1f49493b DIGEST_TEXT: SELECT `sleep` (?) COUNT_STAR: 5 SUM_TIMER_WAIT: 9001568995000 MIN_TIMER_WAIT: 1000259952000 AVG_TIMER_WAIT: 1800313799000 MAX_TIMER_WAIT: 5000409520000 SUM_LOCK_TIME: 0 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 5 SUM_ROWS_EXAMINED: 0 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 0 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 0 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 0 SUM_SORT_SCAN: 0 SUM_NO_INDEX_USED: 0 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2018-02-08 17:18:15 LAST_SEEN: 2018-02-08 17:18:19 *************************** 2. row *************************** SCHEMA_NAME: tempor DIGEST: 89c4e1026cee35d60dd22568af23905f DIGEST_TEXT: ( SELECT `a` . `id` AS `id_a` , `a` . `nome` AS `nome_a` , `b` . `id` AS `id_b` , `b` . `nome` AS `nome_b` FROM `tempor` . `temp_a` `a` JOIN `tempor` . `temp_b` `b` WHERE ( `a` . `id` = `b` . `id_a` ) ) COUNT_STAR: 5 SUM_TIMER_WAIT: 4312713000 MIN_TIMER_WAIT: 712019000 AVG_TIMER_WAIT: 862542000 MAX_TIMER_WAIT: 1156607000 SUM_LOCK_TIME: 2206000000 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 11 SUM_ROWS_EXAMINED: 32 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 2 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 4 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 0 SUM_SORT_SCAN: 0 SUM_NO_INDEX_USED: 4 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2018-02-08 17:18:15 LAST_SEEN: 2018-02-08 17:18:19 *************************** 3. row *************************** SCHEMA_NAME: tempor DIGEST: e0eb0b787886513f7d580e619bd0ee79 DIGEST_TEXT: SELECT * FROM `performance_schema` . `events_statements_summary_by_digest` ORDER BY `LAST_SEEN` DESC LIMIT ? COUNT_STAR: 4 SUM_TIMER_WAIT: 3808755000 MIN_TIMER_WAIT: 914287000 AVG_TIMER_WAIT: 952188000 MAX_TIMER_WAIT: 1012363000 SUM_LOCK_TIME: 525000000 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 20 SUM_ROWS_EXAMINED: 63 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 0 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 4 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 20 SUM_SORT_SCAN: 4 SUM_NO_INDEX_USED: 4 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2018-02-08 17:18:15 LAST_SEEN: 2018-02-08 17:18:18 *************************** 4. row *************************** SCHEMA_NAME: tempor DIGEST: fb89697afcdcb4ad09beac190f157f2f DIGEST_TEXT: CREATE TABLE `temp_b` ( `id` INTEGER PRIMARY KEY , `id_a` INTEGER , `nome` VARCHARACTER (?) , FOREIGN KEY ( `id_a` ) REFERENCES `temp_a` ( `id` ) ) COUNT_STAR: 1 SUM_TIMER_WAIT: 23876251000 MIN_TIMER_WAIT: 23876251000 AVG_TIMER_WAIT: 23876251000 MAX_TIMER_WAIT: 23876251000 SUM_LOCK_TIME: 0 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 0 SUM_ROWS_EXAMINED: 0 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 0 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 0 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 0 SUM_SORT_SCAN: 0 SUM_NO_INDEX_USED: 0 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2018-02-08 17:18:10 LAST_SEEN: 2018-02-08 17:18:10 *************************** 5. row *************************** SCHEMA_NAME: tempor DIGEST: 0866630a0e22f0a079999ff53a2d5303 DIGEST_TEXT: INSERT INTO `temp_a` VALUES (...) COUNT_STAR: 4 SUM_TIMER_WAIT: 20219946000 MIN_TIMER_WAIT: 1392698000 AVG_TIMER_WAIT: 5054986000 MAX_TIMER_WAIT: 13566573000 SUM_LOCK_TIME: 11923000000 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 4 SUM_ROWS_SENT: 0 SUM_ROWS_EXAMINED: 0 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 0 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 0 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 0 SUM_SORT_SCAN: 0 SUM_NO_INDEX_USED: 0 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2018-02-08 17:18:10 LAST_SEEN: 2018-02-08 17:18:10 -------------- select sleep(1) -------------- sleep(1) 0 -------------- select * from ab_view where id_a = 1 -------------- id_a nome_a id_b nome_b 1 casa 1 triplex 1 casa 3 sobrado 1 casa 4 mansao -------------- select * from performance_schema.events_statements_summary_by_digest order by LAST_SEEN desc limit 5 -------------- *************************** 1. row *************************** SCHEMA_NAME: tempor DIGEST: cfdb68993eb89b400ec31f5f1f49493b DIGEST_TEXT: SELECT `sleep` (?) COUNT_STAR: 6 SUM_TIMER_WAIT: 10001901758000 MIN_TIMER_WAIT: 1000259952000 AVG_TIMER_WAIT: 1666983626000 MAX_TIMER_WAIT: 5000409520000 SUM_LOCK_TIME: 0 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 6 SUM_ROWS_EXAMINED: 0 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 0 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 0 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 0 SUM_SORT_SCAN: 0 SUM_NO_INDEX_USED: 0 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2018-02-08 17:18:15 LAST_SEEN: 2018-02-08 17:18:20 *************************** 2. row *************************** SCHEMA_NAME: tempor DIGEST: 89c4e1026cee35d60dd22568af23905f DIGEST_TEXT: ( SELECT `a` . `id` AS `id_a` , `a` . `nome` AS `nome_a` , `b` . `id` AS `id_b` , `b` . `nome` AS `nome_b` FROM `tempor` . `temp_a` `a` JOIN `tempor` . `temp_b` `b` WHERE ( `a` . `id` = `b` . `id_a` ) ) COUNT_STAR: 6 SUM_TIMER_WAIT: 5038525000 MIN_TIMER_WAIT: 712019000 AVG_TIMER_WAIT: 839754000 MAX_TIMER_WAIT: 1156607000 SUM_LOCK_TIME: 2612000000 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 14 SUM_ROWS_EXAMINED: 36 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 2 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 5 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 0 SUM_SORT_SCAN: 0 SUM_NO_INDEX_USED: 5 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2018-02-08 17:18:15 LAST_SEEN: 2018-02-08 17:18:20 *************************** 3. row *************************** SCHEMA_NAME: tempor DIGEST: e0eb0b787886513f7d580e619bd0ee79 DIGEST_TEXT: SELECT * FROM `performance_schema` . `events_statements_summary_by_digest` ORDER BY `LAST_SEEN` DESC LIMIT ? COUNT_STAR: 5 SUM_TIMER_WAIT: 4703434000 MIN_TIMER_WAIT: 894679000 AVG_TIMER_WAIT: 940686000 MAX_TIMER_WAIT: 1012363000 SUM_LOCK_TIME: 635000000 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 25 SUM_ROWS_EXAMINED: 79 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 0 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 5 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 25 SUM_SORT_SCAN: 5 SUM_NO_INDEX_USED: 5 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2018-02-08 17:18:15 LAST_SEEN: 2018-02-08 17:18:19 *************************** 4. row *************************** SCHEMA_NAME: tempor DIGEST: fb89697afcdcb4ad09beac190f157f2f DIGEST_TEXT: CREATE TABLE `temp_b` ( `id` INTEGER PRIMARY KEY , `id_a` INTEGER , `nome` VARCHARACTER (?) , FOREIGN KEY ( `id_a` ) REFERENCES `temp_a` ( `id` ) ) COUNT_STAR: 1 SUM_TIMER_WAIT: 23876251000 MIN_TIMER_WAIT: 23876251000 AVG_TIMER_WAIT: 23876251000 MAX_TIMER_WAIT: 23876251000 SUM_LOCK_TIME: 0 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 0 SUM_ROWS_EXAMINED: 0 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 0 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 0 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 0 SUM_SORT_SCAN: 0 SUM_NO_INDEX_USED: 0 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2018-02-08 17:18:10 LAST_SEEN: 2018-02-08 17:18:10 *************************** 5. row *************************** SCHEMA_NAME: tempor DIGEST: 0866630a0e22f0a079999ff53a2d5303 DIGEST_TEXT: INSERT INTO `temp_a` VALUES (...) COUNT_STAR: 4 SUM_TIMER_WAIT: 20219946000 MIN_TIMER_WAIT: 1392698000 AVG_TIMER_WAIT: 5054986000 MAX_TIMER_WAIT: 13566573000 SUM_LOCK_TIME: 11923000000 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 4 SUM_ROWS_SENT: 0 SUM_ROWS_EXAMINED: 0 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 0 SUM_SELECT_FULL_JOIN: 0 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 0 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 0 SUM_SORT_SCAN: 0 SUM_NO_INDEX_USED: 0 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2018-02-08 17:18:10 LAST_SEEN: 2018-02-08 17:18:10 -------------- drop database tempor --------------