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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29 | 1 | 1 | statement/sql/select | srv_session.cc:1107 | 2053219513000 | 2056216842000 | 2997329000 | 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 | 2 | |
17948 | 344 | 345 | statement/sql/select | init_net_server_extension.cc:95 | 863691620071000 | 863691776052000 | 155981000 | 87000000 | /*NOTRACK*/ SELECT 1 FROM `phpmyadmin`.`pma__track... | 603da55acfc576f0f0ddb63f3abfb2b341607f72dfe9c3a956... | SELECT ? FROM `phpmyadmin` . `pma__tracking` WHERE... | phpmyadmin | 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 | 841517 | |
17951 | 101 | 102 | statement/sql/select | init_net_server_extension.cc:95 | 863673987445000 | 863674446324000 | 458879000 | 376000000 | SELECT 1 FROM `information_schema`.`FILES` LIMIT 1 | 56ebc6e21608c16d20579b17eca3668ef7bae51b1c1cdd8a06... | SELECT `internal_tablespace_id` ( `ts` . `name` , ... | information_schema | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 | 841493 | |
17956 | 120 | 121 | statement/sql/select | init_net_server_extension.cc:95 | 863690111427000 | 863690224657000 | 113230000 | 55000000 | /*NOTRACK*/ SELECT 1 FROM `phpmyadmin`.`pma__track... | 603da55acfc576f0f0ddb63f3abfb2b341607f72dfe9c3a956... | SELECT ? FROM `phpmyadmin` . `pma__tracking` WHERE... | phpmyadmin | 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 | 841515 | |
17957 | 31 | 32 | statement/sql/show_fields | init_net_server_extension.cc:95 | 863642216950000 | 863643530354000 | 1313404000 | 456000000 | SHOW FULL COLUMNS FROM `performance_schema`.`event... | 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... | SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | performance_schema | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 42 | 213 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 42 | 1 | 0 | 0 | NULL | NULL | 0 | 841454 | |
17958 | 68 | 69 | statement/sql/select | init_net_server_extension.cc:95 | 863691620110000 | 863691786663000 | 166553000 | 125000000 | /*NOTRACK*/ SELECT 1 FROM `phpmyadmin`.`pma__track... | 603da55acfc576f0f0ddb63f3abfb2b341607f72dfe9c3a956... | SELECT ? FROM `phpmyadmin` . `pma__tracking` WHERE... | phpmyadmin | 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 | 841518 | |
17959 | 10 | NULL | statement/sql/select | init_net_server_extension.cc:95 | 863691929066000 | 863692153096000 | 224030000 | 61000000 | 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 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | NULL | NULL | 0 | 841519 | |
17746 | 103 | 103 | statement/com/Quit | init_net_server_extension.cc:95 | 854463871936000 | 854463876472000 | 4536000 | 0 | NULL | NULL | NULL | information_schema | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 | 830379 | |
17747 | 346 | 346 | statement/com/Quit | init_net_server_extension.cc:95 | 854463698214000 | 854463704168000 | 5954000 | 0 | NULL | NULL | NULL | phpmyadmin | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | 0 | 830378 |
|