Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: sys »View: x$io_global_by_wait_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 - 15 (16 total, Query took 0.0013 seconds.)
SELECT * FROM `x$io_global_by_wait_by_latency`
event_nametotaltotal_latencyavg_latencymax_latencyread_latencywrite_latencymisc_latencycount_readtotal_readavg_readcount_writetotal_writtenavg_written
innodb/innodb_log_file 152941 1320337127821619 8632983317 1111932723380 89629455458 1811839534540 1318435658831621 8 70656 8832.0000 80407 82470400 1025.6619
innodb/innodb_data_file 101639 827668863153262 8143221006 2094662569154 10098062960908 18163812703417 799406987488937 3110 53215232 17111.0071 64216 1642840064 25583.0333
sql/binlog 39146 368018525044885 9401178074 399881605209 297870116120 456467989746 367264186939019 1592 88208 55.4070 16389 21641590 1320.4948
innodb/innodb_temp_file 2199 14894776528252 6773431723 154358917913 0 3603505756723 11291270771529 0 0 0.0000 1761 54935552 31195.6570
myisam/dfile 8709273 5832251108884 669641 12361000508 5161340783908 302568248 670607756728 5667950 398850185 70.3694 21 3264 155.4286
myisam/kfile 217 388666140129 1791088051 65680391699 385119056901 169173918 3377909310 92 20308 220.7391 22 2943 133.7727
sql/binlog_index 23 157830216262 6862183139 78874240518 59128948 0 157771087314 5 1312 262.4000 0 0 0.0000
sql/ERRMSG 5 149707513750 29941502750 72355825486 77340489460 0 72367024290 3 308724 102908.0000 0 0 0.0000
sql/io_cache 5677 78691793291 13861379 394160828 20719731283 29027981804 28944080204 3861 97448274 25239.1282 1566 97418342 62208.3921
mysys/charset 3 47847731274 15949243758 47816480096 47816480096 0 31251178 1 19495 19495.0000 0 0 0.0000
sql/casetest 10 29481514938 2948151277 29167848156 0 0 29481514938 0 0 0.0000 0 0 0.0000
csv/metadata 16 24520860751 1532553780 17674404284 144735138 34626212 24341499401 3 105 35.0000 1 35 35.0000
csv/data 179 2823581520 15774097 355361216 303399134 0 2520182386 53 0 0.0000 0 0 0.0000
mysys/cnf 5 419012883 83802414 387556829 23992714 0 395020169 3 56 18.6667 0 0 0.0000
sql/pid 3 138355798 46118509 89200734 0 23826320 114529478 0 0 0.0000 1 5 5.0000
sql/misc 1 65926712 65926712 65926712 0 0 65926712 0 0 0.0000 0 0 0.0000