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 | 69 | 440.98 ms | 2 | 995.55 us | 39 | 4.13 ms | 28 | 435.85 ms | |
@@datadir/ibtmp1 | 147 | 319.93 ms | 0 | 0 ps | 143 | 59.53 ms | 4 | 260.40 ms | |
@@datadir/#innodb_temp/temp_10.ibt | 22 | 172.08 ms | 0 | 0 ps | 10 | 688.16 us | 12 | 171.40 ms | |
@@datadir/mysql.ibd | 332 | 165.24 ms | 322 | 154.76 ms | 4 | 125.67 us | 6 | 10.35 ms | |
@@datadir/ibdata1 | 33 | 116.43 ms | 20 | 18.30 ms | 4 | 414.88 us | 9 | 97.72 ms | |
@@datadir/#innodb_temp/temp_9.ibt | 16 | 107.99 ms | 0 | 0 ps | 7 | 583.95 us | 9 | 107.41 ms | |
@@datadir/undo_001 | 400 | 97.02 ms | 387 | 85.08 ms | 7 | 406.87 us | 6 | 11.54 ms | |
@@datadir/undo_002 | 390 | 82.67 ms | 382 | 73.06 ms | 2 | 63.79 us | 6 | 9.55 ms | |
@@datadir/#innodb_temp/temp_1.ibt | 8 | 74.38 ms | 0 | 0 ps | 3 | 508.84 us | 5 | 73.87 ms | |
@@datadir/ib_logfile0 | 13 | 67.31 ms | 6 | 717.21 us | 2 | 46.24 us | 5 | 66.55 ms | |
@@datadir/#innodb_temp/temp_8.ibt | 8 | 66.72 ms | 0 | 0 ps | 3 | 623.23 us | 5 | 66.10 ms | |
@@datadir/#innodb_temp/temp_7.ibt | 8 | 62.66 ms | 0 | 0 ps | 3 | 456.85 us | 5 | 62.20 ms | |
@@datadir/#innodb_temp/temp_5.ibt | 8 | 56.14 ms | 0 | 0 ps | 3 | 381.78 us | 5 | 55.76 ms | |
@@datadir/#innodb_temp/temp_6.ibt | 8 | 54.68 ms | 0 | 0 ps | 3 | 393.65 us | 5 | 54.29 ms | |
@@datadir/#innodb_temp/temp_3.ibt | 8 | 53.45 ms | 0 | 0 ps | 3 | 207.45 us | 5 | 53.24 ms | |
@@datadir/#innodb_temp/temp_4.ibt | 8 | 51.58 ms | 0 | 0 ps | 3 | 422.19 us | 5 | 51.15 ms | |
@@datadir/#innodb_temp/temp_2.ibt | 8 | 49.38 ms | 0 | 0 ps | 3 | 156.58 us | 5 | 49.23 ms | |
@@datadir/binlog.000008 | 6 | 46.59 ms | 0 | 0 ps | 2 | 51.90 us | 4 | 46.54 ms | |
@@datadir/binlog.index | 13 | 21.22 ms | 3 | 34.31 us | 0 | 0 ps | 10 | 21.19 ms | |
@@datadir/sakila/language.ibd | 3 | 10.10 ms | 1 | 10.08 ms | 0 | 0 ps | 2 | 13.95 us | |
@@basedir/share/mysql-8.0/swedish/errmsg.sys | 5 | 6.90 ms | 3 | 2.01 ms | 0 | 0 ps | 2 | 4.89 ms | |
@@basedir/share/mysql-8.0/italian/errmsg.sys | 5 | 6.09 ms | 3 | 5.79 ms | 0 | 0 ps | 2 | 295.01 us | |
@@datadir/sakila/payment.ibd | 3 | 5.50 ms | 1 | 5.49 ms | 0 | 0 ps | 2 | 18.38 us | |
@@datadir/auto.cnf | 5 | 3.36 ms | 3 | 3.32 ms | 0 | 0 ps | 2 | 40.93 us | |
@@datadir/@0020@U0@H0@R0@Y1@Q0@0020@Y0@L0@R0@L0@G1... | 3 | 3.35 ms | 1 | 3.32 ms | 0 | 0 ps | 2 | 28.86 us |
|