locked processes: cause?

[Anon]

I am having problems with MySQL processes locking up on me. If someone doesn't constantly monitor the machine, then it will lock up so bad that it needs to be rebooted. Does anyone know the cause of a MySQL process locking? what can I do to prevent it?

my web host admin tells me that I need to write "flood control" into my code, so that a user can't crash the server by clicking multiple links in a row. I think that's hogwash, but I am willing to concede that it might be something I can prevent. any hints?

[Anon]

thanks anyway, but I think I've found it.

apparently, MySQL's new (beta) FULLTEXT searching is to blame. I'd submit a bug report, but it's not that important to me. If anyone wants a sample data set and query to blow it up so that you can build a formal test case, e-mail me and I'll give it to you.