MySQL 5.0 Unavailable but still working every monday morning
- by user1578031
So I have a MySQL server with 4-5 databases and every monday morning, I can't login with PHPmyAdmin or the cmd line tools or options and the funny thing is the connection can be made later in the day around 3:30 - 4PM. I can't replicate the issues on any dev boxes and cant upgrade to 5.5 for a number of reasons.
I want to try and poll the sql databases with a simple script and just connect to it and then disconnect.
I'm not very good with SQL but would like to know if anyone could help with a script which I can automate to run sunday every 30mins or so, to see if the issue can be stopped by the database being connected to over the very quiet period of sunday...
After this im out of ideas and have to wait for the HW/SW refresh to get 5.5 on there...