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 | 1590 | 9.90 s | 2 | 836.23 us | 998 | 728.40 ms | 590 | 9.17 s | |
@@datadir/ibdata1 | 365 | 2.83 s | 20 | 5.97 ms | 177 | 21.05 ms | 168 | 2.81 s | |
@@datadir/mysql.ibd | 918 | 1.18 s | 337 | 84.29 ms | 478 | 10.89 ms | 103 | 1.08 s | |
@@datadir/ib_logfile0 | 167 | 1.11 s | 6 | 702.28 us | 79 | 3.11 ms | 82 | 1.11 s | |
@@datadir/binlog.000008 | 126 | 891.71 ms | 0 | 0 ps | 62 | 1.66 ms | 64 | 890.05 ms | |
@@datadir/undo_001 | 871 | 736.03 ms | 388 | 44.62 ms | 413 | 17.25 ms | 70 | 674.16 ms | |
@@datadir/undo_002 | 844 | 711.54 ms | 385 | 34.42 ms | 391 | 11.10 ms | 68 | 666.02 ms | |
@@datadir/ibtmp1 | 147 | 256.32 ms | 0 | 0 ps | 143 | 10.99 ms | 4 | 245.34 ms | |
@@datadir/#innodb_temp/temp_10.ibt | 35 | 235.91 ms | 0 | 0 ps | 21 | 1.08 ms | 14 | 234.83 ms | |
@@datadir/recursos_humanos/Colaboradores.ibd | 45 | 154.37 ms | 0 | 0 ps | 29 | 700.59 us | 16 | 153.67 ms | |
@@datadir/recursos_humanos/Comunas.ibd | 24 | 101.33 ms | 0 | 0 ps | 14 | 4.94 ms | 10 | 96.40 ms | |
@@datadir/recursos_humanos/Historial_Laboral.ibd | 24 | 98.86 ms | 0 | 0 ps | 14 | 450.40 us | 10 | 98.41 ms | |
@@datadir/recursos_humanos/Regiones.ibd | 19 | 96.85 ms | 0 | 0 ps | 10 | 603.88 us | 9 | 96.25 ms | |
@@datadir/recursos_humanos/Departamentos.ibd | 19 | 90.27 ms | 0 | 0 ps | 10 | 308.01 us | 9 | 89.96 ms | |
@@datadir/sakila/actor.ibd | 10 | 86.86 ms | 5 | 86.77 ms | 0 | 0 ps | 5 | 91.59 us | |
@@datadir/javacrud/product_tbl.ibd | 14 | 80.31 ms | 0 | 0 ps | 7 | 319.87 us | 7 | 79.99 ms | |
@@datadir/SIM@002dPER/users.ibd | 13 | 75.91 ms | 0 | 0 ps | 7 | 639.65 us | 6 | 75.27 ms | |
@@datadir/Carrental_daffa/tabel_mobil.ibd | 13 | 66.67 ms | 0 | 0 ps | 7 | 123.06 us | 6 | 66.55 ms | |
@@datadir/TD_Abbreviations/TD_Abbreviations.ibd | 13 | 64.33 ms | 0 | 0 ps | 7 | 512.72 us | 6 | 63.82 ms | |
@@datadir/recursos_humanos/Puestos.ibd | 19 | 61.03 ms | 0 | 0 ps | 10 | 436.84 us | 9 | 60.59 ms | |
@@datadir/Carrental_daffa/tabel_pelanggan.ibd | 13 | 53.15 ms | 0 | 0 ps | 7 | 249.60 us | 6 | 52.90 ms | |
@@datadir/projectCRUD/prod_table.ibd | 13 | 52.15 ms | 0 | 0 ps | 7 | 5.32 ms | 6 | 46.83 ms | |
@@datadir/beasiswa/pendaftar.ibd | 13 | 46.84 ms | 0 | 0 ps | 7 | 713.83 us | 6 | 46.12 ms | |
@@datadir/#innodb_temp/temp_1.ibt | 8 | 43.39 ms | 0 | 0 ps | 3 | 246.42 us | 5 | 43.14 ms | |
@@datadir/#innodb_temp/temp_3.ibt | 8 | 42.55 ms | 0 | 0 ps | 3 | 292.13 us | 5 | 42.26 ms |
|