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 | 1936 | 9516836984160 | 2 | 854109696 | 1331 | 674074960944 | 603 | 8841907913520 | |
/var/lib/mysql/ibdata1 | 179 | 1298614141968 | 20 | 7765280160 | 81 | 11699446704 | 78 | 1279149415104 | |
/var/lib/mysql/mysql.ibd | 691 | 542357202816 | 421 | 120969962256 | 229 | 9508108896 | 41 | 411879131664 | |
/var/lib/mysql/undo_002 | 901 | 504019854096 | 385 | 24569545968 | 480 | 15609655776 | 36 | 463840652352 | |
/var/lib/mysql/binlog.000008 | 66 | 501671111568 | 0 | 0 | 32 | 1227631680 | 34 | 500443479888 | |
/var/lib/mysql/undo_001 | 972 | 469961885184 | 389 | 44071497888 | 543 | 18529830000 | 40 | 407360557296 | |
/var/lib/mysql/ib_logfile0 | 65 | 428515002960 | 6 | 498700752 | 28 | 2620324080 | 31 | 425395978128 | |
/var/lib/mysql/ibtmp1 | 147 | 239327642400 | 0 | 0 | 143 | 8029497168 | 4 | 231298145232 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 32 | 229446612384 | 0 | 0 | 19 | 985440192 | 13 | 228461172192 | |
/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 | 184 | 17795283264 | 46 | 1197042528 | 1 | 5112096 | 137 | 16593128640 | |
/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 | |
/usr/share/mysql-8.0/german/errmsg.sys | 5 | 3851704032 | 3 | 848180256 | 0 | 0 | 2 | 3003523776 |
|