SELECT * FROM `x$io_global_by_file_by_latency`
|
file | total | total_latency | count_read | read_latency | count_write | write_latency | count_misc | misc_latency | |
---|---|---|---|---|---|---|---|---|---|
/var/lib/mysql/ib_logfile1 | 1336 | 8330358889248 | 2 | 859057584 | 793 | 312106124352 | 541 | 8017393707312 | |
/var/lib/mysql/ibdata1 | 388 | 2983623789696 | 20 | 10559287728 | 184 | 17869513200 | 184 | 2955194988768 | |
/var/lib/mysql/ib_logfile0 | 173 | 1216455892608 | 6 | 550321200 | 82 | 3867003888 | 85 | 1212038567520 | |
/var/lib/mysql/undo_002 | 1111 | 833589841920 | 385 | 27976526688 | 646 | 13448858016 | 80 | 792164457216 | |
/var/lib/mysql/undo_001 | 1059 | 794188066320 | 388 | 72291240384 | 596 | 18209970240 | 75 | 703686855696 | |
/var/lib/mysql/mysql.ibd | 620 | 608099321808 | 363 | 86716770096 | 162 | 3749608368 | 95 | 517632943344 | |
/var/lib/mysql/sku/Film.ibd | 9 | 342194990016 | 4 | 342094525872 | 0 | 0 | 5 | 100464144 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 131 | 255422256144 | 0 | 0 | 115 | 1709780160 | 16 | 253712475984 | |
/var/lib/mysql/ibtmp1 | 147 | 243080832192 | 0 | 0 | 143 | 11733584016 | 4 | 231347248176 | |
/var/lib/mysql/binlog.000007 | 228 | 204971588976 | 57 | 3542566368 | 1 | 6079920 | 170 | 201422942688 | |
/var/lib/mysql/binlog.000008 | 20 | 135861472560 | 0 | 0 | 9 | 1280345616 | 11 | 134581126944 | |
/var/lib/mysql/#innodb_temp/temp_4.ibt | 8 | 58002545568 | 0 | 0 | 3 | 286425216 | 5 | 57716120352 | |
/var/lib/mysql/#innodb_temp/temp_1.ibt | 8 | 52805956368 | 0 | 0 | 3 | 287657040 | 5 | 52518299328 | |
/var/lib/mysql/MuhdFitriAssignment2/ITEMS.ibd | 13 | 51115135104 | 0 | 0 | 7 | 191067888 | 6 | 50924067216 | |
/var/lib/mysql/#innodb_temp/temp_2.ibt | 8 | 45169024560 | 0 | 0 | 3 | 243435456 | 5 | 44925589104 | |
/var/lib/mysql/#innodb_temp/temp_8.ibt | 8 | 40910497584 | 0 | 0 | 3 | 274557360 | 5 | 40635940224 | |
/var/lib/mysql/#innodb_temp/temp_3.ibt | 8 | 39649558608 | 0 | 0 | 3 | 320872464 | 5 | 39328686144 | |
/var/lib/mysql/#innodb_temp/temp_6.ibt | 8 | 37193543376 | 0 | 0 | 3 | 259614960 | 5 | 36933928416 | |
/var/lib/mysql/#innodb_temp/temp_7.ibt | 8 | 36185827920 | 0 | 0 | 3 | 290502432 | 5 | 35895325488 | |
/var/lib/mysql/#innodb_temp/temp_5.ibt | 8 | 33168443616 | 0 | 0 | 3 | 289828176 | 5 | 32878615440 | |
/var/lib/mysql/#innodb_temp/temp_9.ibt | 8 | 32294218704 | 0 | 0 | 3 | 226727952 | 5 | 32067490752 | |
/var/lib/mysql/sakila/rental.ibd | 58 | 18922388496 | 53 | 18886671408 | 0 | 0 | 5 | 35717088 | |
/var/lib/mysql/binlog.index | 13 | 17130020160 | 3 | 29953440 | 0 | 0 | 10 | 17100066720 | |
/var/lib/mysql/sakila/staff.ibd | 14 | 15597996480 | 9 | 15566135904 | 0 | 0 | 5 | 31860576 | |
/var/lib/mysql/sakila/store.ibd | 10 | 12561746208 | 5 | 12506962512 | 0 | 0 | 5 | 54783696 |
|