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 | 4057 | 20263441781130 | 2 | 810230610 | 2643 | 861719239740 | 1412 | 19400912310780 | |
/var/lib/mysql/ibdata1 | 540 | 4247080165590 | 20 | 8713189400 | 266 | 21427954590 | 254 | 4216939021600 | |
/var/lib/mysql/undo_002 | 1329 | 1129389900730 | 387 | 58451308110 | 825 | 41699741210 | 117 | 1029238851410 | |
/var/lib/mysql/binlog.000008 | 160 | 1092194997340 | 0 | 0 | 90 | 8415812760 | 70 | 1083779184580 | |
/var/lib/mysql/mysql.ibd | 1016 | 1058403137560 | 432 | 188032877420 | 470 | 11817963850 | 114 | 858552296290 | |
/var/lib/mysql/ib_logfile0 | 163 | 1048303515330 | 6 | 950514190 | 77 | 4515061520 | 80 | 1042837939620 | |
/var/lib/mysql/undo_001 | 1332 | 1040226717070 | 389 | 66281687110 | 827 | 32523372090 | 116 | 941421657870 | |
/var/lib/mysql/food@002esql/items.ibd | 59 | 518101630910 | 0 | 0 | 30 | 1127113370 | 29 | 516974517540 | |
/var/lib/mysql/ibtmp1 | 147 | 351748030900 | 0 | 0 | 143 | 7945880310 | 4 | 343802150590 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 199 | 171897165220 | 0 | 0 | 189 | 2592792330 | 10 | 169304372890 | |
/var/lib/mysql/aeropuerto/Reservas.ibd | 21 | 144692327230 | 0 | 0 | 12 | 4740886040 | 9 | 139951441190 | |
/var/lib/mysql/food@002esql/wallet.ibd | 20 | 127799739520 | 0 | 0 | 9 | 5127367870 | 11 | 122672371650 | |
/var/lib/mysql/food@002esql/order_details.ibd | 21 | 118257019030 | 0 | 0 | 10 | 406868810 | 11 | 117850150220 | |
/var/lib/mysql/food@002esql/users.ibd | 19 | 114635902150 | 0 | 0 | 9 | 494331000 | 10 | 114141571150 | |
/var/lib/mysql/food@002esql/wallet_details.ibd | 19 | 102555536890 | 0 | 0 | 9 | 529154120 | 10 | 102026382770 | |
/var/lib/mysql/food@002esql/ticket_details.ibd | 19 | 100958535060 | 0 | 0 | 9 | 426548240 | 10 | 100531986820 | |
/var/lib/mysql/food@002esql/orders.ibd | 20 | 99862575620 | 0 | 0 | 9 | 186551520 | 11 | 99676024100 | |
/var/lib/mysql/aeropuerto/Vuelo_Aerolinea.ibd | 18 | 99218924540 | 0 | 0 | 10 | 4585451350 | 8 | 94633473190 | |
/var/lib/mysql/nota@0020belanja/nota_belanja.ibd | 13 | 88367997100 | 0 | 0 | 7 | 635542080 | 6 | 87732455020 | |
/var/lib/mysql/aeropuerto/Vuelo_Tripulante.ibd | 15 | 87368804000 | 0 | 0 | 8 | 4810507370 | 7 | 82558296630 | |
/var/lib/mysql/aeropuerto/Pasajeros.ibd | 18 | 85789256130 | 0 | 0 | 10 | 579768060 | 8 | 85209488070 | |
/var/lib/mysql/#innodb_temp/temp_3.ibt | 8 | 83285095700 | 0 | 0 | 3 | 72147840 | 5 | 83212947860 | |
/var/lib/mysql/login/coba1.ibd | 13 | 80417179310 | 0 | 0 | 7 | 242918080 | 6 | 80174261230 | |
/var/lib/mysql/aeropuerto/Vuelos.ibd | 18 | 78892688370 | 0 | 0 | 10 | 165756440 | 8 | 78726931930 | |
/var/lib/mysql/food@002esql/tickets.ibd | 17 | 76777809230 | 0 | 0 | 8 | 193422440 | 9 | 76584386790 |
|