Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: performance_schema »Table: events_statements_history
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Browse mode

Customize browse mode.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available. Documentation
Showing rows 0 - 10 (11 total, Query took 0.0006 seconds.)
SELECT * FROM `events_statements_history`
THREAD_IDEVENT_IDEND_EVENT_IDEVENT_NAMESOURCETIMER_STARTTIMER_ENDTIMER_WAITLOCK_TIMESQL_TEXTDIGESTDIGEST_TEXTCURRENT_SCHEMAOBJECT_TYPEOBJECT_SCHEMAOBJECT_NAMEOBJECT_INSTANCE_BEGINMYSQL_ERRNORETURNED_SQLSTATEMESSAGE_TEXTERRORSWARNINGSROWS_AFFECTEDROWS_SENTROWS_EXAMINEDCREATED_TMP_DISK_TABLESCREATED_TMP_TABLESSELECT_FULL_JOINSELECT_FULL_RANGE_JOINSELECT_RANGESELECT_RANGE_CHECKSELECT_SCANSORT_MERGE_PASSESSORT_RANGESORT_ROWSSORT_SCANNO_INDEX_USEDNO_GOOD_INDEX_USEDNESTING_EVENT_IDNESTING_EVENT_TYPENESTING_EVENT_LEVELSTATEMENT_ID
31 1 1 statement/sql/select srv_session.cc:1107 20587155308928 20757221978688 170066669760 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
68949 1 2 statement/sql/select init_net_server_extension.cc:95 28170330566818752 28170330857450496 290631744 145000000 SELECT `config_data`, UNIX_TIMESTAMP(`timevalue`) ... cea77d989ffed6525e639d27a1f58807f348871ba2c48f718a... SELECT `config_data` , `UNIX_TIMESTAMP` ( `timeval... 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 1037901
68949 3 4 statement/sql/select init_net_server_extension.cc:95 28170353331956160 28170353553600960 221644800 114000000 SELECT * FROM `phpmyadmin`.`pma__bookmark` WHERE d... 850ba1adcdfe05c492ecc917cc3a849723cf1327942b4fdf39... SELECT * FROM `phpmyadmin` . `pma__bookmark` WHERE... NULL 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 1037903
68949 5 6 statement/sql/select init_net_server_extension.cc:95 28170362262856320 28170362391410304 128553984 65000000 SELECT `prefs` FROM `phpmyadmin`.`pma__table_uipre... 64b66d84611096a7bc89f9c876760d73bbcd18ef195e9b7f11... SELECT `prefs` FROM `phpmyadmin` . `pma__table_uip... NULL 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 1037905
68950 1 1 statement/sql/select init_net_server_extension.cc:95 28170322914809088 28170322988228928 73419840 0 SELECT @@version, @@version_comment a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff... SELECT @@`version` , @@`version_comment` 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 1037898
68950 2 2 statement/sql/set_option init_net_server_extension.cc:95 28170323807483520 28170323846548416 39064896 0 SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci' 52eaff6a7819ec096aa8c71501acd23ef138f2a775fc2827cc... SET NAMES ? COLLATE ? 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 1037899
68950 3 3 statement/sql/set_option init_net_server_extension.cc:95 28170323932158720 28170323967067776 34909056 0 SET lc_messages = 'en_US' 67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec... SET `lc_messages` = ? 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 1037900
68950 4 4 statement/sql/set_option init_net_server_extension.cc:95 28170334788598080 28170334940424768 151826688 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 1037902
68950 5 5 statement/sql/show_variables init_net_server_extension.cc:95 28170358432557120 28170359914529664 1481972544 74000000 SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS' 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... SHOW SESSION VARIABLES LIKE ? NULL NULL NULL NULL NULL 0 NULL NULL 0 0 0 1 579 0 1 0 0 0 0 2 0 0 0 0 1 0 NULL NULL 0 1037904
68950 6 6 statement/sql/select init_net_server_extension.cc:95 28170366629258880 28170366685778304 56519424 0 SELECT DATABASE() ce04eda080d3f5605113e1d0d47c2f20e23b091e2487ba586f... SELECT SCHEMA ( ) 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 1037906
68950 7 7 statement/com/Init DB init_net_server_extension.cc:95 28170366911024832 28170366980842944 69818112 0 NULL NULL NULL 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 1037907