Incorrect key file for table ‘./conntrack/2016@002d12@002d16.MYI’; try to repair it
If you see the above error while accessing Connection Tracking Reports in Radius Manager then …
- Make sure you aave plenty of Disk Space. Storage drive should be fast for high load servers preferably SSD or RAID based storage ,
- Plenty of Memory is usually a good idea for DB systems ,
- If its a heavy production server, try to move
connection trackingto separate host as it takes lots of space and it adds good amount of payload to the CPU as well.
- Perform tuning to enhance the mysql engine
To repair table …
Goto the conntrack folder [Ubuntu] cd /var/lib/mysql/conntrack/ service mysql stop # Change the file number as shown in the error myisamchk -r -v -f 2016@002d12@002d16.MYI
Once repair is done, start mysql / restart apache2 services , and test the desired tracking report again.