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 | 718 | 4990508260848 | 2 | 738723216 | 424 | 114100446768 | 292 | 4875669090864 | |
/var/lib/mysql/ibdata1 | 251 | 1855496142192 | 20 | 5511731280 | 115 | 12891140064 | 116 | 1837093270848 | |
/var/lib/mysql/ib_logfile0 | 109 | 755093774160 | 6 | 550321728 | 50 | 3907260192 | 53 | 750636192240 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 175 | 722347745328 | 0 | 0 | 142 | 49500628320 | 33 | 672847117008 | |
/var/lib/mysql/undo_001 | 808 | 512293849056 | 388 | 59232101280 | 372 | 11440436832 | 48 | 441621310944 | |
/var/lib/mysql/undo_002 | 692 | 506680272384 | 384 | 60641321664 | 264 | 10828387152 | 44 | 435210563568 | |
/var/lib/mysql/mysql.ibd | 586 | 445267309344 | 421 | 153640697760 | 109 | 2768807712 | 56 | 288857803872 | |
/var/lib/mysql/ibtmp1 | 147 | 288108040176 | 0 | 0 | 143 | 9073866912 | 4 | 279034173264 | |
/var/lib/mysql/#innodb_temp/temp_9.ibt | 103 | 206806970304 | 0 | 0 | 95 | 102608760144 | 8 | 104198210160 | |
/var/lib/mysql/binlog.000008 | 12 | 115599557040 | 0 | 0 | 5 | 5383810608 | 7 | 110215746432 | |
/var/lib/mysql/#innodb_temp/temp_4.ibt | 8 | 91838733360 | 0 | 0 | 3 | 70225056 | 5 | 91768508304 | |
/var/lib/mysql/employeedb/employee.ibd | 13 | 65338601328 | 0 | 0 | 7 | 451540848 | 6 | 64887060480 | |
/var/lib/mysql/#innodb_temp/temp_1.ibt | 8 | 62679061104 | 0 | 0 | 3 | 63759696 | 5 | 62615301408 | |
/var/lib/mysql/#innodb_temp/temp_3.ibt | 8 | 60241452480 | 0 | 0 | 3 | 77289168 | 5 | 60164163312 | |
/var/lib/mysql/#innodb_temp/temp_5.ibt | 8 | 57719594064 | 0 | 0 | 3 | 78174624 | 5 | 57641419440 | |
/var/lib/mysql/#innodb_temp/temp_7.ibt | 8 | 54475520880 | 0 | 0 | 3 | 61835136 | 5 | 54413685744 | |
/var/lib/mysql/#innodb_temp/temp_8.ibt | 8 | 53791086624 | 0 | 0 | 3 | 71335440 | 5 | 53719751184 | |
/var/lib/mysql/#innodb_temp/temp_6.ibt | 8 | 51914561424 | 0 | 0 | 3 | 62548992 | 5 | 51852012432 | |
/var/lib/mysql/#innodb_temp/temp_2.ibt | 8 | 47062152720 | 0 | 0 | 3 | 63336768 | 5 | 46998815952 | |
/var/lib/mysql/binlog.index | 13 | 44655344976 | 3 | 11849376 | 0 | 0 | 10 | 44643495600 | |
/var/lib/mysql/binlog.000007 | 232 | 9365759040 | 58 | 5549988048 | 1 | 4749888 | 173 | 3811021104 | |
/var/lib/mysql/sakila/payment.ibd | 53 | 8070738192 | 48 | 8039838048 | 0 | 0 | 5 | 30900144 | |
/var/lib/mysql/sakila/rental.ibd | 56 | 7852796688 | 51 | 7819823088 | 0 | 0 | 5 | 32973600 | |
/var/lib/mysql/pw/experiencia.ibd | 9 | 7687927632 | 4 | 7648312848 | 0 | 0 | 5 | 39614784 | |
/var/lib/mysql/pw/credenciales.ibd | 9 | 7212438288 | 4 | 7111076016 | 0 | 0 | 5 | 101362272 |
|