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 | 101 | 681896186400 | 2 | 1028617392 | 58 | 17634529968 | 41 | 663233039040 | |
/var/lib/mysql/ibdata1 | 63 | 374680132464 | 20 | 7085197680 | 19 | 3347398032 | 24 | 364247536752 | |
/var/lib/mysql/ibtmp1 | 147 | 262206410928 | 0 | 0 | 143 | 12560899296 | 4 | 249645511632 | |
/var/lib/mysql/ib_logfile0 | 33 | 202772448912 | 6 | 882799632 | 12 | 628655280 | 15 | 201260994000 | |
/var/lib/mysql/mysql.ibd | 339 | 180383202912 | 304 | 95441944224 | 21 | 1160269968 | 14 | 83780988720 | |
/var/lib/mysql/undo_001 | 419 | 176100653520 | 387 | 70206961968 | 20 | 971306160 | 12 | 104922385392 | |
/var/lib/mysql/undo_002 | 409 | 117019854336 | 382 | 33580454688 | 16 | 1259388768 | 11 | 82180010880 | |
/var/lib/mysql/binlog.000008 | 10 | 60763558944 | 0 | 0 | 4 | 655906944 | 6 | 60107652000 | |
/var/lib/mysql/#innodb_temp/temp_8.ibt | 8 | 57288383856 | 0 | 0 | 3 | 134832720 | 5 | 57153551136 | |
/var/lib/mysql/#innodb_temp/temp_1.ibt | 8 | 43464716592 | 0 | 0 | 3 | 389328192 | 5 | 43075388400 | |
/var/lib/mysql/#innodb_temp/temp_3.ibt | 8 | 40111472544 | 0 | 0 | 3 | 349599360 | 5 | 39761873184 | |
/var/lib/mysql/#innodb_temp/temp_5.ibt | 8 | 39831900240 | 0 | 0 | 3 | 327644064 | 5 | 39504256176 | |
/var/lib/mysql/#innodb_temp/temp_2.ibt | 8 | 38867144976 | 0 | 0 | 3 | 343253856 | 5 | 38523891120 | |
/var/lib/mysql/#innodb_temp/temp_9.ibt | 8 | 37695043584 | 0 | 0 | 3 | 122531376 | 5 | 37572512208 | |
/var/lib/mysql/#innodb_temp/temp_4.ibt | 8 | 37383321360 | 0 | 0 | 3 | 322125408 | 5 | 37061195952 | |
/var/lib/mysql/#innodb_temp/temp_6.ibt | 8 | 34713276576 | 0 | 0 | 3 | 272863536 | 5 | 34440413040 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 8 | 33859174272 | 0 | 0 | 3 | 202801104 | 5 | 33656373168 | |
/var/lib/mysql/#innodb_temp/temp_7.ibt | 8 | 28324963392 | 0 | 0 | 3 | 152048160 | 5 | 28172915232 | |
/var/lib/mysql/binlog.index | 13 | 19329857712 | 3 | 29971920 | 0 | 0 | 10 | 19299885792 | |
/usr/share/mysql-8.0/ukrainian/errmsg.sys | 5 | 8319428832 | 3 | 2081749296 | 0 | 0 | 2 | 6237679536 | |
/usr/share/mysql-8.0/japanese/errmsg.sys | 5 | 7416843456 | 3 | 3331089168 | 0 | 0 | 2 | 4085754288 | |
/var/lib/mysql/sakila/address.ibd | 14 | 5479547040 | 9 | 5422393680 | 0 | 0 | 5 | 57153360 | |
/usr/share/mysql-8.0/german/errmsg.sys | 5 | 5144025216 | 3 | 3037265088 | 0 | 0 | 2 | 2106760128 | |
/usr/share/mysql-8.0/russian/errmsg.sys | 5 | 5033319456 | 3 | 3154557120 | 0 | 0 | 2 | 1878762336 | |
/usr/share/mysql-8.0/spanish/errmsg.sys | 5 | 3486590448 | 3 | 1932751392 | 0 | 0 | 2 | 1553839056 |
|