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 | 246 | 1.64 s | 2 | 995.55 us | 147 | 54.30 ms | 97 | 1.58 s | |
@@datadir/ibdata1 | 88 | 674.70 ms | 20 | 18.30 ms | 32 | 3.33 ms | 36 | 653.07 ms | |
@@datadir/ibtmp1 | 147 | 319.93 ms | 0 | 0 ps | 143 | 59.53 ms | 4 | 260.40 ms | |
@@datadir/mysql.ibd | 411 | 303.59 ms | 330 | 166.56 ms | 61 | 2.03 ms | 20 | 135.00 ms | |
@@datadir/ib_logfile0 | 39 | 248.23 ms | 6 | 717.21 us | 15 | 1.21 ms | 18 | 246.30 ms | |
@@datadir/#innodb_temp/temp_9.ibt | 35 | 242.05 ms | 0 | 0 ps | 20 | 1.19 ms | 15 | 240.86 ms | |
@@datadir/undo_002 | 446 | 232.32 ms | 382 | 73.06 ms | 46 | 1.41 ms | 18 | 157.85 ms | |
@@datadir/binlog.000008 | 12 | 198.05 ms | 0 | 0 ps | 5 | 2.06 ms | 7 | 195.99 ms | |
@@datadir/undo_001 | 448 | 190.59 ms | 387 | 85.08 ms | 46 | 1.31 ms | 15 | 104.20 ms | |
@@datadir/#innodb_temp/temp_10.ibt | 23 | 172.11 ms | 0 | 0 ps | 11 | 713.29 us | 12 | 171.40 ms | |
@@datadir/MEHDI@0020EL@0020HENDI/adherents.ibd | 13 | 111.60 ms | 0 | 0 ps | 7 | 255.84 us | 6 | 111.34 ms | |
@@datadir/#innodb_temp/temp_1.ibt | 8 | 74.38 ms | 0 | 0 ps | 3 | 508.84 us | 5 | 73.87 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.index | 13 | 21.22 ms | 3 | 34.31 us | 0 | 0 ps | 10 | 21.19 ms | |
@@datadir/sakila/rental.ibd | 58 | 11.57 ms | 53 | 11.53 ms | 0 | 0 ps | 5 | 47.47 us | |
@@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 |
|