Syed Jahanzaib Personal Blog to Share Knowledge !

December 19, 2016

Incorrect key file for table ‘./conntrack/xxxx@xxxxxx@xxxxxx.MYI’; try to repair it

Filed under: Radius Manager, Uncategorized — Tags: , , — Syed Jahanzaib / Pinochio~:) @ 1:05 PM

corruption

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 …

Recommendations:

  • 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 tracking to 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.

Regard’s
~Syed Jahanzaib~

Advertisements

5 Comments »

  1. sir g, i have an issue in mikrotik routerboard, how i will block browsec vpn through layer 7 protocol, please help me

    Like

    Comment by ihsan — December 21, 2016 @ 3:39 PM

  2. hello Dear Syed,

    my Radius manager not showing the connections why ?
    i’m using pppoe
    thank you

    Like

    Comment by Hassan — December 26, 2016 @ 3:36 PM

  3. Hi,

    “If its a heavy production server, try to move connection tracking to separate host as it takes lots of space and it adds good amount of payload to the CPU as well.”

    So for a long time I wanted to setup a separate conntrac server for my RM. Can you please publish an article for this.

    Like

    Comment by Anupam Pradhan — January 10, 2017 @ 4:14 PM

  4. Thanks issue resolved with this
    I just ant to know the reason,,can it be because i backup the DB using mysqldump??

    Like

    Comment by Fahad Sabir — October 11, 2017 @ 12:32 PM


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: