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 | 2158432592000 | 2162459483000 | 4026891000 | 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 | |
4680 | 2 | 2 | statement/com/Init DB | init_net_server_extension.cc:95 | 328487047571000 | 328487280805000 | 233234000 | 75000000 | 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 | 69573 | |
4681 | 25 | 26 | statement/sql/show_fields | init_net_server_extension.cc:95 | 328523688261000 | 328524841413000 | 1153152000 | 331000000 | SHOW FULL COLUMNS FROM `performance_schema`.`table... | 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... | SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | performance_schema | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 68 | 343 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 68 | 1 | 0 | 0 | NULL | NULL | 0 | 69589 | |
4682 | 2 | 2 | statement/com/Init DB | init_net_server_extension.cc:95 | 328550812768000 | 328550865318000 | 52550000 | 18000000 | 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 | 69594 | |
4683 | 25 | 26 | statement/sql/show_fields | init_net_server_extension.cc:95 | 328579925301000 | 328581045040000 | 1119739000 | 316000000 | SHOW FULL COLUMNS FROM `performance_schema`.`table... | 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... | SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | performance_schema | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 68 | 343 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 68 | 1 | 0 | 0 | NULL | NULL | 0 | 69610 | |
4684 | 2 | 2 | statement/com/Init DB | init_net_server_extension.cc:95 | 328625407473000 | 328625473242000 | 65769000 | 18000000 | 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 | 69615 | |
4685 | 10 | NULL | statement/sql/select | init_net_server_extension.cc:95 | 328661658289000 | 328661837672000 | 179383000 | 62000000 | 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 | 69627 | |
4686 | 2 | 2 | statement/com/Init DB | init_net_server_extension.cc:95 | 328642160825000 | 328642246640000 | 85815000 | 18000000 | 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 | 69621 | |
4687 | 4 | 4 | statement/sql/set_option | init_net_server_extension.cc:95 | 328642743702000 | 328642777541000 | 33839000 | 0 | SET collation_connection = 'utf8mb4_unicode_ci' | d19d8b57dd28aea9deadc6222a76498766306a49d23a503f10... | 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 | 0 | 69622 |
|