SQL tables crash and need to be repaired

[bWolfie 138]

Hi,

 

Few things.

- Using CentOS 6.

- Server is live.

- It has around 100 players on it.

- The issues started around 20 October.

 

It starts like this. An error will pop up in the console, something like this.

161021  1:40:14 [ERROR] /usr/libexec/mysqld: Incorrect key file for table './hercuser_rag/skill.MYI'; try to repair it

And then usually anywhere from 1-12 hours later, the table itself crashes and needs to be repaired. This results in players losing skills and us [server admins] needing to do emergency maintenance.

161021 11:45:55 [ERROR] /usr/libexec/mysqld: Table './hercuser_rag/skill' is marked as crashed and should be repaired

Does anybody know what could be causing this? We don't know where to look for logs other than /var/log/mysqld.log

We've had to take the server down indefinitely until we can solve it.

 

Please help.

[4144 364]

you must repair all corrupted tables. This can happened because server failure. Probably power loss or reset.

For recover tables use sql commands like:

 

repair table skill;