SELECT * FROM `io_global_by_file_by_latency`
|
file | total | total_latency | count_read | read_latency | count_write | write_latency | count_misc | misc_latency | |
---|---|---|---|---|---|---|---|---|---|
@@datadir/ib_logfile1 | 3377 | 17.90 s | 2 | 806.60 us | 2171 | 763.35 ms | 1204 | 17.14 s | |
@@datadir/ibdata1 | 506 | 3.95 s | 20 | 10.54 ms | 250 | 26.72 ms | 236 | 3.91 s | |
@@datadir/binlog.000008 | 348 | 2.48 s | 0 | 0 ps | 173 | 11.28 ms | 175 | 2.47 s | |
@@datadir/mysql.ibd | 1159 | 1.48 s | 436 | 108.48 ms | 597 | 25.10 ms | 126 | 1.34 s | |
@@datadir/ib_logfile0 | 191 | 1.31 s | 6 | 463.13 us | 91 | 4.57 ms | 94 | 1.30 s | |
@@datadir/undo_002 | 1244 | 1.12 s | 385 | 31.92 ms | 749 | 55.31 ms | 110 | 1.03 s | |
@@datadir/undo_001 | 1228 | 992.78 ms | 390 | 77.71 ms | 735 | 37.62 ms | 103 | 877.45 ms | |
@@datadir/ibtmp1 | 147 | 308.26 ms | 0 | 0 ps | 143 | 14.73 ms | 4 | 293.53 ms | |
@@datadir/#innodb_temp/temp_10.ibt | 38 | 244.16 ms | 0 | 0 ps | 25 | 1.32 ms | 13 | 242.84 ms | |
@@datadir/HospitalDB/prescription.ibd | 17 | 138.86 ms | 0 | 0 ps | 9 | 360.60 us | 8 | 138.50 ms | |
@@datadir/HospitalDB/patient.ibd | 21 | 132.01 ms | 0 | 0 ps | 11 | 442.11 us | 10 | 131.57 ms | |
@@datadir/BD2/pedidos.ibd | 22 | 121.27 ms | 0 | 0 ps | 10 | 357.31 us | 12 | 120.91 ms | |
@@datadir/BD2/vendedor.ibd | 23 | 120.69 ms | 0 | 0 ps | 11 | 512.73 us | 12 | 120.18 ms | |
@@datadir/BD2/producto.ibd | 17 | 110.60 ms | 0 | 0 ps | 8 | 565.86 us | 9 | 110.04 ms | |
@@datadir/HospitalDB/specialist.ibd | 17 | 99.62 ms | 0 | 0 ps | 9 | 157.07 us | 8 | 99.46 ms | |
@@datadir/BD2/oficina.ibd | 17 | 91.35 ms | 0 | 0 ps | 8 | 566.14 us | 9 | 90.78 ms | |
@@datadir/zoo/responsabili.ibd | 17 | 91.26 ms | 0 | 0 ps | 10 | 441.78 us | 7 | 90.82 ms | |
@@datadir/HospitalDB/supervises.ibd | 15 | 89.89 ms | 0 | 0 ps | 8 | 413.47 us | 7 | 89.48 ms | |
@@datadir/zoo/animali.ibd | 15 | 87.04 ms | 0 | 0 ps | 8 | 380.91 us | 7 | 86.66 ms | |
@@datadir/BD2/cliente.ibd | 17 | 86.18 ms | 0 | 0 ps | 8 | 341.02 us | 9 | 85.83 ms | |
@@datadir/HospitalDB/consists_of.ibd | 15 | 84.52 ms | 0 | 0 ps | 8 | 190.44 us | 7 | 84.33 ms | |
@@datadir/HospitalDB/treatment.ibd | 15 | 83.37 ms | 0 | 0 ps | 8 | 249.91 us | 7 | 83.12 ms | |
@@datadir/HospitalDB/team.ibd | 15 | 79.14 ms | 0 | 0 ps | 8 | 339.88 us | 7 | 78.80 ms | |
@@datadir/HospitalDB/ward.ibd | 15 | 77.16 ms | 0 | 0 ps | 8 | 374.59 us | 7 | 76.78 ms | |
@@datadir/HospitalDB/nurse.ibd | 18 | 76.86 ms | 0 | 0 ps | 10 | 494.23 us | 8 | 76.36 ms |
|