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 | 232 | 1.33 s | 2 | 821.36 us | 138 | 73.82 ms | 92 | 1.26 s | |
@@datadir/ibdata1 | 87 | 523.75 ms | 20 | 11.23 ms | 31 | 1.87 ms | 36 | 510.65 ms | |
@@datadir/ibtmp1 | 147 | 268.96 ms | 0 | 0 ps | 143 | 23.15 ms | 4 | 245.81 ms | |
@@datadir/undo_001 | 474 | 232.96 ms | 387 | 81.23 ms | 68 | 1.67 ms | 19 | 150.06 ms | |
@@datadir/ib_logfile0 | 35 | 190.60 ms | 6 | 808.55 us | 13 | 648.32 us | 16 | 189.15 ms | |
@@datadir/undo_002 | 462 | 177.87 ms | 382 | 36.41 ms | 61 | 1.30 ms | 19 | 140.16 ms | |
@@datadir/mysql.ibd | 390 | 163.08 ms | 345 | 85.44 ms | 25 | 407.48 us | 20 | 77.23 ms | |
@@datadir/#innodb_temp/temp_1.ibt | 8 | 55.36 ms | 0 | 0 ps | 3 | 300.34 us | 5 | 55.06 ms | |
@@datadir/#innodb_temp/temp_10.ibt | 11 | 47.78 ms | 0 | 0 ps | 5 | 391.35 us | 6 | 47.38 ms | |
@@datadir/#innodb_temp/temp_4.ibt | 8 | 45.58 ms | 0 | 0 ps | 3 | 148.52 us | 5 | 45.43 ms | |
@@datadir/#innodb_temp/temp_5.ibt | 8 | 42.69 ms | 0 | 0 ps | 3 | 364.77 us | 5 | 42.32 ms | |
@@datadir/#innodb_temp/temp_9.ibt | 8 | 34.73 ms | 0 | 0 ps | 3 | 447.37 us | 5 | 34.29 ms | |
@@datadir/#innodb_temp/temp_6.ibt | 8 | 34.29 ms | 0 | 0 ps | 3 | 354.46 us | 5 | 33.94 ms | |
@@datadir/#innodb_temp/temp_7.ibt | 8 | 33.29 ms | 0 | 0 ps | 3 | 357.17 us | 5 | 32.93 ms | |
@@datadir/#innodb_temp/temp_8.ibt | 8 | 33.12 ms | 0 | 0 ps | 3 | 425.58 us | 5 | 32.69 ms | |
@@datadir/#innodb_temp/temp_2.ibt | 8 | 32.70 ms | 0 | 0 ps | 3 | 173.10 us | 5 | 32.53 ms | |
@@datadir/binlog.000008 | 6 | 31.42 ms | 0 | 0 ps | 2 | 33.59 us | 4 | 31.39 ms | |
@@datadir/#innodb_temp/temp_3.ibt | 8 | 28.74 ms | 0 | 0 ps | 3 | 76.02 us | 5 | 28.67 ms | |
@@datadir/binlog.index | 13 | 21.14 ms | 3 | 27.40 us | 0 | 0 ps | 10 | 21.11 ms | |
@@datadir/sakila/film.ibd | 21 | 6.39 ms | 16 | 6.35 ms | 0 | 0 ps | 5 | 37.81 us | |
@@basedir/share/mysql-8.0/spanish/errmsg.sys | 5 | 6.13 ms | 3 | 2.34 ms | 0 | 0 ps | 2 | 3.78 ms | |
@@basedir/share/mysql-8.0/russian/errmsg.sys | 5 | 5.45 ms | 3 | 3.31 ms | 0 | 0 ps | 2 | 2.14 ms | |
@@basedir/share/mysql-8.0/german/errmsg.sys | 5 | 5.25 ms | 3 | 2.92 ms | 0 | 0 ps | 2 | 2.33 ms | |
@@datadir/sakila/address.ibd | 14 | 4.39 ms | 9 | 4.35 ms | 0 | 0 ps | 5 | 42.56 us | |
@@basedir/share/mysql-8.0/romanian/errmsg.sys | 5 | 4.20 ms | 3 | 2.10 ms | 0 | 0 ps | 2 | 2.10 ms |
|