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 | 2108 | 11.74 s | 2 | 714.14 us | 1338 | 922.12 ms | 768 | 10.81 s | |
@@datadir/ibdata1 | 433 | 3.23 s | 20 | 7.20 ms | 211 | 19.55 ms | 202 | 3.21 s | |
@@datadir/ib_logfile0 | 179 | 1.25 s | 6 | 586.78 us | 85 | 4.49 ms | 88 | 1.25 s | |
@@datadir/mysql.ibd | 992 | 1.04 s | 413 | 123.71 ms | 466 | 13.36 ms | 113 | 900.19 ms | |
@@datadir/undo_001 | 1051 | 832.94 ms | 388 | 66.02 ms | 577 | 21.26 ms | 86 | 745.66 ms | |
@@datadir/undo_002 | 1009 | 786.39 ms | 386 | 36.43 ms | 537 | 27.77 ms | 86 | 722.18 ms | |
@@datadir/binlog.000008 | 100 | 692.98 ms | 0 | 0 ps | 49 | 3.11 ms | 51 | 689.86 ms | |
@@datadir/#innodb_temp/temp_10.ibt | 108 | 545.91 ms | 0 | 0 ps | 81 | 49.75 ms | 27 | 496.15 ms | |
@@datadir/ibtmp1 | 147 | 310.19 ms | 0 | 0 ps | 143 | 25.21 ms | 4 | 284.98 ms | |
@@datadir/Emon41192/Classes.ibd | 19 | 143.68 ms | 0 | 0 ps | 10 | 610.17 us | 9 | 143.07 ms | |
@@datadir/Emon41192/Enrollments.ibd | 21 | 105.57 ms | 0 | 0 ps | 12 | 517.72 us | 9 | 105.05 ms | |
@@datadir/ParkVerleihDB/VerleihVorg@0knge.ibd | 19 | 98.54 ms | 0 | 0 ps | 9 | 244.93 us | 10 | 98.30 ms | |
@@datadir/ParkVerleihDB/Fahrzeuge.ibd | 17 | 94.26 ms | 0 | 0 ps | 8 | 416.78 us | 9 | 93.84 ms | |
@@datadir/Emon41192/Trainers.ibd | 15 | 91.20 ms | 0 | 0 ps | 8 | 705.86 us | 7 | 90.50 ms | |
@@datadir/gestion_Inscriptions/Filieres.ibd | 13 | 83.46 ms | 0 | 0 ps | 7 | 120.26 us | 6 | 83.33 ms | |
@@datadir/it/Users.ibd | 15 | 74.47 ms | 0 | 0 ps | 8 | 135.18 us | 7 | 74.34 ms | |
@@datadir/Emon41192/Members.ibd | 15 | 68.19 ms | 0 | 0 ps | 8 | 518.65 us | 7 | 67.67 ms | |
@@datadir/kL/Etudiants.ibd | 13 | 59.98 ms | 0 | 0 ps | 7 | 283.49 us | 6 | 59.70 ms | |
@@datadir/gestion_Inscriptions/Etudiants.ibd | 13 | 59.25 ms | 0 | 0 ps | 7 | 255.02 us | 6 | 59.00 ms | |
@@datadir/studentinfo/reg.ibd | 13 | 58.39 ms | 0 | 0 ps | 7 | 158.21 us | 6 | 58.23 ms | |
@@datadir/ParkVerleihDB/Kunden.ibd | 13 | 51.60 ms | 0 | 0 ps | 7 | 447.04 us | 6 | 51.16 ms | |
@@datadir/ParkVerleihDB/Verleihstandorte.ibd | 13 | 51.41 ms | 0 | 0 ps | 7 | 334.40 us | 6 | 51.08 ms | |
@@datadir/#innodb_temp/temp_8.ibt | 8 | 50.14 ms | 0 | 0 ps | 3 | 394.64 us | 5 | 49.75 ms | |
@@datadir/#innodb_temp/temp_6.ibt | 8 | 47.50 ms | 0 | 0 ps | 3 | 521.42 us | 5 | 46.98 ms | |
@@datadir/#innodb_temp/temp_5.ibt | 8 | 47.06 ms | 0 | 0 ps | 3 | 270.93 us | 5 | 46.79 ms |
|