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 | 523 | 2.72 s | 2 | 898.60 us | 333 | 75.54 ms | 188 | 2.65 s | |
@@datadir/ibdata1 | 140 | 1.12 s | 20 | 12.78 ms | 60 | 8.63 ms | 60 | 1.10 s | |
@@datadir/mysql.ibd | 519 | 507.82 ms | 310 | 93.90 ms | 171 | 10.74 ms | 38 | 403.18 ms | |
@@datadir/ib_logfile0 | 59 | 380.46 ms | 6 | 758.17 us | 25 | 2.06 ms | 28 | 377.64 ms | |
@@datadir/binlog.000008 | 46 | 334.26 ms | 0 | 0 ps | 22 | 996.62 us | 24 | 333.26 ms | |
@@datadir/undo_002 | 548 | 315.04 ms | 384 | 56.48 ms | 139 | 10.67 ms | 25 | 247.89 ms | |
@@datadir/undo_001 | 579 | 298.29 ms | 388 | 73.15 ms | 165 | 4.47 ms | 26 | 220.67 ms | |
@@datadir/ibtmp1 | 147 | 268.75 ms | 0 | 0 ps | 143 | 25.22 ms | 4 | 243.53 ms | |
@@datadir/#innodb_temp/temp_10.ibt | 17 | 103.17 ms | 0 | 0 ps | 9 | 615.08 us | 8 | 102.56 ms | |
@@datadir/StudioMedicoSportivo/Posizione.ibd | 15 | 91.68 ms | 0 | 0 ps | 8 | 533.91 us | 7 | 91.14 ms | |
@@datadir/StudioMedicoSportivo/Sport.ibd | 14 | 75.76 ms | 0 | 0 ps | 7 | 235.34 us | 7 | 75.53 ms | |
@@datadir/StudioMedicoSportivo/Visita.ibd | 17 | 72.16 ms | 0 | 0 ps | 9 | 639.79 us | 8 | 71.52 ms | |
@@datadir/StudioMedicoSportivo/Atleta.ibd | 15 | 72.10 ms | 0 | 0 ps | 8 | 660.65 us | 7 | 71.44 ms | |
@@datadir/StudioMedicoSportivo/Dottore.ibd | 18 | 62.62 ms | 0 | 0 ps | 10 | 550.11 us | 8 | 62.07 ms | |
@@datadir/TOUR2010/EQUIPE.ibd | 13 | 54.73 ms | 0 | 0 ps | 7 | 405.51 us | 6 | 54.32 ms | |
@@datadir/LA@0020GUNS/albumy.ibd | 13 | 53.31 ms | 0 | 0 ps | 7 | 149.27 us | 6 | 53.16 ms | |
@@datadir/#innodb_temp/temp_2.ibt | 8 | 50.54 ms | 0 | 0 ps | 3 | 292.53 us | 5 | 50.25 ms | |
@@datadir/#innodb_temp/temp_1.ibt | 8 | 42.42 ms | 0 | 0 ps | 3 | 284.11 us | 5 | 42.13 ms | |
@@datadir/#innodb_temp/temp_3.ibt | 8 | 38.51 ms | 0 | 0 ps | 3 | 242.27 us | 5 | 38.27 ms | |
@@datadir/#innodb_temp/temp_8.ibt | 8 | 36.65 ms | 0 | 0 ps | 3 | 222.47 us | 5 | 36.42 ms | |
@@datadir/#innodb_temp/temp_6.ibt | 8 | 35.94 ms | 0 | 0 ps | 3 | 240.30 us | 5 | 35.70 ms | |
@@datadir/#innodb_temp/temp_5.ibt | 8 | 35.64 ms | 0 | 0 ps | 3 | 275.35 us | 5 | 35.37 ms | |
@@datadir/#innodb_temp/temp_4.ibt | 8 | 35.61 ms | 0 | 0 ps | 3 | 254.94 us | 5 | 35.35 ms | |
@@datadir/#innodb_temp/temp_9.ibt | 8 | 33.42 ms | 0 | 0 ps | 3 | 222.73 us | 5 | 33.20 ms | |
@@datadir/#innodb_temp/temp_7.ibt | 8 | 33.34 ms | 0 | 0 ps | 3 | 217.32 us | 5 | 33.12 ms |
|