How can I detect a MySQL server that is unresponsive

mparak · Post by **mparak** » 28.03.2009, 15:44

Dear Friends,

I need to know when the server is unresponsive, or currently executing a LONG query, before I attempt to post my records.
If I could I would write the data locally and attempt to post to the server when the server is free and responsive.
The Ping does not help me as the server that is too busy to process my SQL may still be able to respond to a ping request.

If there was an indicator that I could ask for from the server that could tell me the health of the server, I could use this to decide if the server is fit enough to accept my request.

Any help would be appreciated.

Warmest Regards
Mo
CAD RETAIL
Durban
www.cad.co.za

Post by **seawolf** » 28.03.2009, 20:31

At first sight I would say use pingserver property.
If that is not sufficient what about checking RowAffected property after every insert/update/delete? By this way you know if a SQL command was processed correctly or rejected.

On the other side you should undestand why that server is so stressed and improve it (if it is possible), i.e. changing hardware.

bravecobra · Post by **bravecobra** » 02.04.2009, 23:03

I use the PingServer functionality combined with a TTimer, just to keep the connection alive.

zippo · Post by **zippo** » 06.04.2009, 13:12

What exactly is the difference between Ping and PingServer?