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 | 216 | 1.46 s | 2 | 995.55 us | 129 | 46.57 ms | 85 | 1.41 s | |
@@datadir/ibdata1 | 80 | 611.74 ms | 20 | 18.30 ms | 28 | 3.15 ms | 32 | 590.29 ms | |
@@datadir/ibtmp1 | 147 | 319.93 ms | 0 | 0 ps | 143 | 59.53 ms | 4 | 260.40 ms | |
@@datadir/mysql.ibd | 403 | 292.17 ms | 328 | 162.38 ms | 57 | 1.96 ms | 18 | 127.83 ms | |
@@datadir/#innodb_temp/temp_9.ibt | 35 | 242.05 ms | 0 | 0 ps | 20 | 1.19 ms | 15 | 240.86 ms | |
@@datadir/ib_logfile0 | 35 | 220.97 ms | 6 | 717.21 us | 13 | 601.94 us | 16 | 219.65 ms | |
@@datadir/undo_002 | 436 | 214.60 ms | 382 | 73.06 ms | 38 | 1.25 ms | 16 | 140.30 ms | |
@@datadir/binlog.000008 | 12 | 198.05 ms | 0 | 0 ps | 5 | 2.06 ms | 7 | 195.99 ms | |
@@datadir/#innodb_temp/temp_10.ibt | 23 | 172.11 ms | 0 | 0 ps | 11 | 713.29 us | 12 | 171.40 ms | |
@@datadir/undo_001 | 437 | 167.88 ms | 387 | 85.08 ms | 37 | 1.15 ms | 13 | 81.65 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 |
|