Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: sys »View: x$io_global_by_file_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 - ... This view has at least this number of rows. Please refer to documentation. (Query took 0.0011 seconds.)
SELECT * FROM `x$io_global_by_file_by_latency`
filetotaltotal_latencycount_readread_latencycount_writewrite_latencycount_miscmisc_latency
C:\xampp\mysql\data\ib_logfile1 105465 863809735524393 0 0 56253 1230008182722 49212 862579727341671
C:\xampp\mysql\data\ib_logfile0 68741 635306601072626 8 89629455458 36126 928449443868 32607 634288522173300
C:\xampp\mysql\data\ibdata1 52289 626799339500293 12 466219237761 26136 21769307245401 26141 604563813017131
C:\xampp\mysql\data\binlog.000153 36920 410644901053285 0 0 18459 507970056834 18461 410136930996451
C:\xampp\mysql\data\undo_002 37099 213453306424994 391 830240621359 26753 942172474929 9955 211680893328706
C:\xampp\mysql\data\undo_001 37127 189034692543114 396 4125059567149 26936 916121640860 9795 183993511335105
C:\xampp\mysql\data\phpmyadmin\pma__recent.ibd 7900 87147409846455 3 25845084094 3946 260020813587 3951 86861543948774
C:\xampp\mysql\data\simpedak_db\sidokaf_accreditat... 18588733 11967581598868 12160438 10636641141739 56 701370222 6428239 1330239086907
C:\xampp\mysql\data\#innodb_temp\temp_9.ibt 3160 10181385418461 0 0 2887 2922528223206 273 7258857195255
C:\xampp\mysql\data\mysql.ibd 1022 4969530251355 873 2549436999413 74 15550082980 75 2404543168962
C:\xampp\mysql\data\#innodb_temp\temp_10.ibt 351 4938993324478 0 0 201 1135821919987 150 3803171404491
C:\xampp\mysql\data\phpmyadmin\pma__favorite.ibd 330 3215170483746 3 30834714956 161 14648318014 166 3169687450776
C:\xampp\mysql\data\simpedak_db\sidokaf_accreditat... 161 1235770290412 40 1336991237 59 24878779936 62 1209554519239
C:\xampp\mysql\data\material@002dteknik\permintaan... 1271336 817245244539 795800 720291405415 0 0 475536 96953839124
C:\xampp\mysql\data\simpedak_db\accreditation_inst... 802244 597364850411 534789 525229111613 0 0 267455 72135738798
C:\xampp\mysql\data\simpedak_db\user_log.ibd 128 556643589877 99 132037854405 12 4445759065 17 420159976407
C:\xampp\mysql\data\ibtmp1 147 233732268887 0 0 143 51040508018 4 182691760869
C:\xampp\mysql\data\#innodb_temp\temp_5.ibt 8 217097076704 0 0 3 41736544690 5 175360532014
C:\xampp\mysql\data\#innodb_temp\temp_1.ibt 8 204417667727 0 0 3 32724164625 5 171693503102
C:\xampp\mysql\data\arsip_surat\tbl_surat_keluar.i... 8 198341823879 3 189099974022 0 0 5 9241849857
C:\xampp\mysql\data\arsip_surat\tbl_suma.ibd 546 194215115282 525 19771205267 8 1541249086 13 172902660929
C:\xampp\mysql\data\#innodb_temp\temp_7.ibt 8 187221161645 0 0 3 70412185573 5 116808976072
C:\xampp\mysql\data\pengiriman\pengiriman.ibd 19 171432266419 4 1575112433 5 4754341345 10 165102812641
C:\xampp\mysql\share\english\errmsg.sys 5 149707513750 3 77340489460 0 0 2 72367024290
C:\xampp\mysql\data\#innodb_temp\temp_2.ibt 8 149010816923 0 0 3 65162068427 5 83848748496