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 163581 1408427597191585 8609970539 1111932723380 89629455458 1984402252527 1406353565483600 8 70656 8832.0000 86407 88014336 1018.6019
innodb/innodb_data_file 119826 978527110747841 8166233513 2094662569154 10098062960908 21108754942318 947320292844615 3110 53215232 17111.0071 74183 1851277312 24955.5466
sql/binlog 45670 389088643951074 8519567378 399881605209 303143857420 494460685696 388291039407958 2694 108992 40.4573 17447 22976362 1316.9234
innodb/innodb_temp_file 2458 15411865625060 6270083640 154358917913 0 3799108828586 11612756796474 0 0 0.0000 2007 59817984 29804.6756
myisam/dfile 18541958 12135369784384 654465 12361000508 10756929558355 604746798 1377835479231 12102501 883446944 72.9971 49 7688 156.8980
myisam/kfile 245 388882083769 1587273558 65680391699 385119056901 385117558 3377909310 92 20308 220.7391 50 6863 137.2600
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 5991 82475958701 13766529 394160828 21694154601 30339668416 30442135684 4090 101709430 24867.8313 1636 101670946 62146.0550
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 184 2920775128 15873554 355361216 308064128 0 2612711000 54 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