What causes mysql 145 error?

[taiwanho]

I am getting the accursed: 1016 Can't open file: 'phpbb_topics.MYI' (errno: 145)

It's easy to fix through phpmyadmin as other threads have stated, but the error is recurring, at least every day, and now driving me nuts.

So I wonder if anyone knows the cause. What is corrupting the table? Has anyone else had this experience?

[jatar_k]

I have had similar problems with phpbb, not really sure of the cause, I think we had issues with too few connections/high load and corruption connected with that and once it was switched to a dedicated server it was fine

I used to have to repair tables on a fairly regular basis but can't remember doing ti once the server switch happened.

[taiwanho]

Thanks for the reply.

It's odd as it has been running happily for years. We have plenty of disk space left and the traffic to the site has not increased enough to cause a problem.

Could it be an issue with the version of MySQL? We are using version 4.1.21.

[jatar_k]

no not version, but I am not talking about disk space, more like traffic specifically to mysql, at some point when the number of writes get high enough there will be problems, where that line is depends on the setup

[taiwanho]

There must be mysql traffic that I am not seeing then. The phpbb traffic has not increased, but now I realise there could be an increase on other database I haven't noticed.

Is it possible that an attack on a Wiki search page could cause a spike in traffic? I've just noticed that that table has an error too.

Many thanks for the help by the way.