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 | 304 | 2.67 s | 2 | 878.87 us | 182 | 155.79 ms | 120 | 2.51 s | |
@@datadir/mysql.ibd | 426 | 986.96 ms | 391 | 902.06 ms | 21 | 1.59 ms | 14 | 83.32 ms | |
@@datadir/ibdata1 | 60 | 425.26 ms | 20 | 8.18 ms | 18 | 13.16 ms | 22 | 403.92 ms | |
@@datadir/ibtmp1 | 147 | 248.52 ms | 0 | 0 ps | 143 | 19.10 ms | 4 | 229.42 ms | |
@@datadir/undo_002 | 495 | 189.57 ms | 382 | 51.18 ms | 100 | 4.84 ms | 13 | 133.55 ms | |
@@datadir/undo_001 | 511 | 177.78 ms | 388 | 61.20 ms | 110 | 4.44 ms | 13 | 112.14 ms | |
@@datadir/ib_logfile0 | 25 | 130.30 ms | 6 | 619.78 us | 8 | 1.06 ms | 11 | 128.62 ms | |
@@datadir/#innodb_temp/temp_7.ibt | 17 | 107.30 ms | 0 | 0 ps | 8 | 600.76 us | 9 | 106.70 ms | |
@@datadir/binlog.000008 | 10 | 85.66 ms | 0 | 0 ps | 4 | 2.51 ms | 6 | 83.15 ms | |
@@datadir/#innodb_temp/temp_8.ibt | 13 | 80.98 ms | 0 | 0 ps | 6 | 383.79 us | 7 | 80.60 ms | |
@@datadir/#innodb_temp/temp_10.ibt | 13 | 74.68 ms | 0 | 0 ps | 6 | 479.16 us | 7 | 74.21 ms | |
@@datadir/#innodb_temp/temp_9.ibt | 13 | 71.44 ms | 0 | 0 ps | 6 | 411.08 us | 7 | 71.03 ms | |
@@datadir/#innodb_temp/temp_2.ibt | 8 | 51.22 ms | 0 | 0 ps | 3 | 458.00 us | 5 | 50.76 ms | |
@@datadir/#innodb_temp/temp_3.ibt | 8 | 43.71 ms | 0 | 0 ps | 3 | 419.55 us | 5 | 43.29 ms | |
@@datadir/#innodb_temp/temp_1.ibt | 8 | 40.78 ms | 0 | 0 ps | 3 | 149.30 us | 5 | 40.63 ms | |
@@datadir/#innodb_temp/temp_5.ibt | 8 | 37.48 ms | 0 | 0 ps | 3 | 387.55 us | 5 | 37.10 ms | |
@@datadir/#innodb_temp/temp_6.ibt | 8 | 34.87 ms | 0 | 0 ps | 3 | 337.10 us | 5 | 34.53 ms | |
@@datadir/#innodb_temp/temp_4.ibt | 8 | 33.79 ms | 0 | 0 ps | 3 | 341.39 us | 5 | 33.45 ms | |
@@datadir/binlog.index | 13 | 23.10 ms | 3 | 31.35 us | 0 | 0 ps | 10 | 23.07 ms | |
@@datadir/sakila/payment.ibd | 55 | 18.29 ms | 50 | 18.24 ms | 0 | 0 ps | 5 | 50.19 us | |
@@datadir/binlog.000007 | 136 | 17.25 ms | 34 | 1.17 ms | 1 | 10.94 us | 101 | 16.07 ms | |
@@datadir/sakila/rental.ibd | 58 | 11.95 ms | 53 | 11.91 ms | 0 | 0 ps | 5 | 45.32 us | |
@@basedir/share/mysql-8.0/spanish/errmsg.sys | 5 | 7.16 ms | 3 | 2.77 ms | 0 | 0 ps | 2 | 4.39 ms | |
@@datadir/StdMdDB/course.ibd | 9 | 6.14 ms | 4 | 6.09 ms | 0 | 0 ps | 5 | 47.66 us | |
@@datadir/sakila/address.ibd | 14 | 5.27 ms | 9 | 5.24 ms | 0 | 0 ps | 5 | 31.12 us |
|