MySQL Corruption Problem

[Ron Patel]

Hi all,

I have a Web Service that uses a MySQL Database as its storage mechanism.

However, I'm seeing some kind of corruption problem with the database. After not sending anything to the database overnight, I cannot seem to get any data out from the database. However, I am able to write as much data as I want to the database. I have to clear the database and restart my app server for the database to work again.

I checked the validity of the connections and they are valid (they haven't expired).

This problem does not surface if I continue to write data to the database overnight.

Any thoughts on what could be the problem?

[Jeanne Boyarsky]

Ron,
Does it work if you open a new connection and try to read from it?

[Ron Patel]

No. The Control Center freezes too.

[Jeanne Boyarsky]

Ron,
It sounds like the database is running out of resources. You would be better off closing the connection as soon as you are done with it to avoid this sort of problem.