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.