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 | 1744 | 9.28 s | 2 | 907.08 us | 1079 | 235.01 ms | 663 | 9.05 s | |
@@datadir/ibdata1 | 465 | 3.83 s | 20 | 6.02 ms | 225 | 18.35 ms | 220 | 3.81 s | |
@@datadir/ib_logfile0 | 201 | 1.45 s | 6 | 822.07 us | 96 | 3.50 ms | 99 | 1.44 s | |
@@datadir/undo_001 | 1070 | 976.76 ms | 388 | 68.86 ms | 589 | 11.93 ms | 93 | 895.97 ms | |
@@datadir/undo_002 | 1006 | 914.18 ms | 385 | 37.39 ms | 536 | 25.21 ms | 85 | 851.58 ms | |
@@datadir/mysql.ibd | 807 | 899.68 ms | 402 | 102.47 ms | 294 | 7.85 ms | 111 | 789.36 ms | |
@@datadir/binlog.000008 | 58 | 446.85 ms | 0 | 0 ps | 28 | 2.13 ms | 30 | 444.72 ms | |
@@datadir/#innodb_temp/temp_10.ibt | 71 | 426.05 ms | 0 | 0 ps | 46 | 1.99 ms | 25 | 424.06 ms | |
@@datadir/ibtmp1 | 147 | 237.23 ms | 0 | 0 ps | 143 | 28.82 ms | 4 | 208.41 ms | |
@@datadir/PROVA/articoliordini.ibd | 23 | 162.99 ms | 0 | 0 ps | 13 | 589.89 us | 10 | 162.40 ms | |
@@datadir/mysql/student_regi.ibd | 13 | 88.02 ms | 0 | 0 ps | 7 | 410.86 us | 6 | 87.61 ms | |
@@datadir/PROVA/ordini.ibd | 17 | 75.69 ms | 0 | 0 ps | 8 | 570.88 us | 9 | 75.12 ms | |
@@datadir/PROVA/utenti.ibd | 13 | 63.02 ms | 0 | 0 ps | 7 | 560.46 us | 6 | 62.46 ms | |
@@datadir/schoolappapi/students.ibd | 13 | 48.19 ms | 0 | 0 ps | 7 | 212.71 us | 6 | 47.98 ms | |
@@datadir/#innodb_temp/temp_7.ibt | 8 | 47.87 ms | 0 | 0 ps | 3 | 143.10 us | 5 | 47.73 ms | |
@@datadir/#innodb_temp/temp_2.ibt | 8 | 47.47 ms | 0 | 0 ps | 3 | 241.58 us | 5 | 47.23 ms | |
@@datadir/#innodb_temp/temp_1.ibt | 8 | 45.75 ms | 0 | 0 ps | 3 | 304.99 us | 5 | 45.44 ms | |
@@datadir/#innodb_temp/temp_5.ibt | 8 | 44.93 ms | 0 | 0 ps | 3 | 98.41 us | 5 | 44.83 ms | |
@@datadir/PROVA/articoli.ibd | 13 | 44.13 ms | 0 | 0 ps | 7 | 197.36 us | 6 | 43.93 ms | |
@@datadir/#innodb_temp/temp_4.ibt | 8 | 39.53 ms | 0 | 0 ps | 3 | 84.74 us | 5 | 39.45 ms | |
@@datadir/#innodb_temp/temp_3.ibt | 8 | 30.69 ms | 0 | 0 ps | 3 | 97.06 us | 5 | 30.59 ms | |
@@datadir/#innodb_temp/temp_8.ibt | 8 | 30.50 ms | 0 | 0 ps | 3 | 183.52 us | 5 | 30.32 ms | |
@@datadir/#innodb_temp/temp_6.ibt | 8 | 28.05 ms | 0 | 0 ps | 3 | 95.56 us | 5 | 27.96 ms | |
@@datadir/#innodb_temp/temp_9.ibt | 8 | 28.01 ms | 0 | 0 ps | 3 | 128.09 us | 5 | 27.88 ms | |
@@datadir/binlog.index | 13 | 27.16 ms | 3 | 33.85 us | 0 | 0 ps | 10 | 27.13 ms |
|