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 | 136 | 786.17 ms | 2 | 821.36 us | 80 | 64.66 ms | 54 | 720.69 ms | |
@@datadir/ibdata1 | 65 | 348.54 ms | 20 | 11.23 ms | 20 | 1.17 ms | 25 | 336.14 ms | |
@@datadir/ibtmp1 | 147 | 268.96 ms | 0 | 0 ps | 143 | 23.15 ms | 4 | 245.81 ms | |
@@datadir/undo_001 | 437 | 158.32 ms | 387 | 81.23 ms | 37 | 901.95 us | 13 | 76.19 ms | |
@@datadir/ib_logfile0 | 27 | 122.63 ms | 6 | 808.55 us | 9 | 416.56 us | 12 | 121.41 ms | |
@@datadir/undo_002 | 427 | 116.43 ms | 382 | 36.41 ms | 31 | 597.14 us | 14 | 79.42 ms | |
@@datadir/mysql.ibd | 346 | 112.98 ms | 314 | 67.35 ms | 18 | 311.03 us | 14 | 45.31 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_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_10.ibt | 8 | 34.19 ms | 0 | 0 ps | 3 | 300.88 us | 5 | 33.89 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/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 | |
@@datadir/sakila/film_actor.ibd | 20 | 2.00 ms | 15 | 1.98 ms | 0 | 0 ps | 5 | 20.56 us |
|