Hello,
We are currently using MySQL 5.1 server on a Windows XP Professional desktop. We have a basic application which polls data from a piece of hardware, stores it in the MySQL database. From there the data is transferred over the Internet to our main office. If the internet transfer was sucessful, then the data is removed from the local database.
This process runs constantly, polling data once every 10 seconds, and then transmitting once every minute.
This system has worked very reliably, but we eventually run into a failure with the MySQL server service. This last time, the process ran fine for a month before failing. By fail I mean the following:
-If I look under Computer Management -> Services I see the MySQL server is stopped
-If I start the service, and then attempt to connect to the database via any means, the service instantly stops
-A second attempt to start the service results in an error "Service could not start".
I have isolated the problem to the database itself, if I remove the data folder contents, the service starts up fine (with an empty database and no permissions). If I run the MySQL reinitialization tool, then it sets up my permissions, basic structure, etc.
To get our system working again, I create the database/table structure for scratch.
The Windows System Event Viewer does not contain any entries explaining why it failed. The database size never gets very large, as data is quickly created and then removed. Does anyone have any suggestions for what the problem might be. Do these continuous transactions cause a problem that I am unaware of?
Thanks
Start Free Trial
