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 | 2061 | 10237885146720 | 2 | 854109696 | 1406 | 683039865552 | 653 | 9553991171472 | |
/var/lib/mysql/ibdata1 | 243 | 1820419095792 | 20 | 7765280160 | 114 | 15007090032 | 109 | 1797646725600 | |
/var/lib/mysql/ib_logfile0 | 97 | 671213346672 | 6 | 498700752 | 44 | 3087207024 | 47 | 667627438896 | |
/var/lib/mysql/mysql.ibd | 771 | 665572405344 | 433 | 124910681280 | 281 | 10100978448 | 57 | 530560745616 | |
/var/lib/mysql/undo_002 | 974 | 580859837712 | 385 | 24569545968 | 542 | 16440770016 | 47 | 539849521728 | |
/var/lib/mysql/undo_001 | 1041 | 571626863280 | 389 | 44071497888 | 601 | 19530996144 | 51 | 508024369248 | |
/var/lib/mysql/binlog.000008 | 74 | 559493774928 | 0 | 0 | 36 | 1283845200 | 38 | 558209929728 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 44 | 331921199280 | 0 | 0 | 27 | 1498378464 | 17 | 330422820816 | |
/var/lib/mysql/ibtmp1 | 147 | 239327642400 | 0 | 0 | 143 | 8029497168 | 4 | 231298145232 | |
/var/lib/mysql/Hola/Estudiantes.ibd | 17 | 67140833760 | 0 | 0 | 9 | 242532576 | 8 | 66898301184 | |
/var/lib/mysql/#innodb_temp/temp_1.ibt | 8 | 44003090208 | 0 | 0 | 3 | 244810896 | 5 | 43758279312 | |
/var/lib/mysql/#innodb_temp/temp_5.ibt | 8 | 41661454560 | 0 | 0 | 3 | 257709408 | 5 | 41403745152 | |
/var/lib/mysql/#innodb_temp/temp_8.ibt | 8 | 41547211200 | 0 | 0 | 3 | 255730464 | 5 | 41291480736 | |
/var/lib/mysql/#innodb_temp/temp_6.ibt | 8 | 39424001232 | 0 | 0 | 3 | 251211840 | 5 | 39172789392 | |
/var/lib/mysql/#innodb_temp/temp_7.ibt | 8 | 37055802960 | 0 | 0 | 3 | 246054336 | 5 | 36809748624 | |
/var/lib/mysql/#innodb_temp/temp_3.ibt | 8 | 36693735408 | 0 | 0 | 3 | 248736048 | 5 | 36444999360 | |
/var/lib/mysql/#innodb_temp/temp_9.ibt | 8 | 34502119344 | 0 | 0 | 3 | 261815136 | 5 | 34240304208 | |
/var/lib/mysql/#innodb_temp/temp_2.ibt | 8 | 33369015504 | 0 | 0 | 3 | 240527760 | 5 | 33128487744 | |
/var/lib/mysql/#innodb_temp/temp_4.ibt | 8 | 32320282896 | 0 | 0 | 3 | 237306432 | 5 | 32082976464 | |
/var/lib/mysql/binlog.000007 | 308 | 18451561392 | 77 | 1285502064 | 1 | 5112096 | 230 | 17160947232 | |
/var/lib/mysql/binlog.index | 13 | 15289297056 | 3 | 13148256 | 0 | 0 | 10 | 15276148800 | |
/usr/share/mysql-8.0/italian/errmsg.sys | 5 | 8349766656 | 3 | 5847729360 | 0 | 0 | 2 | 2502037296 | |
/usr/share/mysql-8.0/dutch/errmsg.sys | 5 | 5451016032 | 3 | 2237566848 | 0 | 0 | 2 | 3213449184 | |
/usr/share/mysql-8.0/romanian/errmsg.sys | 5 | 4867793040 | 3 | 2536338288 | 0 | 0 | 2 | 2331454752 | |
/usr/share/mysql-8.0/spanish/errmsg.sys | 5 | 4063903008 | 3 | 2166619488 | 0 | 0 | 2 | 1897283520 |
|