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
Copy to Clipboard

# don’t forgot to change table name

How to repair table[Centos]?

  • Go to database folder
Copy to Clipboard

# 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/
By |2019-12-13T12:07:02+00:00June 4th, 2017|Radius Server|Comments Off on DMA Radius : How to repair “Incorrect key file for table ‘./conntrack/xxxx@xxxxxx@xxxxxx.MYI’”

About the Author:

Comments are closed.