Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: sys »View: x$io_global_by_wait_by_bytes
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_bytes`
[Edit inline] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh]
|
|
|
Number of rows:
Filter rows:
event_nametotaltotal_latencymin_latencyavg_latencymax_latencycount_readtotal_readavg_readcount_writetotal_writtenavg_writtentotal_requested
innodb/innodb_data_file 295179 2466388235171549 0 8355567934 2094662569154 3110 53215232 17111.0071 170614 3872964608 22700.1571 3926179840
myisam/dfile 40767328 26557112471748 167478 651213 12361000508 26641336 1985839919 74.5398 149 21144 141.9060 1985861063
sql/io_cache 12422 150543201057 0 12118849 537142054 8919 191737004 21497.5899 3068 191677140 62476.2516 383414144
innodb/innodb_temp_file 9795 25116891558654 4347924 2564256200 259419332610 0 0 0.0000 9198 187285504 20361.5464 187285504
innodb/innodb_log_file 265320 2319663472587235 2139274 8742889535 1111932723380 8 70656 8832.0000 143685 140958208 981.0224 141028864
sql/binlog 96278 604097994511135 0 6274517471 399881605209 10474 140112 13.3771 27191 35483038 1304.9552 35623150
sql/ERRMSG 5 149707513750 11198804 29941502750 72355825486 3 308724 102908.0000 0 0 0.0000 308724
myisam/kfile 332 389502699785 555008 1173200734 65680391699 92 20308 220.7391 137 19043 139.0000 39351
mysys/charset 3 47847731274 9223214 15949243758 47816480096 1 19495 19495.0000 0 0 0.0000 19495
sql/binlog_index 23 157830216262 0 6862183139 78874240518 5 1312 262.4000 0 0 0.0000 1312
csv/metadata 16 24520860751 880750 1532553780 17674404284 3 105 35.0000 1 35 35.0000 140
mysys/cnf 5 419012883 222762 83802414 387556829 3 56 18.6667 0 0 0.0000 56
sql/pid 3 138355798 23826320 46118509 89200734 0 0 0.0000 1 5 5.0000 5
sql/casetest 10 29481514938 0 2948151277 29167848156 0 0 0.0000 0 0 0.0000 0
sql/misc 1 65926712 0 65926712 65926712 0 0 0.0000 0 0 0.0000 0
csv/data 290 4134038876 0 14255142 355361216 88 0 0.0000 0 0 0.0000 0

|
|
|
Number of rows:
Filter rows:
Query results operationsPrint PrintCopy to clipboard Copy to clipboardExport Export Display chart Display chart Create view Create view

Bookmark this SQL query Bookmark this SQL query