Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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...

share|improve this question

migrated from stackoverflow.com Sep 24 '12 at 7:54

This question came from our site for professional and enthusiast programmers.

    
I have a hard time believing the issue here is with mysql... Unless you have some insanely expensive queries that are run every Monday morning ? –  Erik Sep 24 '12 at 4:11
    
above issue comes on localhost(offline) or on dedicated server(online) –  diEcho Sep 24 '12 at 5:01

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.