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 | 510 | 2.76 s | 2 | 853.93 us | 309 | 123.30 ms | 199 | 2.64 s | |
@@datadir/ibdata1 | 147 | 956.75 ms | 20 | 10.38 ms | 62 | 5.38 ms | 65 | 940.98 ms | |
@@datadir/undo_002 | 686 | 421.94 ms | 384 | 48.05 ms | 269 | 5.56 ms | 33 | 368.33 ms | |
@@datadir/ib_logfile0 | 55 | 338.93 ms | 6 | 694.06 us | 23 | 2.14 ms | 26 | 336.10 ms | |
@@datadir/undo_001 | 617 | 277.71 ms | 388 | 60.89 ms | 204 | 3.44 ms | 25 | 213.38 ms | |
@@datadir/ibtmp1 | 147 | 247.12 ms | 0 | 0 ps | 143 | 22.45 ms | 4 | 224.67 ms | |
@@datadir/mysql.ibd | 424 | 224.54 ms | 361 | 102.51 ms | 34 | 463.78 us | 29 | 121.56 ms | |
@@datadir/#innodb_temp/temp_10.ibt | 193 | 100.39 ms | 0 | 0 ps | 185 | 1.82 ms | 8 | 98.58 ms | |
@@datadir/sakila/city.ibd | 12 | 66.86 ms | 7 | 65.42 ms | 0 | 0 ps | 5 | 1.44 ms | |
@@datadir/#innodb_temp/temp_1.ibt | 8 | 56.46 ms | 0 | 0 ps | 3 | 310.36 us | 5 | 56.15 ms | |
@@datadir/#innodb_temp/temp_4.ibt | 8 | 39.06 ms | 0 | 0 ps | 3 | 341.29 us | 5 | 38.71 ms | |
@@datadir/#innodb_temp/temp_8.ibt | 8 | 38.26 ms | 0 | 0 ps | 3 | 478.07 us | 5 | 37.78 ms | |
@@datadir/#innodb_temp/temp_6.ibt | 8 | 38.22 ms | 0 | 0 ps | 3 | 360.44 us | 5 | 37.86 ms | |
@@datadir/#innodb_temp/temp_9.ibt | 8 | 37.55 ms | 0 | 0 ps | 3 | 331.15 us | 5 | 37.22 ms | |
@@datadir/#innodb_temp/temp_5.ibt | 8 | 37.21 ms | 0 | 0 ps | 3 | 287.11 us | 5 | 36.93 ms | |
@@datadir/binlog.000008 | 6 | 37.11 ms | 0 | 0 ps | 2 | 40.05 us | 4 | 37.07 ms | |
@@datadir/#innodb_temp/temp_3.ibt | 8 | 35.04 ms | 0 | 0 ps | 3 | 258.99 us | 5 | 34.78 ms | |
@@datadir/#innodb_temp/temp_7.ibt | 8 | 33.77 ms | 0 | 0 ps | 3 | 391.70 us | 5 | 33.38 ms | |
@@datadir/#innodb_temp/temp_2.ibt | 8 | 33.59 ms | 0 | 0 ps | 3 | 252.75 us | 5 | 33.34 ms | |
@@datadir/binlog.index | 13 | 18.91 ms | 3 | 38.85 us | 0 | 0 ps | 10 | 18.87 ms | |
@@datadir/sakila/rental.ibd | 58 | 16.94 ms | 53 | 16.90 ms | 0 | 0 ps | 5 | 39.42 us | |
@@datadir/binlog.000007 | 124 | 6.19 ms | 31 | 3.64 ms | 1 | 15.18 us | 92 | 2.54 ms | |
@@basedir/share/mysql-8.0/polish/errmsg.sys | 5 | 4.47 ms | 3 | 2.98 ms | 0 | 0 ps | 2 | 1.49 ms | |
@@datadir/vedettfak/megye.ibd | 9 | 4.34 ms | 4 | 2.43 ms | 0 | 0 ps | 5 | 1.92 ms | |
@@basedir/share/mysql-8.0/french/errmsg.sys | 5 | 4.30 ms | 3 | 2.11 ms | 0 | 0 ps | 2 | 2.19 ms |
|