-------------- 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 = TEMPTABLE 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: 5000428473000 MIN_TIMER_WAIT: 5000428473000 AVG_TIMER_WAIT: 5000428473000 MAX_TIMER_WAIT: 5000428473000 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:14:19 LAST_SEEN: 2018-02-08 17:14: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: 1 SUM_TIMER_WAIT: 1387599000 MIN_TIMER_WAIT: 1387599000 AVG_TIMER_WAIT: 1387599000 MAX_TIMER_WAIT: 1387599000 SUM_LOCK_TIME: 660000000 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 4 SUM_ROWS_EXAMINED: 12 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 1 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: 1 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2018-02-08 17:14:19 LAST_SEEN: 2018-02-08 17:14:19 *************************** 3. row *************************** SCHEMA_NAME: NULL DIGEST: 4fb483fe710f27d1d06f83573c5ce11c DIGEST_TEXT: SELECT @@`version_comment` LIMIT ? COUNT_STAR: 1 SUM_TIMER_WAIT: 606783000 MIN_TIMER_WAIT: 606783000 AVG_TIMER_WAIT: 606783000 MAX_TIMER_WAIT: 606783000 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:14:14 LAST_SEEN: 2018-02-08 17:14:14 *************************** 4. row *************************** SCHEMA_NAME: NULL DIGEST: 2cbac6ef48244e0574e54e34ac09786d DIGEST_TEXT: CREATE SCHEMA `tempor` COUNT_STAR: 1 SUM_TIMER_WAIT: 684704000 MIN_TIMER_WAIT: 684704000 AVG_TIMER_WAIT: 684704000 MAX_TIMER_WAIT: 684704000 SUM_LOCK_TIME: 0 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 1 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:14:14 LAST_SEEN: 2018-02-08 17:14:14 *************************** 5. row *************************** SCHEMA_NAME: NULL DIGEST: 2cf2906bafd55ee74be1b693d8234ae8 DIGEST_TEXT: SELECT SCHEMA ( ) COUNT_STAR: 1 SUM_TIMER_WAIT: 152254000 MIN_TIMER_WAIT: 152254000 AVG_TIMER_WAIT: 152254000 MAX_TIMER_WAIT: 152254000 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:14:14 LAST_SEEN: 2018-02-08 17:14:14 -------------- 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: 6000694445000 MIN_TIMER_WAIT: 1000265972000 AVG_TIMER_WAIT: 3000347222000 MAX_TIMER_WAIT: 5000428473000 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:14:19 LAST_SEEN: 2018-02-08 17:14: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: 2 SUM_TIMER_WAIT: 2227808000 MIN_TIMER_WAIT: 840209000 AVG_TIMER_WAIT: 1113904000 MAX_TIMER_WAIT: 1387599000 SUM_LOCK_TIME: 1080000000 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 5 SUM_ROWS_EXAMINED: 24 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 2 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: 2 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2018-02-08 17:14:19 LAST_SEEN: 2018-02-08 17:14: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: 1 SUM_TIMER_WAIT: 1286421000 MIN_TIMER_WAIT: 1286421000 AVG_TIMER_WAIT: 1286421000 MAX_TIMER_WAIT: 1286421000 SUM_LOCK_TIME: 169000000 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:14:19 LAST_SEEN: 2018-02-08 17:14:19 *************************** 4. row *************************** SCHEMA_NAME: NULL DIGEST: 4fb483fe710f27d1d06f83573c5ce11c DIGEST_TEXT: SELECT @@`version_comment` LIMIT ? COUNT_STAR: 1 SUM_TIMER_WAIT: 606783000 MIN_TIMER_WAIT: 606783000 AVG_TIMER_WAIT: 606783000 MAX_TIMER_WAIT: 606783000 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:14:14 LAST_SEEN: 2018-02-08 17:14:14 *************************** 5. row *************************** SCHEMA_NAME: NULL DIGEST: 2cbac6ef48244e0574e54e34ac09786d DIGEST_TEXT: CREATE SCHEMA `tempor` COUNT_STAR: 1 SUM_TIMER_WAIT: 684704000 MIN_TIMER_WAIT: 684704000 AVG_TIMER_WAIT: 684704000 MAX_TIMER_WAIT: 684704000 SUM_LOCK_TIME: 0 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 1 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:14:14 LAST_SEEN: 2018-02-08 17:14:14 -------------- 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: 7000999752000 MIN_TIMER_WAIT: 1000265972000 AVG_TIMER_WAIT: 2333666584000 MAX_TIMER_WAIT: 5000428473000 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:14:19 LAST_SEEN: 2018-02-08 17:14:21 *************************** 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: 3198034000 MIN_TIMER_WAIT: 840209000 AVG_TIMER_WAIT: 1066011000 MAX_TIMER_WAIT: 1387599000 SUM_LOCK_TIME: 1595000000 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 9 SUM_ROWS_EXAMINED: 40 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 3 SUM_SELECT_FULL_JOIN: 3 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 6 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:14:19 LAST_SEEN: 2018-02-08 17:14:21 *************************** 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: 2174746000 MIN_TIMER_WAIT: 888325000 AVG_TIMER_WAIT: 1087373000 MAX_TIMER_WAIT: 1286421000 SUM_LOCK_TIME: 278000000 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:14:19 LAST_SEEN: 2018-02-08 17:14:20 *************************** 4. row *************************** SCHEMA_NAME: NULL DIGEST: 4fb483fe710f27d1d06f83573c5ce11c DIGEST_TEXT: SELECT @@`version_comment` LIMIT ? COUNT_STAR: 1 SUM_TIMER_WAIT: 606783000 MIN_TIMER_WAIT: 606783000 AVG_TIMER_WAIT: 606783000 MAX_TIMER_WAIT: 606783000 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:14:14 LAST_SEEN: 2018-02-08 17:14:14 *************************** 5. row *************************** SCHEMA_NAME: NULL DIGEST: 2cbac6ef48244e0574e54e34ac09786d DIGEST_TEXT: CREATE SCHEMA `tempor` COUNT_STAR: 1 SUM_TIMER_WAIT: 684704000 MIN_TIMER_WAIT: 684704000 AVG_TIMER_WAIT: 684704000 MAX_TIMER_WAIT: 684704000 SUM_LOCK_TIME: 0 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 1 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:14:14 LAST_SEEN: 2018-02-08 17:14:14 -------------- 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: 8001242379000 MIN_TIMER_WAIT: 1000242627000 AVG_TIMER_WAIT: 2000310594000 MAX_TIMER_WAIT: 5000428473000 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:14:19 LAST_SEEN: 2018-02-08 17:14:22 *************************** 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: 4019711000 MIN_TIMER_WAIT: 821677000 AVG_TIMER_WAIT: 1004927000 MAX_TIMER_WAIT: 1387599000 SUM_LOCK_TIME: 2015000000 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 10 SUM_ROWS_EXAMINED: 53 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 4 SUM_SELECT_FULL_JOIN: 4 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 8 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:14:19 LAST_SEEN: 2018-02-08 17:14:22 *************************** 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: 3084381000 MIN_TIMER_WAIT: 888325000 AVG_TIMER_WAIT: 1028127000 MAX_TIMER_WAIT: 1286421000 SUM_LOCK_TIME: 388000000 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:14:19 LAST_SEEN: 2018-02-08 17:14:21 *************************** 4. row *************************** SCHEMA_NAME: NULL DIGEST: 4fb483fe710f27d1d06f83573c5ce11c DIGEST_TEXT: SELECT @@`version_comment` LIMIT ? COUNT_STAR: 1 SUM_TIMER_WAIT: 606783000 MIN_TIMER_WAIT: 606783000 AVG_TIMER_WAIT: 606783000 MAX_TIMER_WAIT: 606783000 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:14:14 LAST_SEEN: 2018-02-08 17:14:14 *************************** 5. row *************************** SCHEMA_NAME: NULL DIGEST: 2cbac6ef48244e0574e54e34ac09786d DIGEST_TEXT: CREATE SCHEMA `tempor` COUNT_STAR: 1 SUM_TIMER_WAIT: 684704000 MIN_TIMER_WAIT: 684704000 AVG_TIMER_WAIT: 684704000 MAX_TIMER_WAIT: 684704000 SUM_LOCK_TIME: 0 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 1 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:14:14 LAST_SEEN: 2018-02-08 17:14:14 -------------- 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: 9001548799000 MIN_TIMER_WAIT: 1000242627000 AVG_TIMER_WAIT: 1800309759000 MAX_TIMER_WAIT: 5000428473000 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:14:19 LAST_SEEN: 2018-02-08 17:14:23 *************************** 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: 4890532000 MIN_TIMER_WAIT: 821677000 AVG_TIMER_WAIT: 978106000 MAX_TIMER_WAIT: 1387599000 SUM_LOCK_TIME: 2448000000 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 11 SUM_ROWS_EXAMINED: 62 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 5 SUM_SELECT_FULL_JOIN: 5 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 9 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:14:19 LAST_SEEN: 2018-02-08 17:14:23 *************************** 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: 3953350000 MIN_TIMER_WAIT: 868969000 AVG_TIMER_WAIT: 988337000 MAX_TIMER_WAIT: 1286421000 SUM_LOCK_TIME: 501000000 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:14:19 LAST_SEEN: 2018-02-08 17:14:22 *************************** 4. row *************************** SCHEMA_NAME: NULL DIGEST: 4fb483fe710f27d1d06f83573c5ce11c DIGEST_TEXT: SELECT @@`version_comment` LIMIT ? COUNT_STAR: 1 SUM_TIMER_WAIT: 606783000 MIN_TIMER_WAIT: 606783000 AVG_TIMER_WAIT: 606783000 MAX_TIMER_WAIT: 606783000 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:14:14 LAST_SEEN: 2018-02-08 17:14:14 *************************** 5. row *************************** SCHEMA_NAME: NULL DIGEST: 2cbac6ef48244e0574e54e34ac09786d DIGEST_TEXT: CREATE SCHEMA `tempor` COUNT_STAR: 1 SUM_TIMER_WAIT: 684704000 MIN_TIMER_WAIT: 684704000 AVG_TIMER_WAIT: 684704000 MAX_TIMER_WAIT: 684704000 SUM_LOCK_TIME: 0 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 1 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:14:14 LAST_SEEN: 2018-02-08 17:14:14 -------------- select sleep(1) -------------- sleep(1) 0 -------------- select * from ab_view where id_a = 1 -------------- id_a nome_a id_b nome_b 1 casa 4 mansao 1 casa 3 sobrado 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: 6 SUM_TIMER_WAIT: 10001787982000 MIN_TIMER_WAIT: 1000239183000 AVG_TIMER_WAIT: 1666964663000 MAX_TIMER_WAIT: 5000428473000 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:14:19 LAST_SEEN: 2018-02-08 17:14:24 *************************** 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: 5605427000 MIN_TIMER_WAIT: 714895000 AVG_TIMER_WAIT: 934237000 MAX_TIMER_WAIT: 1387599000 SUM_LOCK_TIME: 2830000000 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 14 SUM_ROWS_EXAMINED: 73 SUM_CREATED_TMP_DISK_TABLES: 0 SUM_CREATED_TMP_TABLES: 6 SUM_SELECT_FULL_JOIN: 6 SUM_SELECT_FULL_RANGE_JOIN: 0 SUM_SELECT_RANGE: 0 SUM_SELECT_RANGE_CHECK: 0 SUM_SELECT_SCAN: 10 SUM_SORT_MERGE_PASSES: 0 SUM_SORT_RANGE: 0 SUM_SORT_ROWS: 0 SUM_SORT_SCAN: 0 SUM_NO_INDEX_USED: 6 SUM_NO_GOOD_INDEX_USED: 0 FIRST_SEEN: 2018-02-08 17:14:19 LAST_SEEN: 2018-02-08 17:14:24 *************************** 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: 4855304000 MIN_TIMER_WAIT: 868969000 AVG_TIMER_WAIT: 971060000 MAX_TIMER_WAIT: 1286421000 SUM_LOCK_TIME: 612000000 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:14:19 LAST_SEEN: 2018-02-08 17:14:23 *************************** 4. row *************************** SCHEMA_NAME: NULL DIGEST: 4fb483fe710f27d1d06f83573c5ce11c DIGEST_TEXT: SELECT @@`version_comment` LIMIT ? COUNT_STAR: 1 SUM_TIMER_WAIT: 606783000 MIN_TIMER_WAIT: 606783000 AVG_TIMER_WAIT: 606783000 MAX_TIMER_WAIT: 606783000 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:14:14 LAST_SEEN: 2018-02-08 17:14:14 *************************** 5. row *************************** SCHEMA_NAME: NULL DIGEST: 2cbac6ef48244e0574e54e34ac09786d DIGEST_TEXT: CREATE SCHEMA `tempor` COUNT_STAR: 1 SUM_TIMER_WAIT: 684704000 MIN_TIMER_WAIT: 684704000 AVG_TIMER_WAIT: 684704000 MAX_TIMER_WAIT: 684704000 SUM_LOCK_TIME: 0 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 1 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:14:14 LAST_SEEN: 2018-02-08 17:14:14 -------------- drop database tempor --------------