Mysql db got corrupted

[Dejavu]

On one of my sites, one of the tables got corrupted. 2nd time now in a short while this happened. First time took me forever to figure out the problem and fix it (If you ever get a message tablename.myi error or similar, this means the tables are corrupt, and a simple repair table tablename fix it)

Anyhow do anyone have any ideas why this might have happened? Will moving the site to another server help improve the situation?
thanks

[digitalpoint]

Did mysqld crash? What's the uptime on the mysqld process?

[Dejavu]

How do I check that? (I'm on shared hosting)

[digitalpoint]

If you have access to phpmyadmin, go to "Show MySQL runtime information", the first line will tell you how long the server has been running.

[Dejavu]

The only option I see is 'Show processes', and it gives me the following
Show Full Queries ID User Host Database Command Time Status SQL query
Kill 8694 onlylyri localhost None Query 0 --- SHOW PROCESSLIST

The server load is going from 2.2 to 4.5. I noticed earlier that tomcat failed - I dont even really know what that means.

[digitalpoint]

It would be on the main screen of phpmyadmin. If you don't have access to that, run this query on the server:SHOW STATUS LIKE 'Uptime'; and look at the record it returns (it will be uptime in seconds).

[Dejavu]

Uptime 7108

[digitalpoint]

Yeah... looks like either the server crashed or was rebooted hard without shutting down mysqld (or at the very least the mysqld process) since it's only been up 1 hour, 58 minutes.

[Dejavu]

Thanks, looks like it the hosts problem after all (this was not the first time). I think I will be moving the site to another host.