SELECT * FROM `x$io_global_by_file_by_latency`
|
file | total | total_latency | count_read | read_latency | count_write | write_latency | count_misc | misc_latency | |
---|---|---|---|---|---|---|---|---|---|
/var/lib/mysql/ib_logfile1 | 6094 | 28839182957500 | 2 | 810230610 | 4067 | 1317045665130 | 2025 | 27521327061760 | |
/var/lib/mysql/ibdata1 | 610 | 4812693696320 | 20 | 8713189400 | 305 | 27757696890 | 285 | 4776222810030 | |
/var/lib/mysql/binlog.000008 | 270 | 1825182726820 | 0 | 0 | 145 | 9752346090 | 125 | 1815430380730 | |
/var/lib/mysql/mysql.ibd | 1288 | 1523932110120 | 432 | 188032877420 | 721 | 15745038070 | 135 | 1320154194630 | |
/var/lib/mysql/undo_002 | 1633 | 1354806429910 | 387 | 58451308110 | 1109 | 55365216160 | 137 | 1240989905640 | |
/var/lib/mysql/undo_001 | 1644 | 1214761290020 | 390 | 66717266550 | 1118 | 43434010390 | 136 | 1104610013080 | |
/var/lib/mysql/ib_logfile0 | 177 | 1167049715880 | 6 | 950514190 | 84 | 5271646590 | 87 | 1160827555100 | |
/var/lib/mysql/ibtmp1 | 147 | 351748030900 | 0 | 0 | 143 | 7945880310 | 4 | 343802150590 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 236 | 222104171750 | 0 | 0 | 224 | 4984342070 | 12 | 217119829680 | |
/var/lib/mysql/aeropuerto/Reservas.ibd | 22 | 100544096260 | 0 | 0 | 13 | 379850470 | 9 | 100164245790 | |
/var/lib/mysql/#innodb_temp/temp_3.ibt | 8 | 83285095700 | 0 | 0 | 3 | 72147840 | 5 | 83212947860 | |
/var/lib/mysql/aeropuerto/Vuelos.ibd | 15 | 68332295270 | 0 | 0 | 8 | 297609840 | 7 | 68034685430 | |
/var/lib/mysql/aeropuerto/Tripulantes.ibd | 6 | 68139658290 | 0 | 0 | 2 | 200268980 | 4 | 67939389310 | |
/var/lib/mysql/#innodb_temp/temp_7.ibt | 8 | 66925184490 | 0 | 0 | 3 | 377712980 | 5 | 66547471510 | |
/var/lib/mysql/aeropuerto/Pasajeros.ibd | 15 | 64420057340 | 0 | 0 | 8 | 352214150 | 7 | 64067843190 | |
/var/lib/mysql/aeropuerto/Vuelo_Aerolinea.ibd | 8 | 61254628630 | 0 | 0 | 2 | 399392100 | 6 | 60855236530 | |
/var/lib/mysql/aeropuerto/Aviones.ibd | 13 | 60583162620 | 0 | 0 | 7 | 383295470 | 6 | 60199867150 | |
/var/lib/mysql/#innodb_temp/temp_4.ibt | 8 | 59374811910 | 0 | 0 | 3 | 105080980 | 5 | 59269730930 | |
/var/lib/mysql/#innodb_temp/temp_9.ibt | 8 | 56675723310 | 0 | 0 | 3 | 175990740 | 5 | 56499732570 | |
/var/lib/mysql/#innodb_temp/temp_8.ibt | 8 | 56230087120 | 0 | 0 | 3 | 331375080 | 5 | 55898712040 | |
/var/lib/mysql/#innodb_temp/temp_1.ibt | 8 | 55654673010 | 0 | 0 | 3 | 69440600 | 5 | 55585232410 | |
/var/lib/mysql/aeropuerto/Vuelo_Tripulante.ibd | 8 | 53363301750 | 0 | 0 | 2 | 53617450 | 6 | 53309684300 | |
/var/lib/mysql/#innodb_temp/temp_5.ibt | 8 | 51835868250 | 0 | 0 | 3 | 126773350 | 5 | 51709094900 | |
/var/lib/mysql/#innodb_temp/temp_2.ibt | 8 | 49067318380 | 0 | 0 | 3 | 101770600 | 5 | 48965547780 | |
/var/lib/mysql/aeropuerto/Aerolineas.ibd | 6 | 47831136310 | 0 | 0 | 2 | 206910940 | 4 | 47624225370 |
|