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 | 653 | 3.85 s | 2 | 738.31 us | 387 | 63.54 ms | 264 | 3.79 s | |
@@datadir/ibdata1 | 269 | 1.93 s | 20 | 5.12 ms | 123 | 9.71 ms | 126 | 1.91 s | |
@@datadir/#innodb_temp/temp_9.ibt | 363 | 1.00 s | 0 | 0 ps | 312 | 125.06 ms | 51 | 875.71 ms | |
@@datadir/ib_logfile0 | 119 | 795.65 ms | 6 | 448.93 us | 55 | 6.29 ms | 58 | 788.91 ms | |
@@datadir/undo_002 | 705 | 510.68 ms | 384 | 25.55 ms | 275 | 11.14 ms | 46 | 473.99 ms | |
@@datadir/undo_001 | 718 | 454.46 ms | 388 | 27.35 ms | 283 | 8.11 ms | 47 | 419.00 ms | |
@@datadir/mysql.ibd | 565 | 381.01 ms | 432 | 104.75 ms | 73 | 1.94 ms | 60 | 274.32 ms | |
@@datadir/#innodb_temp/temp_10.ibt | 227 | 359.48 ms | 0 | 0 ps | 210 | 91.72 ms | 17 | 267.77 ms | |
@@datadir/ibtmp1 | 147 | 231.62 ms | 0 | 0 ps | 143 | 7.81 ms | 4 | 223.81 ms | |
@@datadir/binlog.000008 | 8 | 43.71 ms | 0 | 0 ps | 3 | 2.79 ms | 5 | 40.92 ms | |
@@datadir/sakila/payment.ibd | 70 | 41.69 ms | 65 | 41.64 ms | 0 | 0 ps | 5 | 42.38 us | |
@@datadir/#innodb_temp/temp_1.ibt | 8 | 36.30 ms | 0 | 0 ps | 3 | 61.49 us | 5 | 36.24 ms | |
@@datadir/#innodb_temp/temp_7.ibt | 8 | 35.64 ms | 0 | 0 ps | 3 | 52.94 us | 5 | 35.58 ms | |
@@datadir/#innodb_temp/temp_3.ibt | 8 | 32.01 ms | 0 | 0 ps | 3 | 57.99 us | 5 | 31.95 ms | |
@@datadir/#innodb_temp/temp_4.ibt | 8 | 30.71 ms | 0 | 0 ps | 3 | 53.54 us | 5 | 30.66 ms | |
@@datadir/#innodb_temp/temp_6.ibt | 8 | 28.61 ms | 0 | 0 ps | 3 | 53.22 us | 5 | 28.56 ms | |
@@datadir/#innodb_temp/temp_8.ibt | 8 | 27.48 ms | 0 | 0 ps | 3 | 55.54 us | 5 | 27.42 ms | |
@@datadir/#innodb_temp/temp_2.ibt | 8 | 27.31 ms | 0 | 0 ps | 3 | 53.08 us | 5 | 27.25 ms | |
@@datadir/#innodb_temp/temp_5.ibt | 8 | 27.31 ms | 0 | 0 ps | 3 | 66.62 us | 5 | 27.24 ms | |
@@datadir/sakila/rental.ibd | 75 | 18.38 ms | 70 | 18.32 ms | 0 | 0 ps | 5 | 51.23 us | |
@@datadir/binlog.index | 13 | 15.62 ms | 3 | 140.90 us | 0 | 0 ps | 10 | 15.48 ms | |
@@datadir/sakila/inventory.ibd | 31 | 9.22 ms | 26 | 9.19 ms | 0 | 0 ps | 5 | 29.26 us | |
@@datadir/binlog.000007 | 376 | 7.86 ms | 94 | 5.27 ms | 1 | 4.57 us | 281 | 2.58 ms | |
@@datadir/sakila/staff.ibd | 11 | 7.02 ms | 6 | 6.98 ms | 0 | 0 ps | 5 | 43.73 us | |
@@basedir/share/mysql-8.0/romanian/errmsg.sys | 5 | 6.24 ms | 3 | 3.41 ms | 0 | 0 ps | 2 | 2.83 ms |
|