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 | 1569 | 8.31 s | 2 | 856.71 us | 988 | 403.12 ms | 579 | 7.91 s | |
@@datadir/binlog.000008 | 262 | 1.85 s | 0 | 0 ps | 130 | 4.32 ms | 132 | 1.84 s | |
@@datadir/ibdata1 | 203 | 1.57 s | 20 | 7.20 ms | 94 | 14.18 ms | 89 | 1.55 s | |
@@datadir/mysql.ibd | 597 | 1.37 s | 378 | 82.68 ms | 168 | 7.68 ms | 51 | 1.28 s | |
@@datadir/undo_001 | 862 | 675.69 ms | 388 | 67.71 ms | 421 | 26.36 ms | 53 | 581.61 ms | |
@@datadir/undo_002 | 849 | 597.80 ms | 384 | 32.48 ms | 417 | 25.98 ms | 48 | 539.35 ms | |
@@datadir/ib_logfile0 | 67 | 433.00 ms | 6 | 640.83 us | 29 | 2.90 ms | 32 | 429.46 ms | |
@@datadir/ibtmp1 | 147 | 232.71 ms | 0 | 0 ps | 143 | 11.41 ms | 4 | 221.30 ms | |
@@datadir/HospitalDB/nurse.ibd | 24 | 160.93 ms | 0 | 0 ps | 14 | 700.31 us | 10 | 160.23 ms | |
@@datadir/#innodb_temp/temp_10.ibt | 23 | 139.94 ms | 0 | 0 ps | 14 | 771.95 us | 9 | 139.16 ms | |
@@datadir/HospitalDB/consists_of.ibd | 16 | 124.13 ms | 0 | 0 ps | 8 | 667.32 us | 8 | 123.47 ms | |
@@datadir/HospitalDB/patient.ibd | 17 | 117.79 ms | 0 | 0 ps | 9 | 420.79 us | 8 | 117.37 ms | |
@@datadir/HospitalDB/specialist.ibd | 14 | 105.97 ms | 0 | 0 ps | 7 | 283.50 us | 7 | 105.69 ms | |
@@datadir/HospitalDB/treatment.ibd | 15 | 92.14 ms | 0 | 0 ps | 8 | 488.41 us | 7 | 91.66 ms | |
@@datadir/HospitalDB/prescription.ibd | 17 | 89.13 ms | 0 | 0 ps | 9 | 1.02 ms | 8 | 88.11 ms | |
@@datadir/HospitalDB/supervises.ibd | 15 | 88.16 ms | 0 | 0 ps | 8 | 6.00 ms | 7 | 82.16 ms | |
@@datadir/HospitalDB/team.ibd | 15 | 84.95 ms | 0 | 0 ps | 8 | 549.92 us | 7 | 84.40 ms | |
@@datadir/HospitalDB/drug.ibd | 13 | 77.42 ms | 0 | 0 ps | 7 | 914.54 us | 6 | 76.50 ms | |
@@datadir/HospitalDB/small_ward.ibd | 13 | 71.40 ms | 0 | 0 ps | 7 | 352.15 us | 6 | 71.04 ms | |
@@datadir/HospitalDB/ward.ibd | 15 | 70.10 ms | 0 | 0 ps | 8 | 245.99 us | 7 | 69.86 ms | |
@@datadir/HospitalDB/small_occupied_by.ibd | 13 | 69.59 ms | 0 | 0 ps | 7 | 493.28 us | 6 | 69.09 ms | |
@@datadir/HospitalDB/doctor.ibd | 14 | 68.87 ms | 0 | 0 ps | 7 | 192.63 us | 7 | 68.68 ms | |
@@datadir/#innodb_temp/temp_1.ibt | 8 | 49.49 ms | 0 | 0 ps | 3 | 253.90 us | 5 | 49.24 ms | |
@@datadir/#innodb_temp/temp_8.ibt | 8 | 37.82 ms | 0 | 0 ps | 3 | 249.66 us | 5 | 37.57 ms | |
@@datadir/#innodb_temp/temp_9.ibt | 8 | 36.68 ms | 0 | 0 ps | 3 | 274.93 us | 5 | 36.40 ms |
|