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 | 515 | 2.56 s | 2 | 824.44 us | 304 | 30.30 ms | 209 | 2.53 s | |
@@datadir/ibdata1 | 173 | 1.70 s | 20 | 5.25 ms | 75 | 6.05 ms | 78 | 1.69 s | |
@@datadir/ib_logfile0 | 79 | 516.50 ms | 6 | 476.80 us | 35 | 2.75 ms | 38 | 513.27 ms | |
@@datadir/#innodb_temp/temp_10.ibt | 351 | 438.23 ms | 0 | 0 ps | 330 | 8.26 ms | 21 | 429.97 ms | |
@@datadir/undo_002 | 673 | 377.01 ms | 384 | 31.89 ms | 251 | 6.39 ms | 38 | 338.72 ms | |
@@datadir/undo_001 | 699 | 362.30 ms | 388 | 61.29 ms | 276 | 6.73 ms | 35 | 294.29 ms | |
@@datadir/ibtmp1 | 147 | 284.04 ms | 0 | 0 ps | 143 | 20.78 ms | 4 | 263.26 ms | |
@@datadir/mysql.ibd | 554 | 264.28 ms | 461 | 119.77 ms | 54 | 1.24 ms | 39 | 143.28 ms | |
@@datadir/#innodb_temp/temp_9.ibt | 34 | 193.08 ms | 0 | 0 ps | 20 | 887.31 us | 14 | 192.19 ms | |
@@datadir/binlog.000008 | 8 | 51.88 ms | 0 | 0 ps | 3 | 536.22 us | 5 | 51.34 ms | |
@@datadir/#innodb_temp/temp_1.ibt | 8 | 48.96 ms | 0 | 0 ps | 3 | 251.52 us | 5 | 48.71 ms | |
@@datadir/#innodb_temp/temp_3.ibt | 8 | 43.09 ms | 0 | 0 ps | 3 | 241.92 us | 5 | 42.85 ms | |
@@datadir/#innodb_temp/temp_6.ibt | 8 | 37.19 ms | 0 | 0 ps | 3 | 234.72 us | 5 | 36.96 ms | |
@@datadir/#innodb_temp/temp_8.ibt | 8 | 37.02 ms | 0 | 0 ps | 3 | 254.91 us | 5 | 36.77 ms | |
@@datadir/#innodb_temp/temp_7.ibt | 8 | 35.96 ms | 0 | 0 ps | 3 | 260.96 us | 5 | 35.70 ms | |
@@datadir/#innodb_temp/temp_2.ibt | 8 | 32.44 ms | 0 | 0 ps | 3 | 255.88 us | 5 | 32.19 ms | |
@@datadir/#innodb_temp/temp_4.ibt | 8 | 30.71 ms | 0 | 0 ps | 3 | 188.65 us | 5 | 30.52 ms | |
@@datadir/#innodb_temp/temp_5.ibt | 8 | 30.35 ms | 0 | 0 ps | 3 | 144.75 us | 5 | 30.20 ms | |
@@datadir/binlog.index | 13 | 23.33 ms | 3 | 32.73 us | 0 | 0 ps | 10 | 23.29 ms | |
@@basedir/share/mysql-8.0/spanish/errmsg.sys | 5 | 8.29 ms | 3 | 3.32 ms | 0 | 0 ps | 2 | 4.96 ms | |
@@datadir/binlog.000007 | 100 | 6.14 ms | 25 | 3.64 ms | 1 | 5.83 us | 74 | 2.49 ms | |
@@basedir/share/mysql-8.0/italian/errmsg.sys | 5 | 5.37 ms | 3 | 2.96 ms | 0 | 0 ps | 2 | 2.42 ms | |
@@datadir/sakila/inventory.ibd | 21 | 5.33 ms | 16 | 5.28 ms | 0 | 0 ps | 5 | 48.37 us | |
@@datadir/StdMdDB/score.ibd | 9 | 4.36 ms | 4 | 2.37 ms | 0 | 0 ps | 5 | 1.99 ms | |
@@basedir/share/mysql-8.0/german/errmsg.sys | 5 | 3.10 ms | 3 | 1.14 ms | 0 | 0 ps | 2 | 1.96 ms |
|