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 | 1393 | 7.22 s | 2 | 831.96 us | 901 | 251.59 ms | 490 | 6.96 s | |
@@datadir/ibdata1 | 186 | 1.42 s | 20 | 11.36 ms | 84 | 8.01 ms | 82 | 1.40 s | |
@@datadir/undo_002 | 738 | 530.67 ms | 384 | 34.52 ms | 313 | 58.14 ms | 41 | 438.01 ms | |
@@datadir/mysql.ibd | 585 | 518.56 ms | 366 | 89.06 ms | 176 | 8.36 ms | 43 | 421.13 ms | |
@@datadir/undo_001 | 745 | 503.31 ms | 388 | 67.75 ms | 315 | 12.70 ms | 42 | 422.86 ms | |
@@datadir/binlog.000008 | 52 | 381.14 ms | 0 | 0 ps | 25 | 5.52 ms | 27 | 375.62 ms | |
@@datadir/ib_logfile0 | 59 | 369.94 ms | 6 | 733.10 us | 25 | 1.27 ms | 28 | 367.93 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/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/#innodb_temp/temp_10.ibt | 11 | 69.49 ms | 0 | 0 ps | 5 | 391.73 us | 6 | 69.09 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 | |
@@datadir/#innodb_temp/temp_9.ibt | 8 | 32.67 ms | 0 | 0 ps | 3 | 290.98 us | 5 | 32.38 ms |
|