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 | 5143 | 24713786110464 | 2 | 776972592 | 3406 | 903648627552 | 1735 | 23809360510320 | |
/var/lib/mysql/ibdata1 | 512 | 3817057395360 | 20 | 5530275168 | 257 | 23519935824 | 235 | 3788007184368 | |
/var/lib/mysql/binlog.000008 | 302 | 2137784640288 | 0 | 0 | 150 | 4977639744 | 152 | 2132807000544 | |
/var/lib/mysql/mysql.ibd | 1420 | 1510731973344 | 435 | 141835217040 | 842 | 37620248160 | 143 | 1331276508144 | |
/var/lib/mysql/undo_002 | 1467 | 1238040052656 | 386 | 32981321472 | 956 | 27841174944 | 125 | 1177217556240 | |
/var/lib/mysql/ib_logfile0 | 193 | 1214132349936 | 6 | 397277760 | 92 | 3207109488 | 95 | 1210527962688 | |
/var/lib/mysql/undo_001 | 1472 | 1137073284336 | 389 | 52202367360 | 962 | 30377140992 | 121 | 1054493775984 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 331 | 1121831669904 | 0 | 0 | 285 | 279875717616 | 46 | 841955952288 | |
/var/lib/mysql/ibtmp1 | 147 | 261101020752 | 0 | 0 | 143 | 13189362384 | 4 | 247911658368 | |
/var/lib/mysql/#innodb_temp/temp_9.ibt | 17 | 236986805088 | 0 | 0 | 9 | 491028384 | 8 | 236495776704 | |
/var/lib/mysql/@0Hulas/bank_accounts.ibd | 27 | 161474998080 | 0 | 0 | 15 | 222096336 | 12 | 161252901744 | |
/var/lib/mysql/@0Hulas/bans.ibd | 20 | 137195738592 | 0 | 0 | 10 | 160462368 | 10 | 137035276224 | |
/var/lib/mysql/@0Hulas/player_houses.ibd | 19 | 131118320784 | 0 | 0 | 10 | 1059972672 | 9 | 130058348112 | |
/var/lib/mysql/@0Hulas/player_outfits.ibd | 17 | 129411169008 | 0 | 0 | 9 | 334801104 | 8 | 129076367904 | |
/var/lib/mysql/@0Hulas/management_funds.ibd | 17 | 126260666400 | 0 | 0 | 9 | 458078544 | 8 | 125802587856 | |
/var/lib/mysql/@0Hulas/player_vehicles.ibd | 20 | 124854691104 | 0 | 0 | 10 | 125482368 | 10 | 124729208736 | |
/var/lib/mysql/@0Hulas/house_plants.ibd | 17 | 120310040928 | 0 | 0 | 9 | 5572666176 | 8 | 114737374752 | |
/var/lib/mysql/@0Hulas/bank_statements.ibd | 20 | 115760039472 | 0 | 0 | 10 | 171735168 | 10 | 115588304304 | |
/var/lib/mysql/@0Hulas/players.ibd | 19 | 114377187408 | 0 | 0 | 10 | 160824576 | 9 | 114216362832 | |
/var/lib/mysql/@0Hulas/apartments.ibd | 17 | 111518024112 | 0 | 0 | 9 | 5083927200 | 8 | 106434096912 | |
/var/lib/mysql/@0Hulas/player_mails.ibd | 15 | 100214793888 | 0 | 0 | 8 | 577221216 | 7 | 99637572672 | |
/var/lib/mysql/@0Hulas/phone_messages.ibd | 17 | 91132777824 | 0 | 0 | 9 | 200859648 | 8 | 90931918176 | |
/var/lib/mysql/@0Hulas/playerskins.ibd | 17 | 90967047600 | 0 | 0 | 9 | 153828048 | 8 | 90813219552 | |
/var/lib/mysql/@0Hulas/houselocations.ibd | 15 | 90907852992 | 0 | 0 | 8 | 370702992 | 7 | 90537150000 | |
/var/lib/mysql/@0Hulas/occasion_vehicles.ibd | 15 | 88004048352 | 0 | 0 | 8 | 195833616 | 7 | 87808214736 |
|