SELECT * FROM `events_statements_current`
THREAD_ID | EVENT_ID | END_EVENT_ID | EVENT_NAME | SOURCE | TIMER_START | TIMER_END | TIMER_WAIT | LOCK_TIME | SQL_TEXT | DIGEST | DIGEST_TEXT | CURRENT_SCHEMA | OBJECT_TYPE | OBJECT_SCHEMA | OBJECT_NAME | OBJECT_INSTANCE_BEGIN | MYSQL_ERRNO | RETURNED_SQLSTATE | MESSAGE_TEXT | ERRORS | WARNINGS | ROWS_AFFECTED | ROWS_SENT | ROWS_EXAMINED | CREATED_TMP_DISK_TABLES | CREATED_TMP_TABLES | SELECT_FULL_JOIN | SELECT_FULL_RANGE_JOIN | SELECT_RANGE | SELECT_RANGE_CHECK | SELECT_SCAN | SORT_MERGE_PASSES | SORT_RANGE | SORT_ROWS | SORT_SCAN | NO_INDEX_USED | NO_GOOD_INDEX_USED | NESTING_EVENT_ID | NESTING_EVENT_TYPE | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1583066 | 121 | NULL | statement/sql/select | mysqld.cc:940 | 806923073392400000 | NULL | NULL | 2028000000 | SELECT COUNT(*) FROM `information_schema`.`TRIGGER... | NULL | NULL | information_schema | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 3 | 13 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | NULL | NULL | |
1583077 | 13 | 13 | statement/sql/show_fields | mysqld.cc:940 | 806922956229500000 | 806922962329300000 | 6099800000 | 0 | SHOW FULL COLUMNS FROM `mysql`.`user` | 4ae4ed396465d7a487bb5798cfb1d4af | SHOW FULL FIELDS FROM `mysql` . `user` | mysql | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 43 | 43 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | NULL | NULL | |
1583098 | 9 | 9 | statement/sql/show_binlogs | mysqld.cc:940 | 806923236571500000 | 806923236624000000 | 52500000 | 0 | SHOW MASTER LOGS | 26f671bf3cef88f71f187ca07a370633 | SHOW MASTER LOGS | mysql | NULL | NULL | NULL | NULL | 1381 | HY000 | You are not using binary logging | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | |
1583099 | 14 | 14 | statement/sql/show_tables | mysqld.cc:940 | 806923202984500000 | 806923203361500000 | 377000000 | 0 | SHOW TABLES FROM `test2` | 6a9562a16beeebac94fce45c4af5fc30 | SHOW TABLES FROM `test2` | test2 | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | NULL | NULL | |
1583100 | 9 | 9 | statement/sql/select | mysqld.cc:940 | 806923255101300000 | 806923255965200000 | 863900000 | 0 | SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SC... | 0d6c82272ddc0ba6755237ce1d976391 | SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA` . `... | mysql | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 8 | 16 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 8 | 1 | 1 | 0 | NULL | NULL | |
1583101 | 12 | 12 | statement/sql/show_fields | mysqld.cc:940 | 806923311991500000 | 806923316383800000 | 4392300000 | 8034000000 | SHOW FULL COLUMNS FROM `performance_schema`.`perfo... | 7752ac3a8f42e4e8674d65dd9af6b2c6 | SHOW FULL FIELDS FROM `performance_schema` . `perf... | performance_schema | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 4 | 4 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | NULL | NULL | |
1583102 | 5 | NULL | statement/sql/select | mysqld.cc:940 | 806923361821200000 | NULL | NULL | 0 | SELECT * FROM `events_statements_current` LIMIT 0... | NULL | NULL | performance_schema | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | NULL | NULL | |
1583104 | 8 | 8 | statement/sql/show_variables | mysqld.cc:940 | 806923149961900000 | 806923150500800000 | 538900000 | 0 | SHOW VARIABLES LIKE 'profiling' | 18d48176446b1d9596ef5766d1366743 | SHOW VARIABLES LIKE ? | mysql | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | NULL | NULL | |
1583105 | 15 | NULL | statement/sql/select | mysqld.cc:940 | 806923242646300000 | NULL | NULL | 8136000000 | SELECT COUNT(*) FROM `information_schema`.`COLUMNS... | NULL | NULL | information_schema | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 11 | 60 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | NULL | NULL | |
1583106 | 2 | 2 | statement/sql/set_option | mysqld.cc:940 | 806923350540200000 | 806923350604600000 | 64400000 | 0 | SET collation_connection = 'utf8mb4_general_ci' | 5004072ee7ccbcb3c65614c72cac435f | SET `collation_connection` = ? | NULL | NULL | NULL | NULL | NULL | 0 | 00000 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL |