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 | 1433 | 7.47 s | 2 | 831.96 us | 926 | 254.88 ms | 505 | 7.21 s | |
@@datadir/ibdata1 | 191 | 1.46 s | 20 | 11.36 ms | 87 | 8.25 ms | 84 | 1.44 s | |
@@datadir/undo_002 | 745 | 546.18 ms | 384 | 34.52 ms | 319 | 58.19 ms | 42 | 453.47 ms | |
@@datadir/mysql.ibd | 619 | 538.37 ms | 367 | 89.44 ms | 208 | 8.52 ms | 44 | 440.41 ms | |
@@datadir/undo_001 | 751 | 523.01 ms | 388 | 67.75 ms | 320 | 12.77 ms | 43 | 442.49 ms | |
@@datadir/binlog.000008 | 54 | 395.92 ms | 0 | 0 ps | 26 | 5.53 ms | 28 | 390.39 ms | |
@@datadir/ib_logfile0 | 61 | 384.10 ms | 6 | 733.10 us | 26 | 1.31 ms | 29 | 382.05 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/BD2/pedidos.ibd | 21 | 118.01 ms | 0 | 0 ps | 10 | 815.41 us | 11 | 117.19 ms | |
@@datadir/#innodb_temp/temp_10.ibt | 14 | 93.13 ms | 0 | 0 ps | 7 | 451.05 us | 7 | 92.68 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/test/contact@002dform.ibd | 13 | 84.27 ms | 0 | 0 ps | 7 | 120.79 us | 6 | 84.15 ms | |
@@datadir/BD2/oficina.ibd | 17 | 57.20 ms | 0 | 0 ps | 8 | 436.10 us | 9 | 56.77 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 | |
@@datadir/#innodb_temp/temp_6.ibt | 8 | 33.38 ms | 0 | 0 ps | 3 | 235.98 us | 5 | 33.15 ms |
|