Gossamer Forum
(Advanced Search)
for
Home : General : Perl Programming :

Check If MySQL is working?

Feb 28, 2002, 9:51 PM
markwilson
Novice (5 posts)
Feb 28, 2002, 9:51 PM
Post #1 of 3
Views: 2909
Shortcut
Quote Reply
Check If MySQL is working?
Is there a command that I can send to MySQL to make sure it's up, working and not locked? We run a directory and sometimes the table is locked because of sorting or updating and I would like to be able to default to the backup database when this happens.
Mar 1, 2002, 12:37 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Mar 1, 2002, 12:37 AM
Post #2 of 3
Views: 2790
Shortcut
Quote Reply
Re: [markwilson] Check If MySQL is working? In reply to
How about opening and closing MySQL before anything else, and seeing what is returned? If you get an error, then either make it loop back and try again (for x attempts, otherwise if it is offline then it will bog down your server with re-trys)...

Not sure if that is what you were asking...but I thought I'd give it a try Crazy

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Mar 3, 2002, 11:14 PM
markwilson
Novice (5 posts)
Mar 3, 2002, 11:14 PM
Post #3 of 3
Views: 2740
Shortcut
Quote Reply
Re: [AndyNewby] Check If MySQL is working? In reply to
I wish I could say that's what I was looking for but sadly not. If you run any query on a locked table, you will have to wait until that lock is released unless anyone has any suggestions??