Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: sys »View: x$waits_by_user_by_latency
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 - 16 (17 total, Query took 0.0015 seconds.)
SELECT * FROM `x$waits_by_user_by_latency`
usereventtotaltotal_latencyavg_latencymax_latency
pma wait/io/file/sql/binlog 38920 432343368643133 11108513846 399881605209
pma wait/io/table/sql/handler 106917 14449196829622 135143906 508257569677
pma wait/io/file/innodb/innodb_data_file 107 477131866032 4459176275 59980556557
pma wait/lock/table/sql/handler 170963 159020019540 930072 94112338
pma wait/io/file/myisam/dfile 4 62992324 15748081 17189530
pma wait/io/file/csv/data 1 16506068 16506068 16506068
root wait/io/table/sql/handler 12150824 18649394922072 1534673 85874539078
root wait/io/file/innodb/innodb_temp_file 864 14688819371855 17000948146 154358917913
root wait/io/file/myisam/dfile 21375240 13963443482868 653110 12361000508
root wait/io/file/sql/binlog 17598 4894108461407 278105891 230913685420
root wait/io/file/innodb/innodb_data_file 1846 1674114282809 906887408 188523025320
root wait/io/file/myisam/kfile 254 388906221197 1531126694 65680391699
root wait/io/file/sql/io_cache 8500 107310182985 12624535 445413974
root wait/io/file/csv/metadata 16 24520860751 1532553780 17674404284
root wait/lock/table/sql/handler 19095 13297691412 696199 31091288
root wait/io/file/csv/data 213 3313284482 15555129 355361216
root wait/io/file/sql/binlog_index 2 31873936 15936968 22739610