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 | 270 | 2.45 s | 2 | 874.52 us | 159 | 18.39 ms | 109 | 2.43 s | |
@@datadir/ibdata1 | 71 | 406.97 ms | 20 | 5.92 ms | 23 | 3.69 ms | 28 | 397.35 ms | |
@@datadir/ibtmp1 | 147 | 282.79 ms | 0 | 0 ps | 143 | 12.19 ms | 4 | 270.60 ms | |
@@datadir/#innodb_temp/temp_10.ibt | 46 | 243.96 ms | 0 | 0 ps | 29 | 1.34 ms | 17 | 242.63 ms | |
@@datadir/mysql.ibd | 352 | 178.10 ms | 311 | 92.03 ms | 24 | 540.87 us | 17 | 85.52 ms | |
@@datadir/undo_001 | 465 | 177.80 ms | 387 | 39.16 ms | 64 | 1.21 ms | 14 | 137.43 ms | |
@@datadir/ib_logfile0 | 33 | 172.85 ms | 6 | 533.60 us | 12 | 902.81 us | 15 | 171.41 ms | |
@@datadir/undo_002 | 461 | 155.02 ms | 382 | 22.60 ms | 63 | 1.28 ms | 16 | 131.15 ms | |
@@datadir/#innodb_temp/temp_9.ibt | 15 | 87.40 ms | 0 | 0 ps | 7 | 502.81 us | 8 | 86.90 ms | |
@@datadir/binlog.000008 | 10 | 76.86 ms | 0 | 0 ps | 4 | 997.49 us | 6 | 75.86 ms | |
@@datadir/#innodb_temp/temp_1.ibt | 8 | 48.82 ms | 0 | 0 ps | 3 | 287.02 us | 5 | 48.53 ms | |
@@datadir/#innodb_temp/temp_4.ibt | 8 | 45.99 ms | 0 | 0 ps | 3 | 250.53 us | 5 | 45.74 ms | |
@@datadir/sakila/rental.ibd | 58 | 42.73 ms | 53 | 40.83 ms | 0 | 0 ps | 5 | 1.90 ms | |
@@datadir/#innodb_temp/temp_7.ibt | 8 | 42.41 ms | 0 | 0 ps | 3 | 286.91 us | 5 | 42.12 ms | |
@@datadir/#innodb_temp/temp_3.ibt | 8 | 40.56 ms | 0 | 0 ps | 3 | 237.49 us | 5 | 40.32 ms | |
@@datadir/#innodb_temp/temp_5.ibt | 8 | 40.36 ms | 0 | 0 ps | 3 | 246.46 us | 5 | 40.12 ms | |
@@datadir/#innodb_temp/temp_8.ibt | 8 | 36.61 ms | 0 | 0 ps | 3 | 318.14 us | 5 | 36.30 ms | |
@@datadir/#innodb_temp/temp_6.ibt | 8 | 34.99 ms | 0 | 0 ps | 3 | 246.42 us | 5 | 34.75 ms | |
@@datadir/#innodb_temp/temp_2.ibt | 8 | 33.64 ms | 0 | 0 ps | 3 | 234.26 us | 5 | 33.40 ms | |
@@datadir/binlog.index | 13 | 20.31 ms | 3 | 31.54 us | 0 | 0 ps | 10 | 20.28 ms | |
@@datadir/sakila/payment.ibd | 53 | 16.03 ms | 48 | 16.01 ms | 0 | 0 ps | 5 | 26.69 us | |
@@datadir/sakila/inventory.ibd | 21 | 13.64 ms | 16 | 13.57 ms | 0 | 0 ps | 5 | 61.02 us | |
@@datadir/sakila/film_actor.ibd | 22 | 12.18 ms | 17 | 12.10 ms | 0 | 0 ps | 5 | 73.66 us | |
@@datadir/sakila/film_category.ibd | 12 | 7.90 ms | 7 | 7.87 ms | 0 | 0 ps | 5 | 29.30 us | |
@@datadir/sakila/address.ibd | 13 | 6.68 ms | 8 | 6.64 ms | 0 | 0 ps | 5 | 38.68 us |
|