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 | 280 | 1759526289312 | 2 | 1028617392 | 165 | 33472421136 | 113 | 1725025250784 | |
/var/lib/mysql/ibdata1 | 140 | 1057638805872 | 20 | 7085197680 | 58 | 6716032752 | 62 | 1043837575440 | |
/var/lib/mysql/ib_logfile0 | 69 | 471810108000 | 6 | 882799632 | 30 | 2805720192 | 33 | 468121588176 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 153 | 454617404736 | 0 | 0 | 128 | 8831301600 | 25 | 445786103136 | |
/var/lib/mysql/undo_002 | 530 | 294590728080 | 382 | 33580454688 | 125 | 3851706144 | 23 | 257158567248 | |
/var/lib/mysql/mysql.ibd | 466 | 291346823856 | 399 | 131148951120 | 40 | 1705398816 | 27 | 158492473920 | |
/var/lib/mysql/undo_001 | 564 | 288526691904 | 388 | 70565462352 | 154 | 3049815120 | 22 | 214911414432 | |
/var/lib/mysql/ibtmp1 | 147 | 262206410928 | 0 | 0 | 143 | 12560899296 | 4 | 249645511632 | |
/var/lib/mysql/binlog.000008 | 22 | 185700500832 | 0 | 0 | 10 | 2923593552 | 12 | 182776907280 | |
/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_7.ibt | 8 | 28324963392 | 0 | 0 | 3 | 152048160 | 5 | 28172915232 | |
/var/lib/mysql/binlog.index | 13 | 19329857712 | 3 | 29971920 | 0 | 0 | 10 | 19299885792 | |
/var/lib/mysql/sakila/payment.ibd | 55 | 11196771696 | 50 | 11160114240 | 0 | 0 | 5 | 36657456 | |
/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/customer.ibd | 15 | 5984319264 | 10 | 5953942896 | 0 | 0 | 5 | 30376368 | |
/usr/share/mysql-8.0/romanian/errmsg.sys | 5 | 5824384368 | 3 | 3118224384 | 0 | 0 | 2 | 2706159984 | |
/var/lib/mysql/sakila/address.ibd | 14 | 5479547040 | 9 | 5422393680 | 0 | 0 | 5 | 57153360 |
|