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 | 2487 | 12317327244288 | 2 | 751128576 | 1616 | 494484642432 | 869 | 11822091473280 | |
/var/lib/mysql/binlog.000008 | 404 | 2554429193184 | 0 | 0 | 208 | 4041142512 | 196 | 2550388050672 | |
/var/lib/mysql/ibdata1 | 172 | 1290829916112 | 20 | 4929573792 | 78 | 5887489344 | 74 | 1280012852976 | |
/var/lib/mysql/mysql.ibd | 604 | 891768717840 | 349 | 80211075120 | 191 | 24010688064 | 64 | 787546954656 | |
/var/lib/mysql/undo_002 | 776 | 648968775312 | 385 | 34005026352 | 323 | 8092538784 | 68 | 606871210176 | |
/var/lib/mysql/undo_001 | 755 | 578439169968 | 388 | 34876281264 | 303 | 12403241664 | 64 | 531159647040 | |
/var/lib/mysql/ib_logfile0 | 51 | 285634635264 | 6 | 389197248 | 21 | 1239812640 | 24 | 284005625376 | |
/var/lib/mysql/ibtmp1 | 147 | 255027332736 | 0 | 0 | 143 | 16468555488 | 4 | 238558777248 | |
/var/lib/mysql/essentialmode/datastore_data.ibd | 32 | 216476524176 | 0 | 0 | 18 | 217809504 | 14 | 216258714672 | |
/var/lib/mysql/essentialmode/addon_inventory_items... | 19 | 137712679104 | 0 | 0 | 10 | 155806992 | 9 | 137556872112 | |
/var/lib/mysql/essentialmode/known_recipes.ibd | 13 | 115369121472 | 0 | 0 | 7 | 13158670800 | 6 | 102210450672 | |
/var/lib/mysql/essentialmode/job_grades.ibd | 17 | 111765875232 | 0 | 0 | 10 | 230889120 | 7 | 111534986112 | |
/var/lib/mysql/essentialmode/addon_account_data.ib... | 17 | 106130344320 | 0 | 0 | 9 | 159254832 | 8 | 105971089488 | |
/var/lib/mysql/essentialmode/twitter_likes.ibd | 17 | 104093235840 | 0 | 0 | 9 | 211315104 | 8 | 103881920736 | |
/var/lib/mysql/essentialmode/baninfo.ibd | 13 | 92873256960 | 0 | 0 | 7 | 132771408 | 6 | 92740485552 | |
/var/lib/mysql/essentialmode/world_storages.ibd | 13 | 89198134080 | 0 | 0 | 7 | 6523596288 | 6 | 82674537792 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 20 | 88066163328 | 0 | 0 | 12 | 406945968 | 8 | 87659217360 | |
/var/lib/mysql/essentialmode/addon_account.ibd | 15 | 87780174240 | 0 | 0 | 7 | 159478176 | 8 | 87620696064 | |
/var/lib/mysql/essentialmode/datastore.ibd | 13 | 85659142272 | 0 | 0 | 7 | 200706000 | 6 | 85458436272 | |
/var/lib/mysql/essentialmode/phone_calls.ibd | 13 | 85282229472 | 0 | 0 | 7 | 5267154288 | 6 | 80015075184 | |
/var/lib/mysql/essentialmode/crew_phone_news.ibd | 14 | 82417750800 | 0 | 0 | 7 | 194279184 | 7 | 82223471616 | |
/var/lib/mysql/essentialmode/twitter_accounts.ibd | 15 | 81298514880 | 0 | 0 | 8 | 144399024 | 7 | 81154115856 | |
/var/lib/mysql/essentialmode/bwh_bans.ibd | 13 | 80961259104 | 0 | 0 | 7 | 209769120 | 6 | 80751489984 | |
/var/lib/mysql/essentialmode/yellowpages_posts.ibd | 15 | 77808454944 | 0 | 0 | 8 | 87935760 | 7 | 77720519184 | |
/var/lib/mysql/essentialmode/billing.ibd | 13 | 76926196512 | 0 | 0 | 7 | 4156594464 | 6 | 72769602048 |
|