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 | 563 | 3.11 s | 2 | 766.91 us | 343 | 99.11 ms | 218 | 3.01 s | |
@@datadir/ibdata1 | 149 | 1.08 s | 20 | 5.44 ms | 64 | 8.21 ms | 65 | 1.07 s | |
@@datadir/#innodb_temp/temp_10.ibt | 70 | 456.82 ms | 0 | 0 ps | 44 | 2.06 ms | 26 | 454.76 ms | |
@@datadir/ib_logfile0 | 63 | 395.45 ms | 6 | 427.55 us | 27 | 1.14 ms | 30 | 393.88 ms | |
@@datadir/mysql.ibd | 528 | 349.67 ms | 364 | 94.05 ms | 129 | 3.88 ms | 35 | 251.74 ms | |
@@datadir/undo_002 | 645 | 337.97 ms | 382 | 26.05 ms | 234 | 5.51 ms | 29 | 306.41 ms | |
@@datadir/undo_001 | 636 | 331.32 ms | 388 | 31.35 ms | 220 | 5.73 ms | 28 | 294.24 ms | |
@@datadir/ibtmp1 | 147 | 239.17 ms | 0 | 0 ps | 143 | 9.92 ms | 4 | 229.25 ms | |
@@datadir/taobao/OrderItem.ibd | 25 | 177.26 ms | 0 | 0 ps | 14 | 680.23 us | 11 | 176.58 ms | |
@@datadir/binlog.000008 | 20 | 148.06 ms | 0 | 0 ps | 9 | 1.49 ms | 11 | 146.57 ms | |
@@datadir/Huda/sales.ibd | 13 | 68.65 ms | 0 | 0 ps | 7 | 495.59 us | 6 | 68.16 ms | |
@@datadir/#innodb_temp/temp_1.ibt | 8 | 61.92 ms | 0 | 0 ps | 3 | 69.28 us | 5 | 61.85 ms | |
@@datadir/#innodb_temp/temp_9.ibt | 11 | 42.75 ms | 0 | 0 ps | 5 | 154.69 us | 6 | 42.60 ms | |
@@datadir/#innodb_temp/temp_5.ibt | 8 | 35.46 ms | 0 | 0 ps | 3 | 54.93 us | 5 | 35.40 ms | |
@@datadir/#innodb_temp/temp_2.ibt | 8 | 32.41 ms | 0 | 0 ps | 3 | 69.04 us | 5 | 32.34 ms | |
@@datadir/#innodb_temp/temp_3.ibt | 8 | 32.00 ms | 0 | 0 ps | 3 | 62.26 us | 5 | 31.93 ms | |
@@datadir/#innodb_temp/temp_4.ibt | 8 | 28.98 ms | 0 | 0 ps | 3 | 58.91 us | 5 | 28.92 ms | |
@@datadir/#innodb_temp/temp_8.ibt | 8 | 27.93 ms | 0 | 0 ps | 3 | 63.46 us | 5 | 27.86 ms | |
@@datadir/#innodb_temp/temp_6.ibt | 8 | 27.72 ms | 0 | 0 ps | 3 | 54.54 us | 5 | 27.66 ms | |
@@datadir/#innodb_temp/temp_7.ibt | 8 | 26.74 ms | 0 | 0 ps | 3 | 60.15 us | 5 | 26.68 ms | |
@@datadir/binlog.index | 13 | 18.15 ms | 3 | 19.11 us | 0 | 0 ps | 10 | 18.13 ms | |
@@basedir/share/mysql-8.0/ukrainian/errmsg.sys | 5 | 5.27 ms | 3 | 2.69 ms | 0 | 0 ps | 2 | 2.58 ms | |
@@basedir/share/mysql-8.0/russian/errmsg.sys | 5 | 5.10 ms | 3 | 1.08 ms | 0 | 0 ps | 2 | 4.03 ms | |
@@datadir/PRUEBA/MATERIAL.ibd | 9 | 4.44 ms | 4 | 4.38 ms | 0 | 0 ps | 5 | 61.30 us | |
@@basedir/share/mysql-8.0/romanian/errmsg.sys | 5 | 4.27 ms | 3 | 4.04 ms | 0 | 0 ps | 2 | 230.36 us |
|