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 34034 379785792037976 11159011173 399881605209
pma wait/io/table/sql/handler 93779 14165336942504 151049980 508257569677
pma wait/io/file/innodb/innodb_data_file 107 477131866032 4459176275 59980556557
pma wait/lock/table/sql/handler 149273 138406146006 927091 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 9744786 15471891581434 1587518 85874539078
root wait/io/file/innodb/innodb_temp_file 792 13244956661575 16723430054 154358917913
root wait/io/file/myisam/dfile 17890936 11718758210162 655007 12361000508
root wait/io/file/sql/binlog 10224 3607021625629 352799453 100401043134
root wait/io/file/innodb/innodb_data_file 1846 1674114282809 906887408 188523025320
root wait/io/file/myisam/kfile 243 388878792745 1600324105 65680391699
root wait/io/file/sql/io_cache 5991 82475958701 13766529 394160828
root wait/io/file/csv/metadata 16 24520860751 1532553780 17674404284
root wait/lock/table/sql/handler 15836 11094904226 700535 31091288
root wait/io/file/csv/data 182 2888461630 15870573 355361216
root wait/io/file/sql/binlog_index 2 31873936 15936968 22739610