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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1007785 | 14 | 14 | statement/sql/select | mysqld.cc:940 | 2311496869002100000 | 2311496869796600000 | 794500000 | 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 | |
1007788 | 7 | 7 | statement/sql/select | mysqld.cc:940 | 2311496828596400000 | 2311496829684900000 | 1088500000 | 0 | SELECT (COUNT(`SCHEMA_NAME`) DIV 250) * 250 FROM `... | 6e554fd61a0a59021a50e63b0a26e110 | SELECT ( COUNT ( `SCHEMA_NAME` ) DIV ? ) * ? FROM ... | test3 | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 1 | 8 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | NULL | NULL | |
1007790 | 8 | 8 | statement/sql/show_binlogs | mysqld.cc:940 | 2311496884415600000 | 2311496884494800000 | 79200000 | 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 | |
1007791 | 4 | NULL | statement/sql/select | mysqld.cc:940 | 2311496886780200000 | NULL | NULL | 0 | SELECT * FROM `events_statements_current` LIMIT 0... | NULL | NULL | performance_schema | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | NULL | NULL | |
1007792 | 11 | 11 | statement/sql/show_fields | mysqld.cc:940 | 2311496785878200000 | 2311496792043800000 | 6165600000 | 15626000000 | SHOW FULL COLUMNS FROM `mysql`.`help_category` | d5cfd08ac123ed3a6f4d0cf4017dab89 | SHOW FULL FIELDS FROM `mysql` . `help_category` | mysql | 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 |