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 | 1168 | 7.42 s | 2 | 734.69 us | 715 | 134.44 ms | 451 | 7.29 s | |
@@datadir/ibdata1 | 352 | 2.56 s | 20 | 5.58 ms | 168 | 13.15 ms | 164 | 2.54 s | |
@@datadir/ib_logfile0 | 155 | 1.06 s | 6 | 388.96 us | 73 | 3.71 ms | 76 | 1.05 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 | 981 | 804.54 ms | 423 | 89.24 ms | 465 | 9.62 ms | 93 | 705.68 ms | |
@@datadir/undo_002 | 808 | 784.86 ms | 384 | 28.00 ms | 348 | 6.65 ms | 76 | 750.21 ms | |
@@datadir/undo_001 | 789 | 773.71 ms | 388 | 27.33 ms | 327 | 11.41 ms | 74 | 734.97 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/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 | |
@@datadir/GA/Staff.ibd | 6 | 38.68 ms | 0 | 0 ps | 2 | 83.52 us | 4 | 38.60 ms |
|