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 | 1577 | 6.91 s | 2 | 852.97 us | 1129 | 472.38 ms | 446 | 6.44 s | |
@@datadir/ibdata1 | 89 | 753.44 ms | 20 | 12.21 ms | 35 | 8.80 ms | 34 | 732.43 ms | |
@@datadir/binlog.000008 | 66 | 699.78 ms | 0 | 0 ps | 32 | 1.69 ms | 34 | 698.09 ms | |
@@datadir/mysql.ibd | 577 | 473.39 ms | 356 | 121.40 ms | 196 | 10.46 ms | 25 | 341.53 ms | |
@@datadir/undo_001 | 689 | 262.56 ms | 389 | 41.91 ms | 282 | 6.90 ms | 18 | 213.76 ms | |
@@datadir/undo_002 | 682 | 256.29 ms | 385 | 35.34 ms | 280 | 5.89 ms | 17 | 215.06 ms | |
@@datadir/ibtmp1 | 147 | 220.49 ms | 0 | 0 ps | 143 | 7.95 ms | 4 | 212.54 ms | |
@@datadir/#innodb_temp/temp_10.ibt | 19 | 141.13 ms | 0 | 0 ps | 10 | 492.50 us | 9 | 140.64 ms | |
@@datadir/ib_logfile0 | 23 | 115.63 ms | 6 | 550.36 us | 7 | 1.10 ms | 10 | 113.98 ms | |
@@datadir/#innodb_temp/temp_9.ibt | 16 | 88.94 ms | 0 | 0 ps | 8 | 407.66 us | 8 | 88.53 ms | |
@@datadir/#innodb_temp/temp_7.ibt | 8 | 46.82 ms | 0 | 0 ps | 3 | 97.12 us | 5 | 46.72 ms | |
@@datadir/#innodb_temp/temp_1.ibt | 8 | 36.25 ms | 0 | 0 ps | 3 | 63.86 us | 5 | 36.18 ms | |
@@datadir/#innodb_temp/temp_5.ibt | 8 | 34.72 ms | 0 | 0 ps | 3 | 59.56 us | 5 | 34.66 ms | |
@@datadir/#innodb_temp/temp_8.ibt | 8 | 28.39 ms | 0 | 0 ps | 3 | 112.90 us | 5 | 28.27 ms | |
@@datadir/#innodb_temp/temp_6.ibt | 8 | 28.24 ms | 0 | 0 ps | 3 | 82.51 us | 5 | 28.16 ms | |
@@datadir/#innodb_temp/temp_4.ibt | 8 | 27.74 ms | 0 | 0 ps | 3 | 59.25 us | 5 | 27.68 ms | |
@@datadir/#innodb_temp/temp_2.ibt | 8 | 27.47 ms | 0 | 0 ps | 3 | 54.75 us | 5 | 27.42 ms | |
@@datadir/#innodb_temp/temp_3.ibt | 8 | 27.47 ms | 0 | 0 ps | 3 | 63.65 us | 5 | 27.41 ms | |
@@datadir/binlog.index | 13 | 14.92 ms | 3 | 10.04 us | 0 | 0 ps | 10 | 14.91 ms | |
@@basedir/share/mysql-8.0/russian/errmsg.sys | 5 | 7.95 ms | 3 | 4.51 ms | 0 | 0 ps | 2 | 3.44 ms | |
@@basedir/share/mysql-8.0/japanese/errmsg.sys | 5 | 3.83 ms | 3 | 1.18 ms | 0 | 0 ps | 2 | 2.65 ms | |
@@basedir/share/mysql-8.0/portuguese/errmsg.sys | 5 | 3.38 ms | 3 | 939.76 us | 0 | 0 ps | 2 | 2.44 ms | |
@@datadir/binlog.000007 | 96 | 2.75 ms | 24 | 2.33 ms | 1 | 5.25 us | 71 | 411.99 us | |
@@datadir/auto.cnf | 5 | 1.50 ms | 3 | 1.49 ms | 0 | 0 ps | 2 | 15.28 us | |
@@basedir/share/mysql-8.0/french/errmsg.sys | 5 | 1.44 ms | 3 | 1.12 ms | 0 | 0 ps | 2 | 321.06 us |
|