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.0007 seconds.)
SELECT * FROM `x$io_global_by_file_by_latency`
filetotaltotal_latencycount_readread_latencycount_writewrite_latencycount_miscmisc_latency
C:\xampp\mysql\data\ib_logfile1 88252 725775853043417 0 0 46314 1008238261961 41938 724767614781456
C:\xampp\mysql\data\ib_logfile0 64699 594612984596600 8 89629455458 34099 803754706275 30592 593719600434867
C:\xampp\mysql\data\ibdata1 33545 439286492880031 12 466219237761 16764 16561122431293 16769 422259151210977
C:\xampp\mysql\data\binlog.000153 32782 367596439022156 0 0 16390 456476396708 16392 367139962625448
C:\xampp\mysql\data\undo_002 30282 173408113978484 391 830240621359 22457 706009414903 7434 171871863942222
C:\xampp\mysql\data\undo_001 30349 151458467556276 396 4125059567149 22625 683042810154 7328 146650365178973
C:\xampp\mysql\data\phpmyadmin\pma__recent.ibd 3962 52355668139438 3 25845084094 1977 105897294946 1982 52223925760398
C:\xampp\mysql\data\#innodb_temp\temp_9.ibt 1784 8744472750604 0 0 1536 2160474461435 248 6583998289169
C:\xampp\mysql\data\#innodb_temp\temp_10.ibt 351 4938993324478 0 0 201 1135821919987 150 3803171404491
C:\xampp\mysql\data\simpedak_db\sidokaf_accreditat... 7096767 4631308123312 4642434 4117168061512 21 302568248 2454312 513837493552
C:\xampp\mysql\data\mysql.ibd 990 4540397053028 873 2549436999413 58 12047552423 59 1978912501192
C:\xampp\mysql\data\phpmyadmin\pma__favorite.ibd 330 3215170483746 3 30834714956 161 14648318014 166 3169687450776
C:\xampp\mysql\data\material@002dteknik\permintaan... 1192145 769180027093 746196 678213350861 0 0 445949 90966676232
C:\xampp\mysql\data\simpedak_db\sidokaf_accreditat... 87 693257841336 40 1336991237 22 20368855930 25 671551994169
C:\xampp\mysql\data\simpedak_db\user_log.ibd 116 415063707316 99 132037854405 6 2307016225 11 280718836686
C:\xampp\mysql\data\simpedak_db\accreditation_inst... 374972 287461897439 249944 253866764559 0 0 125028 33595132880
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\#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
C:\xampp\mysql\data\#innodb_temp\temp_6.ibt 8 142941034532 0 0 3 17979823723 5 124961210809