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 | 619 | 3.32 s | 2 | 746.01 us | 374 | 131.86 ms | 243 | 3.19 s | |
@@datadir/ibdata1 | 108 | 727.28 ms | 20 | 7.65 ms | 43 | 4.44 ms | 45 | 715.18 ms | |
@@datadir/#innodb_temp/temp_9.ibt | 411 | 536.46 ms | 0 | 0 ps | 394 | 287.15 ms | 17 | 249.31 ms | |
@@datadir/mysql.ibd | 491 | 351.39 ms | 434 | 221.53 ms | 33 | 632.31 us | 24 | 129.23 ms | |
@@datadir/ibtmp1 | 147 | 258.48 ms | 0 | 0 ps | 143 | 10.53 ms | 4 | 247.95 ms | |
@@datadir/undo_002 | 818 | 252.82 ms | 384 | 24.00 ms | 410 | 4.43 ms | 24 | 224.38 ms | |
@@datadir/ib_logfile0 | 45 | 249.66 ms | 6 | 649.06 us | 18 | 2.36 ms | 21 | 246.65 ms | |
@@datadir/undo_001 | 676 | 244.99 ms | 388 | 37.88 ms | 267 | 3.19 ms | 21 | 203.92 ms | |
@@datadir/#innodb_temp/temp_10.ibt | 104 | 89.98 ms | 0 | 0 ps | 96 | 1.08 ms | 8 | 88.90 ms | |
@@datadir/binlog.000008 | 8 | 44.27 ms | 0 | 0 ps | 3 | 555.79 us | 5 | 43.72 ms | |
@@datadir/#innodb_temp/temp_1.ibt | 8 | 40.40 ms | 0 | 0 ps | 3 | 258.07 us | 5 | 40.14 ms | |
@@datadir/#innodb_temp/temp_6.ibt | 8 | 35.92 ms | 0 | 0 ps | 3 | 215.78 us | 5 | 35.71 ms | |
@@datadir/#innodb_temp/temp_8.ibt | 8 | 35.35 ms | 0 | 0 ps | 3 | 254.02 us | 5 | 35.10 ms | |
@@datadir/#innodb_temp/temp_3.ibt | 8 | 34.78 ms | 0 | 0 ps | 3 | 235.59 us | 5 | 34.55 ms | |
@@datadir/#innodb_temp/temp_2.ibt | 8 | 34.51 ms | 0 | 0 ps | 3 | 219.49 us | 5 | 34.29 ms | |
@@datadir/#innodb_temp/temp_4.ibt | 8 | 34.29 ms | 0 | 0 ps | 3 | 220.04 us | 5 | 34.07 ms | |
@@datadir/#innodb_temp/temp_5.ibt | 8 | 33.78 ms | 0 | 0 ps | 3 | 311.14 us | 5 | 33.47 ms | |
@@datadir/#innodb_temp/temp_7.ibt | 8 | 33.42 ms | 0 | 0 ps | 3 | 248.23 us | 5 | 33.17 ms | |
@@datadir/binlog.index | 13 | 16.63 ms | 3 | 195.90 us | 0 | 0 ps | 10 | 16.44 ms | |
@@basedir/share/mysql-8.0/slovak/errmsg.sys | 5 | 9.24 ms | 3 | 2.88 ms | 0 | 0 ps | 2 | 6.36 ms | |
@@datadir/sys/sys_config.ibd | 9 | 8.08 ms | 4 | 8.02 ms | 0 | 0 ps | 5 | 58.84 us | |
@@datadir/sakila/film.ibd | 21 | 6.52 ms | 16 | 6.46 ms | 0 | 0 ps | 5 | 59.28 us | |
@@datadir/binlog.000007 | 56 | 5.99 ms | 14 | 5.26 ms | 1 | 7.31 us | 41 | 723.72 us | |
@@datadir/sakila/customer.ibd | 14 | 5.73 ms | 9 | 5.67 ms | 0 | 0 ps | 5 | 57.15 us | |
@@basedir/share/mysql-8.0/portuguese/errmsg.sys | 5 | 4.72 ms | 3 | 2.52 ms | 0 | 0 ps | 2 | 2.21 ms |
|