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 | 5385 | 26007535701312 | 2 | 776972592 | 3558 | 934000521168 | 1825 | 25072758207552 | |
/var/lib/mysql/ibdata1 | 570 | 4296990234768 | 20 | 5530275168 | 287 | 25018058736 | 263 | 4266441900864 | |
/var/lib/mysql/binlog.000008 | 318 | 2261385626016 | 0 | 0 | 158 | 5107374624 | 160 | 2256278251392 | |
/var/lib/mysql/mysql.ibd | 1505 | 1601950984128 | 435 | 141835217040 | 912 | 38405262192 | 158 | 1421710504896 | |
/var/lib/mysql/ib_logfile0 | 223 | 1440379095408 | 6 | 397277760 | 107 | 3557020368 | 110 | 1436424797280 | |
/var/lib/mysql/undo_002 | 1529 | 1281246874512 | 386 | 32981321472 | 1010 | 28692050112 | 133 | 1219573502928 | |
/var/lib/mysql/undo_001 | 1552 | 1201001007360 | 389 | 52202367360 | 1030 | 31432799904 | 133 | 1117365840096 | |
/var/lib/mysql/#innodb_temp/temp_10.ibt | 337 | 1146806962224 | 0 | 0 | 289 | 280015274880 | 48 | 866791687344 | |
/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/Consultorio/Factura.ibd | 15 | 93699786048 | 0 | 0 | 8 | 191738448 | 7 | 93508047600 | |
/var/lib/mysql/Consultorio/Cita.ibd | 17 | 91673254992 | 0 | 0 | 9 | 240203040 | 8 | 91433051952 | |
/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 |
|