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 - 17 (18 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
91297 1 1 statement/com/Init DB init_net_server_extension.cc:95 65850793061556672 65850793175149632 113592960 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 1446561
91297 2 3 statement/sql/show_tables init_net_server_extension.cc:95 65850793272673344 65850794017953984 745280640 452000000 SHOW TABLES FROM `phpmyadmin` c0d9adc65303cbad4ff4e71fab7bb4f071392ea4456d3d741c... SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... phpmyadmin NULL NULL NULL NULL 0 NULL NULL 0 0 0 19 78 0 0 0 0 0 0 1 0 0 19 1 0 0 NULL NULL 0 1446562
91297 4 5 statement/sql/show_fields init_net_server_extension.cc:95 65850794859650112 65850795446177664 586527552 336000000 SHOW COLUMNS FROM `phpmyadmin`.`pma__column_info` ... d729cc74b9ca9bf3f11493ec73f93430c3a0d05a09b1141a61... SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... phpmyadmin NULL NULL NULL NULL 0 NULL NULL 0 0 0 2 23 0 1 0 0 0 0 1 0 0 2 1 0 0 NULL NULL 0 1446563
91297 6 7 statement/sql/select init_net_server_extension.cc:95 65850812533606464 65850812702887680 169281216 79000000 SELECT `config_data`, UNIX_TIMESTAMP(`timevalue`) ... cea77d989ffed6525e639d27a1f58807f348871ba2c48f718a... SELECT `config_data` , `UNIX_TIMESTAMP` ( `timeval... phpmyadmin 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 1446567
91297 8 9 statement/sql/select init_net_server_extension.cc:95 65850816772563264 65850817076216640 303653376 135000000 SELECT `config_data`, UNIX_TIMESTAMP(`timevalue`) ... cea77d989ffed6525e639d27a1f58807f348871ba2c48f718a... SELECT `config_data` , `UNIX_TIMESTAMP` ( `timeval... phpmyadmin 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 1446568
91297 10 11 statement/sql/select init_net_server_extension.cc:95 65850844681799424 65850844910647680 228848256 107000000 SELECT * FROM `phpmyadmin`.`pma__bookmark` WHERE d... 850ba1adcdfe05c492ecc917cc3a849723cf1327942b4fdf39... SELECT * FROM `phpmyadmin` . `pma__bookmark` 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 1446572
91297 12 13 statement/sql/select init_net_server_extension.cc:95 65850851145238848 65850851293740864 148502016 78000000 SELECT `prefs` FROM `phpmyadmin`.`pma__table_uipre... 64b66d84611096a7bc89f9c876760d73bbcd18ef195e9b7f11... SELECT `prefs` FROM `phpmyadmin` . `pma__table_uip... 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 1446575
91298 1 1 statement/sql/select init_net_server_extension.cc:95 65850808610493504 65850808668952320 58458816 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 1446564
91298 2 2 statement/sql/set_option init_net_server_extension.cc:95 65850808776172992 65850808815237888 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 1446565
91298 3 3 statement/sql/set_option init_net_server_extension.cc:95 65850808897800576 65850808932709632 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 1446566
91298 4 4 statement/sql/set_option init_net_server_extension.cc:95 65850819171868224 65850819244733952 72865728 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 1446569
91298 5 5 statement/sql/select init_net_server_extension.cc:95 65850819761443392 65850819813529920 52086528 0 SELECT CURRENT_USER() 3eff569d77bf7e2ccb14bd593a390e6187f054f1435d6bed2f... SELECT CURRENT_USER ( ) 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 1446570
91298 6 6 statement/sql/show_grants init_net_server_extension.cc:95 65850824840156928 65850824974529088 134372160 0 SHOW GRANTS 357c2f9945785534854aa7e387a6a8c95121e3b10a0e9ab178... SHOW GRANTS 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 1446571
91298 7 8 statement/sql/select init_net_server_extension.cc:95 65850846325572672 65850846420048768 94476096 41000000 SELECT 1 FROM mysql.user LIMIT 1 caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049... SELECT ? FROM `mysql` . `user` LIMIT ? NULL NULL NULL NULL NULL 0 NULL NULL 0 0 0 1 1 0 0 0 0 0 0 1 0 0 0 0 0 0 NULL NULL 0 1446573
91298 9 9 statement/sql/show_variables init_net_server_extension.cc:95 65850846785485632 65850848752029120 1966543488 129000000 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 1446574
91298 10 10 statement/sql/select init_net_server_extension.cc:95 65850855632714880 65850855693113088 60398208 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 1446576
91298 11 11 statement/com/Init DB init_net_server_extension.cc:95 65850855847987392 65850855915312000 67324608 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 1446577