DMA Radius : How to repair “Incorrect key file for table ‘./conntrack/xxxx@xxxxxx@xxxxxx.MYI’”

Some times if your production server goes down due to power failure you might face below error while accessing “Connection Tracking Reports” in Radius manager.

Incorrect key file for table ‘./conntrack/2017@002d06@002d04.MYI’. try to repair it

Follow below mentioned steps to resolve issue.

How to repair table[Ubuntu]?

Go to database folder

cd /var/lib/mysql/conntrack
service mysql stop
myisamchk -r -v -f 2017\@002d06\@002d04.MYI
service mysql start

# don’t forgot to change table name

How to repair table[Centos]?

Go to database folder

cd /var/lib/mysql/conntrack
service mysqld stop
myisamchk -r -v -f 2017\@002d06\@002d04.MYI
service mysqld start

# don’t forgot to change table name

Recommendations

  • Use SSD or RAID based storage for faster IO and make sure you have plenty of disk space.
  • Use separate host for Connection Tracking database for better performance
  • Follow mysql performance tuning guide line https://www.mysql.com/why-mysql/performance/

LEAVE A COMMENT