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 | 456 | 2.61 s | 2 | 647.64 us | 272 | 49.12 ms | 182 | 2.56 s | |
@@datadir/ibdata1 | 182 | 1.34 s | 20 | 4.90 ms | 79 | 5.87 ms | 83 | 1.33 s | |
@@datadir/undo_001 | 635 | 422.73 ms | 388 | 33.48 ms | 205 | 8.75 ms | 42 | 380.50 ms | |
@@datadir/ib_logfile0 | 67 | 411.60 ms | 6 | 478.42 us | 29 | 1.25 ms | 32 | 409.87 ms | |
@@datadir/undo_002 | 589 | 407.30 ms | 382 | 28.07 ms | 170 | 4.28 ms | 37 | 374.94 ms | |
@@datadir/mysql.ibd | 559 | 406.74 ms | 429 | 93.25 ms | 86 | 2.07 ms | 44 | 311.42 ms | |
@@datadir/#innodb_temp/temp_10.ibt | 53 | 308.95 ms | 0 | 0 ps | 34 | 1.73 ms | 19 | 307.22 ms | |
@@datadir/ibtmp1 | 147 | 233.92 ms | 0 | 0 ps | 143 | 11.64 ms | 4 | 222.29 ms | |
@@datadir/binlog.000008 | 14 | 104.33 ms | 0 | 0 ps | 6 | 628.00 us | 8 | 103.70 ms | |
@@datadir/mysql/users.ibd | 14 | 71.77 ms | 0 | 0 ps | 7 | 493.10 us | 7 | 71.28 ms | |
@@datadir/#innodb_temp/temp_3.ibt | 8 | 34.56 ms | 0 | 0 ps | 3 | 113.38 us | 5 | 34.44 ms | |
@@datadir/#innodb_temp/temp_2.ibt | 8 | 33.72 ms | 0 | 0 ps | 3 | 86.04 us | 5 | 33.64 ms | |
@@datadir/#innodb_temp/temp_1.ibt | 8 | 33.49 ms | 0 | 0 ps | 3 | 78.94 us | 5 | 33.41 ms | |
@@datadir/#innodb_temp/temp_9.ibt | 8 | 32.99 ms | 0 | 0 ps | 3 | 242.09 us | 5 | 32.75 ms | |
@@datadir/#innodb_temp/temp_4.ibt | 8 | 32.66 ms | 0 | 0 ps | 3 | 202.16 us | 5 | 32.46 ms | |
@@datadir/#innodb_temp/temp_8.ibt | 8 | 32.16 ms | 0 | 0 ps | 3 | 194.82 us | 5 | 31.97 ms | |
@@datadir/#innodb_temp/temp_5.ibt | 8 | 30.74 ms | 0 | 0 ps | 3 | 198.83 us | 5 | 30.55 ms | |
@@datadir/#innodb_temp/temp_7.ibt | 8 | 30.15 ms | 0 | 0 ps | 3 | 91.16 us | 5 | 30.06 ms | |
@@datadir/#innodb_temp/temp_6.ibt | 8 | 30.14 ms | 0 | 0 ps | 3 | 96.12 us | 5 | 30.04 ms | |
@@datadir/binlog.index | 13 | 21.00 ms | 3 | 57.67 us | 0 | 0 ps | 10 | 20.95 ms | |
@@basedir/share/mysql-8.0/hungarian/errmsg.sys | 5 | 6.08 ms | 3 | 3.09 ms | 0 | 0 ps | 2 | 2.99 ms | |
@@basedir/share/mysql-8.0/german/errmsg.sys | 5 | 5.78 ms | 3 | 3.47 ms | 0 | 0 ps | 2 | 2.30 ms | |
@@basedir/share/mysql-8.0/russian/errmsg.sys | 5 | 5.07 ms | 3 | 1.43 ms | 0 | 0 ps | 2 | 3.64 ms | |
@@datadir/Table_insertion/RK.ibd | 9 | 5.00 ms | 4 | 4.90 ms | 0 | 0 ps | 5 | 101.24 us | |
@@basedir/share/mysql-8.0/japanese/errmsg.sys | 5 | 4.58 ms | 3 | 3.45 ms | 0 | 0 ps | 2 | 1.13 ms |
|