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 | 926 | 5.70 s | 2 | 893.10 us | 567 | 167.61 ms | 357 | 5.53 s | |
@@datadir/ibdata1 | 258 | 1.86 s | 20 | 12.58 ms | 121 | 10.35 ms | 117 | 1.84 s | |
@@datadir/mysql.ibd | 810 | 1.47 s | 412 | 88.47 ms | 331 | 5.19 ms | 67 | 1.38 s | |
@@datadir/ib_logfile0 | 121 | 774.21 ms | 6 | 714.08 us | 56 | 4.57 ms | 59 | 768.93 ms | |
@@datadir/undo_001 | 775 | 600.11 ms | 388 | 61.09 ms | 330 | 5.58 ms | 57 | 533.44 ms | |
@@datadir/undo_002 | 739 | 538.22 ms | 384 | 35.23 ms | 304 | 5.90 ms | 51 | 497.09 ms | |
@@datadir/binlog.000008 | 40 | 278.83 ms | 0 | 0 ps | 19 | 1.62 ms | 21 | 277.21 ms | |
@@datadir/ibtmp1 | 147 | 263.98 ms | 0 | 0 ps | 143 | 8.84 ms | 4 | 255.14 ms | |
@@datadir/#innodb_temp/temp_10.ibt | 56 | 233.77 ms | 0 | 0 ps | 46 | 90.54 ms | 10 | 143.23 ms | |
@@datadir/database_film/genre_film.ibd | 13 | 76.78 ms | 0 | 0 ps | 7 | 146.18 us | 6 | 76.63 ms | |
@@datadir/database_film/rating.ibd | 13 | 73.41 ms | 0 | 0 ps | 7 | 158.13 us | 6 | 73.26 ms | |
@@datadir/#innodb_temp/temp_1.ibt | 8 | 70.44 ms | 0 | 0 ps | 3 | 282.96 us | 5 | 70.16 ms | |
@@datadir/database_film/film.ibd | 13 | 70.20 ms | 0 | 0 ps | 7 | 97.38 us | 6 | 70.10 ms | |
@@datadir/Sakshii/login@0020page.ibd | 15 | 67.25 ms | 0 | 0 ps | 8 | 146.64 us | 7 | 67.11 ms | |
@@datadir/database_film/user.ibd | 13 | 66.94 ms | 0 | 0 ps | 7 | 236.33 us | 6 | 66.71 ms | |
@@datadir/mysql/EMPLOYEES.ibd | 13 | 65.19 ms | 0 | 0 ps | 7 | 206.23 us | 6 | 64.98 ms | |
@@datadir/mysql/DEPARTMENT.ibd | 13 | 62.65 ms | 0 | 0 ps | 7 | 464.60 us | 6 | 62.19 ms | |
@@datadir/database_film/genre.ibd | 13 | 53.50 ms | 0 | 0 ps | 7 | 162.96 us | 6 | 53.34 ms | |
@@datadir/#innodb_temp/temp_6.ibt | 8 | 53.08 ms | 0 | 0 ps | 3 | 121.01 us | 5 | 52.96 ms | |
@@datadir/#innodb_temp/temp_2.ibt | 8 | 49.73 ms | 0 | 0 ps | 3 | 252.51 us | 5 | 49.48 ms | |
@@datadir/#innodb_temp/temp_3.ibt | 8 | 48.66 ms | 0 | 0 ps | 3 | 178.75 us | 5 | 48.49 ms | |
@@datadir/#innodb_temp/temp_7.ibt | 8 | 38.52 ms | 0 | 0 ps | 3 | 176.71 us | 5 | 38.34 ms | |
@@datadir/#innodb_temp/temp_9.ibt | 8 | 34.60 ms | 0 | 0 ps | 3 | 336.41 us | 5 | 34.26 ms | |
@@datadir/#innodb_temp/temp_8.ibt | 8 | 33.48 ms | 0 | 0 ps | 3 | 278.66 us | 5 | 33.21 ms | |
@@datadir/#innodb_temp/temp_4.ibt | 8 | 30.04 ms | 0 | 0 ps | 3 | 78.48 us | 5 | 29.96 ms |
|