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 | 895 | 4.90 s | 2 | 864.74 us | 531 | 187.22 ms | 362 | 4.71 s | |
@@datadir/ibdata1 | 315 | 2.49 s | 20 | 4.93 ms | 146 | 10.97 ms | 149 | 2.47 s | |
@@datadir/ib_logfile0 | 143 | 965.30 ms | 6 | 331.67 us | 67 | 2.46 ms | 70 | 962.51 ms | |
@@datadir/undo_002 | 775 | 600.90 ms | 384 | 21.95 ms | 331 | 6.36 ms | 60 | 572.59 ms | |
@@datadir/#innodb_temp/temp_10.ibt | 83 | 589.91 ms | 0 | 0 ps | 52 | 2.58 ms | 31 | 587.33 ms | |
@@datadir/undo_001 | 840 | 554.33 ms | 388 | 36.06 ms | 390 | 6.58 ms | 62 | 511.69 ms | |
@@datadir/mysql.ibd | 502 | 298.81 ms | 353 | 71.25 ms | 84 | 1.47 ms | 65 | 226.10 ms | |
@@datadir/ibtmp1 | 147 | 222.41 ms | 0 | 0 ps | 143 | 9.81 ms | 4 | 212.59 ms | |
@@datadir/#innodb_temp/temp_6.ibt | 8 | 37.42 ms | 0 | 0 ps | 3 | 106.27 us | 5 | 37.32 ms | |
@@datadir/#innodb_temp/temp_1.ibt | 8 | 34.19 ms | 0 | 0 ps | 3 | 92.75 us | 5 | 34.10 ms | |
@@datadir/#innodb_temp/temp_7.ibt | 8 | 29.78 ms | 0 | 0 ps | 3 | 87.20 us | 5 | 29.69 ms | |
@@datadir/#innodb_temp/temp_9.ibt | 8 | 29.72 ms | 0 | 0 ps | 3 | 93.31 us | 5 | 29.63 ms | |
@@datadir/#innodb_temp/temp_5.ibt | 8 | 28.92 ms | 0 | 0 ps | 3 | 78.67 us | 5 | 28.84 ms | |
@@datadir/#innodb_temp/temp_3.ibt | 8 | 28.09 ms | 0 | 0 ps | 3 | 80.53 us | 5 | 28.01 ms | |
@@datadir/#innodb_temp/temp_4.ibt | 8 | 26.98 ms | 0 | 0 ps | 3 | 73.45 us | 5 | 26.91 ms | |
@@datadir/binlog.000008 | 6 | 26.57 ms | 0 | 0 ps | 2 | 18.49 us | 4 | 26.56 ms | |
@@datadir/#innodb_temp/temp_2.ibt | 8 | 26.53 ms | 0 | 0 ps | 3 | 88.51 us | 5 | 26.44 ms | |
@@datadir/#innodb_temp/temp_8.ibt | 8 | 26.47 ms | 0 | 0 ps | 3 | 61.03 us | 5 | 26.41 ms | |
@@datadir/binlog.index | 13 | 15.20 ms | 3 | 13.24 us | 0 | 0 ps | 10 | 15.19 ms | |
@@datadir/sku/Interpreta.ibd | 10 | 12.33 ms | 5 | 12.28 ms | 0 | 0 ps | 5 | 46.63 us | |
@@datadir/vedettfak/fa.ibd | 17 | 12.15 ms | 12 | 12.10 ms | 0 | 0 ps | 5 | 49.77 us | |
@@datadir/mysql/slow_log.CSM | 4 | 6.95 ms | 1 | 4.72 ms | 0 | 0 ps | 3 | 2.23 ms | |
@@datadir/world/Country.MYI | 4 | 6.51 ms | 2 | 6.47 ms | 0 | 0 ps | 2 | 36.60 us | |
@@basedir/share/mysql-8.0/dutch/errmsg.sys | 5 | 6.33 ms | 3 | 3.20 ms | 0 | 0 ps | 2 | 3.12 ms | |
@@basedir/share/mysql-8.0/japanese/errmsg.sys | 5 | 5.74 ms | 3 | 2.83 ms | 0 | 0 ps | 2 | 2.91 ms |
|