Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: sys »View: x$waits_global_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 - 17 (18 total, Query took 0.0054 seconds.)
SELECT * FROM `x$waits_global_by_latency`
eventstotaltotal_latencyavg_latencymax_latency
wait/io/file/innodb/innodb_log_file 230344 2003248041485112 8696766690 1111932723380
wait/io/file/innodb/innodb_data_file 234822 1954312035273103 8322525175 2094662569154
wait/io/file/sql/binlog 77122 531530789556024 6892077149 399881605209
wait/io/table/sql/handler 22012113 48301232440298 2194287 508257569677
wait/io/file/myisam/dfile 39157515 25517347686302 651484 12361000508
wait/io/file/innodb/innodb_temp_file 7936 21404033214438 2697080617 154358917913
wait/io/file/myisam/kfile 328 389491465751 1187473762 65680391699
wait/lock/table/sql/handler 232343 209269650372 900533 94112338
wait/io/file/sql/binlog_index 23 157830216262 6862183139 78874240518
wait/io/file/sql/ERRMSG 5 149707513750 29941502750 72355825486
wait/io/file/sql/io_cache 11754 142432392735 12117765 537142054
wait/io/file/mysys/charset 3 47847731274 15949243758 47816480096
wait/io/file/sql/casetest 10 29481514938 2948151277 29167848156
wait/io/file/csv/metadata 16 24520860751 1532553780 17674404284
wait/io/file/csv/data 260 3760681634 14464083 355361216
wait/io/file/mysys/cnf 5 419012883 83802414 387556829
wait/io/file/sql/pid 3 138355798 46118509 89200734
wait/io/file/sql/misc 1 65926712 65926712 65926712