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 | 135 | 1.41 s | 2 | 865.35 us | 77 | 7.47 ms | 56 | 1.40 s | |
@@datadir/ibtmp1 | 147 | 223.24 ms | 0 | 0 ps | 143 | 12.00 ms | 4 | 211.23 ms | |
@@datadir/ibdata1 | 41 | 173.60 ms | 20 | 12.32 ms | 8 | 570.92 us | 13 | 160.71 ms | |
@@datadir/mysql.ibd | 372 | 111.68 ms | 353 | 87.87 ms | 10 | 217.63 us | 9 | 23.60 ms | |
@@datadir/undo_001 | 420 | 107.55 ms | 387 | 68.30 ms | 24 | 829.87 us | 9 | 38.43 ms | |
@@datadir/undo_002 | 409 | 106.11 ms | 382 | 52.71 ms | 18 | 1.27 ms | 9 | 52.14 ms | |
@@datadir/ib_logfile0 | 19 | 86.48 ms | 6 | 748.92 us | 5 | 628.16 us | 8 | 85.10 ms | |
@@datadir/#innodb_temp/temp_10.ibt | 11 | 72.39 ms | 0 | 0 ps | 5 | 412.04 us | 6 | 71.98 ms | |
@@datadir/binlog.000008 | 6 | 49.72 ms | 0 | 0 ps | 2 | 45.51 us | 4 | 49.67 ms | |
@@datadir/#innodb_temp/temp_1.ibt | 8 | 42.03 ms | 0 | 0 ps | 3 | 325.55 us | 5 | 41.70 ms | |
@@datadir/#innodb_temp/temp_9.ibt | 8 | 39.14 ms | 0 | 0 ps | 3 | 235.54 us | 5 | 38.91 ms | |
@@datadir/#innodb_temp/temp_5.ibt | 8 | 36.32 ms | 0 | 0 ps | 3 | 239.34 us | 5 | 36.08 ms | |
@@datadir/#innodb_temp/temp_2.ibt | 8 | 36.22 ms | 0 | 0 ps | 3 | 257.79 us | 5 | 35.96 ms | |
@@datadir/#innodb_temp/temp_4.ibt | 8 | 32.83 ms | 0 | 0 ps | 3 | 171.38 us | 5 | 32.66 ms | |
@@datadir/#innodb_temp/temp_6.ibt | 8 | 30.13 ms | 0 | 0 ps | 3 | 200.00 us | 5 | 29.93 ms | |
@@datadir/#innodb_temp/temp_3.ibt | 8 | 29.58 ms | 0 | 0 ps | 3 | 119.34 us | 5 | 29.46 ms | |
@@datadir/#innodb_temp/temp_7.ibt | 8 | 28.44 ms | 0 | 0 ps | 3 | 124.49 us | 5 | 28.32 ms | |
@@datadir/#innodb_temp/temp_8.ibt | 8 | 28.27 ms | 0 | 0 ps | 3 | 99.98 us | 5 | 28.17 ms | |
@@datadir/binlog.index | 13 | 18.39 ms | 3 | 28.79 us | 0 | 0 ps | 10 | 18.36 ms | |
@@datadir/sys/sys_config.ibd | 9 | 6.44 ms | 4 | 1.55 ms | 0 | 0 ps | 5 | 4.90 ms | |
@@datadir/binlog.000007 | 48 | 4.11 ms | 12 | 3.69 ms | 1 | 12.53 us | 35 | 401.86 us | |
@@basedir/share/mysql-8.0/french/errmsg.sys | 5 | 2.70 ms | 3 | 1.58 ms | 0 | 0 ps | 2 | 1.13 ms | |
@@basedir/share/mysql-8.0/spanish/errmsg.sys | 5 | 2.48 ms | 3 | 1.79 ms | 0 | 0 ps | 2 | 686.61 us | |
@@datadir/auto.cnf | 5 | 1.72 ms | 3 | 1.71 ms | 0 | 0 ps | 2 | 16.50 us | |
@@basedir/share/mysql-8.0/english/errmsg.sys | 5 | 1.31 ms | 3 | 1.08 ms | 0 | 0 ps | 2 | 229.41 us |
|