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 58470 641417278698030 10970023361 399881605209
pma wait/io/table/sql/handler 158753 15618678765580 98383298 508257569677
pma wait/io/file/innodb/innodb_data_file 107 477131866032 4459176275 59980556557
pma wait/lock/table/sql/handler 255261 236715739594 927091 94112338
pma wait/io/file/myisam/dfile 22 391579282 17799009 36578496
pma wait/io/file/csv/data 1 16506068 16506068 16506068
root wait/io/table/sql/handler 22841700 35259570451447 1543616 85874539078
root wait/io/file/myisam/dfile 40889698 26637296819490 651213 12361000508
root wait/io/file/innodb/innodb_temp_file 1152 20146600034966 17488367933 154358917913
root wait/io/file/sql/binlog 55938 10372105439155 185421452 230913685420
root wait/io/file/innodb/innodb_data_file 1846 1674114282809 906887408 188523025320
root wait/io/file/myisam/kfile 332 389502699785 1173200734 65680391699
root wait/io/file/sql/io_cache 12706 152985641131 12040259 537142054
root wait/io/file/csv/metadata 16 24520860751 1532553780 17674404284
root wait/lock/table/sql/handler 31638 21278263096 672351 31091288
root wait/io/file/csv/data 295 4228542538 14334003 355361216
root wait/io/file/sql/binlog_index 2 31873936 15936968 22739610