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 | 1433 | 8904782584368 | 2 | 751255824 | 891 | 322374419664 | 540 | 8581656908880 | |
/var/lib/mysql/ibdata1 | 319 | 2640400212384 | 20 | 11691509280 | 151 | 19926228432 | 148 | 2608782474672 | |
/var/lib/mysql/ib_logfile0 | 121 | 824779148160 | 6 | 482674896 | 56 | 3087924576 | 59 | 821208548688 | |
/var/lib/mysql/undo_001 | 850 | 817210874832 | 389 | 83579619024 | 395 | 25194483600 | 66 | 708436772208 | |
/var/lib/mysql/sakila/staff.ibd | 9 | 793690200336 | 4 | 793544744784 | 0 | 0 | 5 | 145455552 | |
/var/lib/mysql/mysql.ibd | 628 | 703611212832 | 337 | 91525519008 | 213 | 9533306112 | 78 | 602552387712 | |
/var/lib/mysql/undo_002 | 863 | 627053898240 | 384 | 51858487296 | 414 | 26090023872 | 65 | 549105387072 | |
/var/lib/mysql/binlog.000008 | 64 | 491022054336 | 0 | 0 | 31 | 1907358288 | 33 | 489114696048 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 76 | 462817433760 | 0 | 0 | 47 | 2480048736 | 29 | 460337385024 | |
/var/lib/mysql/ibtmp1 | 147 | 251883405312 | 0 | 0 | 143 | 18924324144 | 4 | 232959081168 | |
/var/lib/mysql/db_fpg/produk.ibd | 17 | 84392205744 | 0 | 0 | 8 | 9772696032 | 9 | 74619509712 | |
/var/lib/mysql/db_fpg/tipe.ibd | 13 | 75453472512 | 0 | 0 | 7 | 526752864 | 6 | 74926719648 | |
/var/lib/mysql/students/demo.ibd | 13 | 71915666592 | 0 | 0 | 7 | 6440981184 | 6 | 65474685408 | |
/var/lib/mysql/db_fpg/area.ibd | 13 | 57987292176 | 0 | 0 | 7 | 709856400 | 6 | 57277435776 | |
/var/lib/mysql/db_fpg/bench_lift.ibd | 13 | 57129268944 | 0 | 0 | 7 | 184687008 | 6 | 56944581936 | |
/var/lib/mysql/db_fpg/users.ibd | 13 | 55379725632 | 0 | 0 | 7 | 281541744 | 6 | 55098183888 | |
/var/lib/mysql/db_fpg/hasil_temp.ibd | 13 | 53146455648 | 0 | 0 | 7 | 313022688 | 6 | 52833432960 | |
/var/lib/mysql/#innodb_temp/temp_1.ibt | 8 | 43976088288 | 0 | 0 | 3 | 313790400 | 5 | 43662297888 | |
/var/lib/mysql/#innodb_temp/temp_7.ibt | 8 | 37484001456 | 0 | 0 | 3 | 316123632 | 5 | 37167877824 | |
/var/lib/mysql/#innodb_temp/temp_6.ibt | 8 | 36427376832 | 0 | 0 | 3 | 311410704 | 5 | 36115966128 | |
/var/lib/mysql/#innodb_temp/temp_8.ibt | 8 | 33784925856 | 0 | 0 | 3 | 308320848 | 5 | 33476605008 | |
/var/lib/mysql/#innodb_temp/temp_3.ibt | 8 | 33716061984 | 0 | 0 | 3 | 160818240 | 5 | 33555243744 | |
/var/lib/mysql/#innodb_temp/temp_9.ibt | 8 | 33675210096 | 0 | 0 | 3 | 250370208 | 5 | 33424839888 | |
/var/lib/mysql/#innodb_temp/temp_2.ibt | 8 | 33283525440 | 0 | 0 | 3 | 357552624 | 5 | 32925972816 | |
/var/lib/mysql/#innodb_temp/temp_5.ibt | 8 | 31282239120 | 0 | 0 | 3 | 298586640 | 5 | 30983652480 |
|