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 | NESTING_EVENT_LEVEL | STATEMENT_ID | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28 | 1 | 1 | statement/sql/select | srv_session.cc:1107 | 1561134585000 | 1561215117000 | 80532000 | 0 | SELECT @@skip_networking, @@skip_name_resolve, @@h... | 1ebda414995104bec2d678a2f3a337c8cc504cafa93982ba39... | SELECT @@`skip_networking` , @@`skip_name_resolve`... | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 | 21 | |
14748 | 2 | 2 | statement/com/Init DB | init_net_server_extension.cc:95 | 778693269801000 | 778693630378000 | 360577000 | 95000000 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1049 | 42000 | Unknown database 'phpmyadmin' | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 | 243730 | |
14749 | 16 | NULL | statement/sql/select | init_net_server_extension.cc:95 | 778737037156000 | 778738530312000 | 1493156000 | 31000000 | SELECT COUNT(*) FROM `performance_schema`.`table_l... | 00e2f0d84fa651f12d7029618430a48906da993321f506b59a... | SELECT COUNT ( * ) FROM `performance_schema` . `ta... | performance_schema | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | NULL | NULL | 0 | 243766 | |
14750 | 2 | 2 | statement/com/Init DB | init_net_server_extension.cc:95 | 778699192568000 | 778699341352000 | 148784000 | 50000000 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1049 | 42000 | Unknown database 'phpmyadmin' | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 | 243736 | |
14751 | 10 | NULL | statement/sql/select | init_net_server_extension.cc:95 | 778738405709000 | 778738546129000 | 140420000 | 55000000 | SELECT * FROM `events_statements_current` LIMIT 0,... | 48a66f51b70d4dbcfae28baea5e7e549cd3303a632540a0923... | SELECT * FROM `events_statements_current` LIMIT ?,... | performance_schema | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | NULL | NULL | 0 | 243770 | |
14752 | 2 | 2 | statement/com/Init DB | init_net_server_extension.cc:95 | 778709135109000 | 778709224954000 | 89845000 | 31000000 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1049 | 42000 | Unknown database 'phpmyadmin' | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 | 243742 | |
14753 | 22 | 23 | statement/sql/show_keys | init_net_server_extension.cc:95 | 778736908297000 | 778738004160000 | 1095863000 | 625000000 | SHOW INDEXES FROM `performance_schema`.`table_lock... | e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... | SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | performance_schema | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 3 | 17 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 3 | 1 | 0 | 0 | NULL | NULL | 0 | 243765 |
|