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 | 2989 | 13.60 s | 2 | 721.60 us | 1998 | 569.60 ms | 989 | 13.03 s | |
@@datadir/ibdata1 | 290 | 2.14 s | 20 | 5.01 ms | 140 | 9.16 ms | 130 | 2.12 s | |
@@datadir/binlog.000008 | 260 | 1.72 s | 0 | 0 ps | 129 | 2.58 ms | 131 | 1.72 s | |
@@datadir/mysql.ibd | 892 | 894.96 ms | 354 | 97.65 ms | 465 | 25.10 ms | 73 | 772.21 ms | |
@@datadir/undo_001 | 1097 | 830.29 ms | 389 | 36.79 ms | 644 | 12.51 ms | 64 | 780.98 ms | |
@@datadir/undo_002 | 1064 | 613.56 ms | 385 | 27.75 ms | 620 | 7.72 ms | 59 | 578.09 ms | |
@@datadir/ib_logfile0 | 97 | 612.81 ms | 6 | 441.73 us | 44 | 1.27 ms | 47 | 611.10 ms | |
@@datadir/ibtmp1 | 147 | 198.11 ms | 0 | 0 ps | 143 | 12.94 ms | 4 | 185.17 ms | |
@@datadir/#innodb_temp/temp_10.ibt | 16 | 110.01 ms | 0 | 0 ps | 8 | 251.56 us | 8 | 109.76 ms | |
@@datadir/eduser/user.ibd | 13 | 72.75 ms | 0 | 0 ps | 7 | 175.62 us | 6 | 72.57 ms | |
@@datadir/binlog.000007 | 180 | 69.83 ms | 45 | 69.05 ms | 1 | 5.95 us | 134 | 775.06 us | |
@@datadir/root/root.ibd | 13 | 57.91 ms | 0 | 0 ps | 7 | 157.10 us | 6 | 57.76 ms | |
@@datadir/#innodb_temp/temp_1.ibt | 8 | 37.52 ms | 0 | 0 ps | 3 | 63.44 us | 5 | 37.46 ms | |
@@datadir/#innodb_temp/temp_4.ibt | 8 | 32.28 ms | 0 | 0 ps | 3 | 75.25 us | 5 | 32.21 ms | |
@@datadir/#innodb_temp/temp_7.ibt | 8 | 30.71 ms | 0 | 0 ps | 3 | 61.25 us | 5 | 30.65 ms | |
@@datadir/#innodb_temp/temp_6.ibt | 8 | 29.76 ms | 0 | 0 ps | 3 | 62.87 us | 5 | 29.69 ms | |
@@datadir/#innodb_temp/temp_8.ibt | 8 | 28.76 ms | 0 | 0 ps | 3 | 67.19 us | 5 | 28.70 ms | |
@@datadir/#innodb_temp/temp_5.ibt | 8 | 28.65 ms | 0 | 0 ps | 3 | 63.93 us | 5 | 28.58 ms | |
@@datadir/#innodb_temp/temp_2.ibt | 8 | 27.82 ms | 0 | 0 ps | 3 | 64.79 us | 5 | 27.76 ms | |
@@datadir/#innodb_temp/temp_9.ibt | 8 | 27.10 ms | 0 | 0 ps | 3 | 64.19 us | 5 | 27.03 ms | |
@@datadir/#innodb_temp/temp_3.ibt | 8 | 26.38 ms | 0 | 0 ps | 3 | 62.08 us | 5 | 26.32 ms | |
@@datadir/binlog.index | 13 | 25.00 ms | 3 | 29.85 us | 0 | 0 ps | 10 | 24.97 ms | |
@@basedir/share/mysql-8.0/russian/errmsg.sys | 5 | 4.08 ms | 3 | 2.11 ms | 0 | 0 ps | 2 | 1.97 ms | |
@@basedir/share/mysql-8.0/french/errmsg.sys | 5 | 2.71 ms | 3 | 2.13 ms | 0 | 0 ps | 2 | 580.17 us | |
@@basedir/share/mysql-8.0/spanish/errmsg.sys | 5 | 2.36 ms | 3 | 2.01 ms | 0 | 0 ps | 2 | 346.58 us |
|