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 | 367 | 2.40 s | 2 | 752.25 us | 221 | 143.93 ms | 144 | 2.25 s | |
@@datadir/ibdata1 | 89 | 580.25 ms | 20 | 6.40 ms | 33 | 5.08 ms | 36 | 568.77 ms | |
@@datadir/undo_001 | 589 | 284.48 ms | 388 | 67.73 ms | 183 | 5.80 ms | 18 | 210.95 ms | |
@@datadir/undo_002 | 540 | 276.67 ms | 382 | 50.81 ms | 138 | 4.73 ms | 20 | 221.13 ms | |
@@datadir/ibtmp1 | 147 | 270.82 ms | 0 | 0 ps | 143 | 19.14 ms | 4 | 251.67 ms | |
@@datadir/test19/speciale.ibd | 9 | 222.90 ms | 4 | 222.80 ms | 0 | 0 ps | 5 | 96.24 us | |
@@datadir/ib_logfile0 | 35 | 209.69 ms | 6 | 631.87 us | 13 | 632.53 us | 16 | 208.43 ms | |
@@datadir/mysql.ibd | 354 | 161.48 ms | 315 | 71.70 ms | 21 | 642.24 us | 18 | 89.14 ms | |
@@datadir/#innodb_temp/temp_10.ibt | 11 | 51.76 ms | 0 | 0 ps | 5 | 357.47 us | 6 | 51.40 ms | |
@@datadir/#innodb_temp/temp_1.ibt | 8 | 47.03 ms | 0 | 0 ps | 3 | 283.12 us | 5 | 46.74 ms | |
@@datadir/#innodb_temp/temp_9.ibt | 8 | 39.03 ms | 0 | 0 ps | 3 | 253.52 us | 5 | 38.78 ms | |
@@datadir/#innodb_temp/temp_5.ibt | 8 | 37.32 ms | 0 | 0 ps | 3 | 247.21 us | 5 | 37.08 ms | |
@@datadir/binlog.000008 | 6 | 36.82 ms | 0 | 0 ps | 2 | 68.65 us | 4 | 36.75 ms | |
@@datadir/#innodb_temp/temp_3.ibt | 8 | 35.19 ms | 0 | 0 ps | 3 | 260.10 us | 5 | 34.93 ms | |
@@datadir/#innodb_temp/temp_2.ibt | 8 | 34.31 ms | 0 | 0 ps | 3 | 334.11 us | 5 | 33.97 ms | |
@@datadir/#innodb_temp/temp_8.ibt | 8 | 34.13 ms | 0 | 0 ps | 3 | 364.71 us | 5 | 33.77 ms | |
@@datadir/#innodb_temp/temp_4.ibt | 8 | 34.00 ms | 0 | 0 ps | 3 | 249.10 us | 5 | 33.75 ms | |
@@datadir/#innodb_temp/temp_6.ibt | 8 | 31.90 ms | 0 | 0 ps | 3 | 253.63 us | 5 | 31.65 ms | |
@@datadir/#innodb_temp/temp_7.ibt | 8 | 31.64 ms | 0 | 0 ps | 3 | 253.20 us | 5 | 31.38 ms | |
@@datadir/binlog.index | 13 | 18.15 ms | 3 | 34.56 us | 0 | 0 ps | 10 | 18.12 ms | |
@@basedir/share/mysql-8.0/korean/errmsg.sys | 5 | 5.79 ms | 3 | 3.45 ms | 0 | 0 ps | 2 | 2.33 ms | |
@@basedir/share/mysql-8.0/french/errmsg.sys | 5 | 5.34 ms | 3 | 5.07 ms | 0 | 0 ps | 2 | 269.20 us | |
@@basedir/share/mysql-8.0/hungarian/errmsg.sys | 5 | 5.09 ms | 3 | 3.03 ms | 0 | 0 ps | 2 | 2.06 ms | |
@@datadir/sakila/customer.ibd | 14 | 5.05 ms | 9 | 5.01 ms | 0 | 0 ps | 5 | 40.43 us | |
@@basedir/share/mysql-8.0/portuguese/errmsg.sys | 5 | 4.52 ms | 3 | 960.99 us | 0 | 0 ps | 2 | 3.56 ms |
|