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
Copy to Clipboard
1 cd /var/lib/mysql/conntrack
2 service mysql stop
3 myisamchk -r -v -f 2017\@002d06\@002d04.MYI
4 service mysql start
# don’t forgot to change table name
How to repair table[Centos]?
- Go to database folder
Copy to Clipboard
1 cd /var/lib/mysql/conntrack
2 service mysqld stop
3 myisamchk -r -v -f 2017\@002d06\@002d04.MYI
4 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/
Tushar C
A seasoned tech enthusiast, holds the position of CEO at Silent Infotech and serves as the CTO at SpeedBot, an algorithmic trading platform. Renowned internationally as a speaker on emerging technologies, Tushar boasts over a decade of diverse experience in the tech industry. His journey commenced as a developer in a multinational corporation, and he later co-founded Silent Infotech alongside two other members. Tushar's expertise spans a multitude of technologies, including blockchain, AI, Python, Dotnet, and cloud solutions. He leverages his extensive knowledge to deliver a broad spectrum of enterprise solutions to businesses. A true technology master, Tushar excels in managing cloud infrastructure for large-scale enterprises. To learn more about his insights and expertise, connect with him.
Schedule Consultation with Tushar Schedule Now