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.0008 seconds.)
SELECT * FROM `x$io_global_by_file_by_latency`
filetotaltotal_latencycount_readread_latencycount_writewrite_latencycount_miscmisc_latency
C:\xampp\mysql\data\ib_logfile1 98048 801788029265002 0 0 51981 1132416858916 46067 800655612406086
C:\xampp\mysql\data\ib_logfile0 67023 617388265204660 8 89629455458 35266 875754781660 31749 616422880967542
C:\xampp\mysql\data\ibdata1 44277 546892648547822 12 466219237761 22130 19538003699039 22135 526888425611022
C:\xampp\mysql\data\binlog.000153 35186 391350883942811 0 0 17592 496384285972 17594 390854499656839
C:\xampp\mysql\data\undo_002 34129 196320785719936 391 830240621359 24870 838383620687 8868 194652161477890
C:\xampp\mysql\data\undo_001 34189 172603825531747 396 4125059567149 25058 814824703704 8735 167663941260894
C:\xampp\mysql\data\phpmyadmin\pma__recent.ibd 6198 72070835058426 3 25845084094 3095 192865892731 3100 71852124081601
C:\xampp\mysql\data\simpedak_db\sidokaf_accreditat... 17633112 11359547248920 11535254 10096176922045 53 679419764 6097805 1262690907111
C:\xampp\mysql\data\#innodb_temp\temp_9.ibt 2061 9380676540806 0 0 1798 2419197755748 263 6961478785058
C:\xampp\mysql\data\#innodb_temp\temp_10.ibt 351 4938993324478 0 0 201 1135821919987 150 3803171404491
C:\xampp\mysql\data\mysql.ibd 1014 4824930288155 873 2549436999413 70 13757183836 71 2261736104906
C:\xampp\mysql\data\phpmyadmin\pma__favorite.ibd 330 3215170483746 3 30834714956 161 14648318014 166 3169687450776
C:\xampp\mysql\data\simpedak_db\sidokaf_accreditat... 149 1131318477217 40 1336991237 53 23947944800 56 1106033541180
C:\xampp\mysql\data\material@002dteknik\permintaan... 1271335 817227824659 795800 720291405415 0 0 475535 96936419244
C:\xampp\mysql\data\simpedak_db\accreditation_inst... 737222 549513350611 491442 483225238973 0 0 245780 66288111638
C:\xampp\mysql\data\simpedak_db\user_log.ibd 124 507991495373 99 132037854405 10 3249850157 15 372703790811
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