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 | 1212 | 7.68 s | 2 | 734.69 us | 741 | 140.84 ms | 469 | 7.54 s | |
@@datadir/ibdata1 | 372 | 2.70 s | 20 | 5.58 ms | 178 | 13.87 ms | 174 | 2.68 s | |
@@datadir/ib_logfile0 | 165 | 1.13 s | 6 | 388.96 us | 78 | 3.85 ms | 81 | 1.13 s | |
@@datadir/#innodb_temp/temp_9.ibt | 161 | 1.03 s | 0 | 0 ps | 145 | 690.83 ms | 16 | 339.31 ms | |
@@datadir/mysql.ibd | 1003 | 852.52 ms | 423 | 89.24 ms | 481 | 10.04 ms | 99 | 753.25 ms | |
@@datadir/undo_002 | 830 | 810.03 ms | 384 | 28.00 ms | 366 | 7.04 ms | 80 | 774.99 ms | |
@@datadir/undo_001 | 804 | 805.95 ms | 388 | 27.33 ms | 338 | 11.78 ms | 78 | 766.84 ms | |
@@datadir/sakila/address.ibd | 14 | 730.53 ms | 9 | 730.47 ms | 0 | 0 ps | 5 | 62.44 us | |
@@datadir/#innodb_temp/temp_10.ibt | 281 | 659.08 ms | 0 | 0 ps | 242 | 4.78 ms | 39 | 654.30 ms | |
@@datadir/binlog.000008 | 80 | 627.94 ms | 0 | 0 ps | 39 | 12.59 ms | 41 | 615.35 ms | |
@@datadir/ibtmp1 | 147 | 228.40 ms | 0 | 0 ps | 143 | 11.32 ms | 4 | 217.08 ms | |
@@datadir/mydatabase/ZONE.ibd | 13 | 99.28 ms | 0 | 0 ps | 7 | 266.24 us | 6 | 99.01 ms | |
@@datadir/mydatabase/RPTONE.ibd | 14 | 85.79 ms | 0 | 0 ps | 7 | 251.06 us | 7 | 85.54 ms | |
@@datadir/GA/Staff.ibd | 13 | 82.60 ms | 0 | 0 ps | 7 | 432.78 us | 6 | 82.17 ms | |
@@datadir/partage_de_recettes/users.ibd | 17 | 68.63 ms | 0 | 0 ps | 9 | 348.85 us | 8 | 68.28 ms | |
@@datadir/partage_de_recettes/recipes.ibd | 15 | 68.54 ms | 0 | 0 ps | 8 | 715.37 us | 7 | 67.83 ms | |
@@datadir/mydatabase/RPTFOUR.ibd | 13 | 67.52 ms | 0 | 0 ps | 7 | 162.16 us | 6 | 67.36 ms | |
@@datadir/databese_film/film.ibd | 13 | 65.57 ms | 0 | 0 ps | 7 | 224.46 us | 6 | 65.34 ms | |
@@datadir/mydatabase/RPTTWO.ibd | 13 | 64.49 ms | 0 | 0 ps | 7 | 173.22 us | 6 | 64.32 ms | |
@@datadir/mydatabase/RPTBUDGETSO.ibd | 13 | 62.92 ms | 0 | 0 ps | 7 | 94.67 us | 6 | 62.82 ms | |
@@datadir/mydatabase/RPTTHREE.ibd | 13 | 61.14 ms | 0 | 0 ps | 7 | 152.59 us | 6 | 60.99 ms | |
@@datadir/mydatabase/PAYS.ibd | 13 | 57.54 ms | 0 | 0 ps | 7 | 508.34 us | 6 | 57.03 ms | |
@@datadir/#innodb_temp/temp_1.ibt | 8 | 52.20 ms | 0 | 0 ps | 3 | 83.12 us | 5 | 52.12 ms | |
@@datadir/#innodb_temp/temp_8.ibt | 8 | 41.61 ms | 0 | 0 ps | 3 | 73.18 us | 5 | 41.53 ms | |
@@datadir/#innodb_temp/temp_7.ibt | 8 | 39.63 ms | 0 | 0 ps | 3 | 73.50 us | 5 | 39.56 ms |
|