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 | 588 | 3.21 s | 2 | 897.49 us | 353 | 65.14 ms | 233 | 3.14 s | |
@@datadir/ibdata1 | 135 | 919.42 ms | 20 | 5.82 ms | 57 | 8.66 ms | 58 | 904.95 ms | |
@@datadir/undo_001 | 686 | 440.99 ms | 388 | 51.94 ms | 269 | 5.50 ms | 29 | 383.54 ms | |
@@datadir/mysql.ibd | 517 | 343.89 ms | 404 | 89.74 ms | 80 | 1.30 ms | 33 | 252.85 ms | |
@@datadir/undo_002 | 720 | 343.88 ms | 384 | 36.82 ms | 310 | 7.31 ms | 26 | 299.75 ms | |
@@datadir/ib_logfile0 | 57 | 335.57 ms | 6 | 449.34 us | 24 | 1.82 ms | 27 | 333.30 ms | |
@@datadir/ibtmp1 | 147 | 262.96 ms | 0 | 0 ps | 143 | 19.45 ms | 4 | 243.51 ms | |
@@datadir/#innodb_temp/temp_10.ibt | 32 | 194.58 ms | 0 | 0 ps | 19 | 1.11 ms | 13 | 193.46 ms | |
@@datadir/binlog.000008 | 24 | 136.39 ms | 1 | 278.17 us | 9 | 3.29 ms | 14 | 132.81 ms | |
@@datadir/gendre_film/gendre.ibd | 13 | 63.88 ms | 0 | 0 ps | 7 | 158.38 us | 6 | 63.72 ms | |
@@datadir/sakila/customer.ibd | 14 | 56.00 ms | 9 | 55.93 ms | 0 | 0 ps | 5 | 76.14 us | |
@@datadir/#innodb_temp/temp_1.ibt | 8 | 52.49 ms | 0 | 0 ps | 3 | 216.16 us | 5 | 52.27 ms | |
@@datadir/#innodb_temp/temp_4.ibt | 8 | 52.29 ms | 0 | 0 ps | 3 | 231.80 us | 5 | 52.06 ms | |
@@datadir/#innodb_temp/temp_5.ibt | 8 | 47.26 ms | 0 | 0 ps | 3 | 284.69 us | 5 | 46.97 ms | |
@@datadir/#innodb_temp/temp_9.ibt | 8 | 36.34 ms | 0 | 0 ps | 3 | 226.86 us | 5 | 36.11 ms | |
@@datadir/#innodb_temp/temp_6.ibt | 8 | 35.66 ms | 0 | 0 ps | 3 | 215.56 us | 5 | 35.45 ms | |
@@datadir/#innodb_temp/temp_7.ibt | 8 | 33.37 ms | 0 | 0 ps | 3 | 222.99 us | 5 | 33.14 ms | |
@@datadir/#innodb_temp/temp_8.ibt | 8 | 32.62 ms | 0 | 0 ps | 3 | 264.89 us | 5 | 32.36 ms | |
@@datadir/#innodb_temp/temp_2.ibt | 8 | 32.03 ms | 0 | 0 ps | 3 | 283.82 us | 5 | 31.75 ms | |
@@datadir/#innodb_temp/temp_3.ibt | 8 | 31.89 ms | 0 | 0 ps | 3 | 194.66 us | 5 | 31.70 ms | |
@@datadir/binlog.index | 13 | 19.67 ms | 3 | 1.90 ms | 0 | 0 ps | 10 | 17.77 ms | |
@@datadir/sakila/rental.ibd | 58 | 9.61 ms | 53 | 9.58 ms | 0 | 0 ps | 5 | 34.85 us | |
@@datadir/mysql/general_log.CSM | 4 | 9.28 ms | 1 | 4.02 ms | 0 | 0 ps | 3 | 5.26 ms | |
@@datadir/sakila/film_actor.ibd | 22 | 7.18 ms | 17 | 7.14 ms | 0 | 0 ps | 5 | 41.53 us | |
@@basedir/share/mysql-8.0/french/errmsg.sys | 5 | 5.47 ms | 3 | 2.51 ms | 0 | 0 ps | 2 | 2.96 ms |
|