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 | 861 | 4.86 s | 2 | 897.49 us | 520 | 99.35 ms | 339 | 4.76 s | |
@@datadir/ibdata1 | 238 | 1.69 s | 20 | 5.82 ms | 109 | 12.06 ms | 109 | 1.67 s | |
@@datadir/ib_logfile0 | 105 | 695.23 ms | 6 | 449.34 us | 48 | 2.64 ms | 51 | 692.14 ms | |
@@datadir/mysql.ibd | 687 | 610.60 ms | 404 | 89.74 ms | 220 | 4.66 ms | 63 | 516.21 ms | |
@@datadir/undo_001 | 743 | 578.92 ms | 388 | 51.94 ms | 309 | 7.29 ms | 46 | 519.68 ms | |
@@datadir/#innodb_temp/temp_10.ibt | 142 | 532.50 ms | 0 | 0 ps | 121 | 133.50 ms | 21 | 399.00 ms | |
@@datadir/undo_002 | 780 | 497.83 ms | 384 | 36.82 ms | 352 | 8.56 ms | 44 | 452.44 ms | |
@@datadir/ibtmp1 | 147 | 262.96 ms | 0 | 0 ps | 143 | 19.45 ms | 4 | 243.51 ms | |
@@datadir/binlog.000008 | 38 | 246.93 ms | 1 | 278.17 us | 16 | 3.82 ms | 21 | 242.83 ms | |
@@datadir/tb/users.ibd | 13 | 86.71 ms | 0 | 0 ps | 7 | 390.13 us | 6 | 86.32 ms | |
@@datadir/gendre_film/gendre.ibd | 13 | 63.88 ms | 0 | 0 ps | 7 | 158.38 us | 6 | 63.72 ms | |
@@datadir/Trainees/college.ibd | 13 | 57.58 ms | 0 | 0 ps | 7 | 139.54 us | 6 | 57.44 ms | |
@@datadir/sakila/customer.ibd | 14 | 56.00 ms | 9 | 55.93 ms | 0 | 0 ps | 5 | 76.14 us | |
@@datadir/comuni/comuni.ibd | 13 | 55.59 ms | 0 | 0 ps | 7 | 363.01 us | 6 | 55.23 ms | |
@@datadir/#innodb_temp/temp_1.ibt | 8 | 52.49 ms | 0 | 0 ps | 3 | 216.16 us | 5 | 52.27 ms | |
@@datadir/#innodb_temp/temp_4.ibt | 8 | 52.29 ms | 0 | 0 ps | 3 | 231.80 us | 5 | 52.06 ms | |
@@datadir/#innodb_temp/temp_5.ibt | 8 | 47.26 ms | 0 | 0 ps | 3 | 284.69 us | 5 | 46.97 ms | |
@@datadir/#innodb_temp/temp_9.ibt | 8 | 36.34 ms | 0 | 0 ps | 3 | 226.86 us | 5 | 36.11 ms | |
@@datadir/#innodb_temp/temp_6.ibt | 8 | 35.66 ms | 0 | 0 ps | 3 | 215.56 us | 5 | 35.45 ms | |
@@datadir/#innodb_temp/temp_7.ibt | 8 | 33.37 ms | 0 | 0 ps | 3 | 222.99 us | 5 | 33.14 ms | |
@@datadir/#innodb_temp/temp_8.ibt | 8 | 32.62 ms | 0 | 0 ps | 3 | 264.89 us | 5 | 32.36 ms | |
@@datadir/#innodb_temp/temp_2.ibt | 8 | 32.03 ms | 0 | 0 ps | 3 | 283.82 us | 5 | 31.75 ms | |
@@datadir/#innodb_temp/temp_3.ibt | 8 | 31.89 ms | 0 | 0 ps | 3 | 194.66 us | 5 | 31.70 ms | |
@@datadir/binlog.index | 13 | 19.67 ms | 3 | 1.90 ms | 0 | 0 ps | 10 | 17.77 ms | |
@@datadir/sakila/rental.ibd | 58 | 9.61 ms | 53 | 9.58 ms | 0 | 0 ps | 5 | 34.85 us |
|