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 | 1839 | 9.76 s | 2 | 831.96 us | 1180 | 298.76 ms | 657 | 9.46 s | |
@@datadir/ibdata1 | 295 | 2.28 s | 20 | 11.36 ms | 143 | 14.32 ms | 132 | 2.26 s | |
@@datadir/mysql.ibd | 836 | 826.91 ms | 371 | 92.33 ms | 391 | 12.81 ms | 74 | 721.77 ms | |
@@datadir/ib_logfile0 | 105 | 701.23 ms | 6 | 733.10 us | 48 | 2.37 ms | 51 | 698.13 ms | |
@@datadir/undo_002 | 876 | 699.92 ms | 384 | 34.52 ms | 434 | 60.71 ms | 58 | 604.69 ms | |
@@datadir/undo_001 | 887 | 667.78 ms | 388 | 67.75 ms | 438 | 18.99 ms | 61 | 581.04 ms | |
@@datadir/binlog.000008 | 74 | 559.13 ms | 0 | 0 ps | 36 | 6.32 ms | 38 | 552.80 ms | |
@@datadir/sakila/payment.ibd | 70 | 279.70 ms | 65 | 279.69 ms | 0 | 0 ps | 5 | 13.29 us | |
@@datadir/ibtmp1 | 147 | 257.53 ms | 0 | 0 ps | 143 | 15.76 ms | 4 | 241.77 ms | |
@@datadir/#innodb_temp/temp_10.ibt | 32 | 201.94 ms | 0 | 0 ps | 19 | 1.08 ms | 13 | 200.86 ms | |
@@datadir/BD2/pedidos.ibd | 21 | 118.01 ms | 0 | 0 ps | 10 | 815.41 us | 11 | 117.19 ms | |
@@datadir/BD2/cliente.ibd | 17 | 91.66 ms | 0 | 0 ps | 8 | 692.29 us | 9 | 90.97 ms | |
@@datadir/BD2/vendedor.ibd | 19 | 87.52 ms | 0 | 0 ps | 9 | 392.70 us | 10 | 87.13 ms | |
@@datadir/BD2/producto.ibd | 17 | 86.54 ms | 0 | 0 ps | 8 | 505.16 us | 9 | 86.04 ms | |
@@datadir/BD2/cliente2.ibd | 13 | 70.30 ms | 0 | 0 ps | 7 | 6.14 ms | 6 | 64.16 ms | |
@@datadir/BD2/oficina.ibd | 17 | 57.20 ms | 0 | 0 ps | 8 | 436.10 us | 9 | 56.77 ms | |
@@datadir/test/contact@002dform.ibd | 13 | 57.11 ms | 0 | 0 ps | 7 | 147.29 us | 6 | 56.96 ms | |
@@datadir/sakila/film.ibd | 21 | 54.48 ms | 16 | 54.47 ms | 0 | 0 ps | 5 | 14.31 us | |
@@datadir/#innodb_temp/temp_4.ibt | 8 | 51.81 ms | 0 | 0 ps | 3 | 234.46 us | 5 | 51.57 ms | |
@@datadir/#innodb_temp/temp_1.ibt | 8 | 41.72 ms | 0 | 0 ps | 3 | 266.77 us | 5 | 41.45 ms | |
@@datadir/#innodb_temp/temp_8.ibt | 8 | 37.11 ms | 0 | 0 ps | 3 | 224.60 us | 5 | 36.89 ms | |
@@datadir/#innodb_temp/temp_3.ibt | 8 | 36.08 ms | 0 | 0 ps | 3 | 259.24 us | 5 | 35.82 ms | |
@@datadir/#innodb_temp/temp_2.ibt | 8 | 34.37 ms | 0 | 0 ps | 3 | 280.44 us | 5 | 34.09 ms | |
@@datadir/#innodb_temp/temp_5.ibt | 8 | 34.05 ms | 0 | 0 ps | 3 | 242.03 us | 5 | 33.81 ms | |
@@datadir/#innodb_temp/temp_7.ibt | 8 | 33.80 ms | 0 | 0 ps | 3 | 244.30 us | 5 | 33.56 ms |
|