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 | 1040 | 6.17 s | 2 | 1.58 ms | 638 | 223.00 ms | 400 | 5.95 s | |
@@datadir/ibdata1 | 245 | 1.93 s | 20 | 6.13 ms | 114 | 10.41 ms | 111 | 1.91 s | |
@@datadir/ib_logfile0 | 111 | 787.61 ms | 6 | 1.58 ms | 51 | 2.75 ms | 54 | 783.28 ms | |
@@datadir/mysql.ibd | 854 | 661.22 ms | 419 | 81.00 ms | 375 | 7.48 ms | 60 | 572.74 ms | |
@@datadir/undo_002 | 751 | 563.09 ms | 384 | 26.68 ms | 324 | 6.45 ms | 43 | 529.95 ms | |
@@datadir/undo_001 | 766 | 549.15 ms | 388 | 70.06 ms | 335 | 9.83 ms | 43 | 469.26 ms | |
@@datadir/binlog.000008 | 56 | 423.72 ms | 0 | 0 ps | 27 | 998.20 us | 29 | 422.72 ms | |
@@datadir/ibtmp1 | 147 | 219.65 ms | 0 | 0 ps | 143 | 15.97 ms | 4 | 203.67 ms | |
@@datadir/#innodb_temp/temp_10.ibt | 35 | 214.88 ms | 0 | 0 ps | 21 | 848.58 us | 14 | 214.03 ms | |
@@datadir/test/Registration.ibd | 13 | 78.72 ms | 0 | 0 ps | 7 | 539.27 us | 6 | 78.19 ms | |
@@datadir/kaau/M.ibd | 15 | 56.82 ms | 0 | 0 ps | 8 | 336.64 us | 7 | 56.48 ms | |
@@datadir/#innodb_temp/temp_3.ibt | 8 | 52.60 ms | 0 | 0 ps | 3 | 101.89 us | 5 | 52.50 ms | |
@@datadir/#innodb_temp/temp_1.ibt | 8 | 44.09 ms | 0 | 0 ps | 3 | 258.61 us | 5 | 43.83 ms | |
@@datadir/#innodb_temp/temp_6.ibt | 8 | 32.85 ms | 0 | 0 ps | 3 | 78.71 us | 5 | 32.77 ms | |
@@datadir/#innodb_temp/temp_5.ibt | 8 | 30.70 ms | 0 | 0 ps | 3 | 64.14 us | 5 | 30.63 ms | |
@@datadir/#innodb_temp/temp_2.ibt | 8 | 30.43 ms | 0 | 0 ps | 3 | 210.15 us | 5 | 30.22 ms | |
@@datadir/#innodb_temp/temp_8.ibt | 8 | 28.16 ms | 0 | 0 ps | 3 | 85.72 us | 5 | 28.07 ms | |
@@datadir/#innodb_temp/temp_7.ibt | 8 | 27.67 ms | 0 | 0 ps | 3 | 94.16 us | 5 | 27.58 ms | |
@@datadir/#innodb_temp/temp_9.ibt | 8 | 27.37 ms | 0 | 0 ps | 3 | 83.75 us | 5 | 27.28 ms | |
@@datadir/#innodb_temp/temp_4.ibt | 8 | 26.53 ms | 0 | 0 ps | 3 | 66.93 us | 5 | 26.46 ms | |
@@datadir/binlog.index | 13 | 17.60 ms | 3 | 32.69 us | 0 | 0 ps | 10 | 17.56 ms | |
@@datadir/mysql/general_log.CSV | 36 | 15.63 ms | 15 | 60.50 us | 0 | 0 ps | 21 | 15.57 ms | |
@@basedir/share/mysql-8.0/polish/errmsg.sys | 5 | 7.20 ms | 3 | 3.59 ms | 0 | 0 ps | 2 | 3.62 ms | |
@@basedir/share/mysql-8.0/spanish/errmsg.sys | 5 | 6.38 ms | 3 | 3.46 ms | 0 | 0 ps | 2 | 2.91 ms | |
@@basedir/share/mysql-8.0/dutch/errmsg.sys | 5 | 5.97 ms | 3 | 3.53 ms | 0 | 0 ps | 2 | 2.44 ms |
|