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 | 301 | 1.96 s | 2 | 915.17 us | 180 | 72.17 ms | 119 | 1.88 s | |
@@datadir/ibdata1 | 83 | 566.93 ms | 20 | 5.99 ms | 30 | 5.66 ms | 33 | 555.29 ms | |
@@datadir/ibtmp1 | 147 | 301.06 ms | 0 | 0 ps | 143 | 18.44 ms | 4 | 282.62 ms | |
@@datadir/undo_001 | 568 | 195.89 ms | 388 | 66.79 ms | 163 | 3.85 ms | 17 | 125.25 ms | |
@@datadir/undo_002 | 538 | 173.53 ms | 382 | 31.39 ms | 139 | 3.45 ms | 17 | 138.70 ms | |
@@datadir/ib_logfile0 | 35 | 168.07 ms | 6 | 830.28 us | 13 | 1.48 ms | 16 | 165.77 ms | |
@@datadir/mysql.ibd | 349 | 124.18 ms | 312 | 78.29 ms | 20 | 617.35 us | 17 | 45.28 ms | |
@@datadir/#innodb_temp/temp_10.ibt | 11 | 55.07 ms | 0 | 0 ps | 5 | 240.45 us | 6 | 54.83 ms | |
@@datadir/#innodb_temp/temp_2.ibt | 8 | 47.59 ms | 0 | 0 ps | 3 | 236.93 us | 5 | 47.36 ms | |
@@datadir/#innodb_temp/temp_1.ibt | 8 | 43.44 ms | 0 | 0 ps | 3 | 249.18 us | 5 | 43.19 ms | |
@@datadir/binlog.000008 | 6 | 38.07 ms | 0 | 0 ps | 2 | 64.88 us | 4 | 38.01 ms | |
@@datadir/#innodb_temp/temp_7.ibt | 8 | 37.01 ms | 0 | 0 ps | 3 | 261.06 us | 5 | 36.74 ms | |
@@datadir/#innodb_temp/temp_3.ibt | 8 | 36.95 ms | 0 | 0 ps | 3 | 285.17 us | 5 | 36.67 ms | |
@@datadir/#innodb_temp/temp_4.ibt | 8 | 36.21 ms | 0 | 0 ps | 3 | 252.58 us | 5 | 35.95 ms | |
@@datadir/#innodb_temp/temp_5.ibt | 8 | 33.37 ms | 0 | 0 ps | 3 | 276.73 us | 5 | 33.09 ms | |
@@datadir/#innodb_temp/temp_6.ibt | 8 | 32.38 ms | 0 | 0 ps | 3 | 232.51 us | 5 | 32.14 ms | |
@@datadir/#innodb_temp/temp_8.ibt | 8 | 31.22 ms | 0 | 0 ps | 3 | 156.71 us | 5 | 31.06 ms | |
@@datadir/#innodb_temp/temp_9.ibt | 8 | 28.80 ms | 0 | 0 ps | 3 | 83.61 us | 5 | 28.72 ms | |
@@datadir/binlog.index | 13 | 21.45 ms | 3 | 418.44 us | 0 | 0 ps | 10 | 21.03 ms | |
@@datadir/StdMdDB/score.ibd | 9 | 19.70 ms | 4 | 737.30 us | 0 | 0 ps | 5 | 18.97 ms | |
@@datadir/sakila/language.ibd | 9 | 9.05 ms | 4 | 8.87 ms | 0 | 0 ps | 5 | 182.39 us | |
@@basedir/share/mysql-8.0/french/errmsg.sys | 5 | 6.61 ms | 3 | 3.11 ms | 0 | 0 ps | 2 | 3.50 ms | |
@@basedir/share/mysql-8.0/german/errmsg.sys | 5 | 4.89 ms | 3 | 2.35 ms | 0 | 0 ps | 2 | 2.54 ms | |
@@datadir/sakila/film_actor.ibd | 22 | 4.22 ms | 17 | 4.16 ms | 0 | 0 ps | 5 | 56.22 us | |
@@datadir/sakila/inventory.ibd | 21 | 4.16 ms | 16 | 4.13 ms | 0 | 0 ps | 5 | 31.92 us |
|