Auto-Restart My SQL when 2 many connect-errors
From: Solange Ezveff (se_at_friend.fr)
Date: 12/23/04
- Next message: raylopez99: "Re: Linux Development Tools running under Windows? Under .NET? What IDE 2 use?"
- Previous message: Kasper Dupont: "Re: Bash redirection problem"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: 23 Dec 2004 00:25:47 -0800
Hi,
>From the advises received, I built the following script to restart
mysql when the database is blocked because of "Too many connection
errors" : The max_connection_errors in MySQL admin is set quite high.
Therefore we do not know where this error comes from.
With this script :
#!/bin/sh
ps -ef | grep mysql | grep mysqld | grep -v grep > mysqlstatus
if [ -s mysqlstatus ]; then
echo "MySQL: OK"
else
echo "MySQL: NO"
/etc/rc.d/init.d/mysqld restart
fi
rm mysqlstatus
We restart MySQL when it is down. We need to add it in order to
have MySQL restarted when "Too many connection errors" occurs. We do not know
if a test connection to the database to be the answer. Please (double
please) : might you add two or three lines in order to restart MySQL
when we have "Too many connection errors". I thank you very much in
advance.
Solange.
- Next message: raylopez99: "Re: Linux Development Tools running under Windows? Under .NET? What IDE 2 use?"
- Previous message: Kasper Dupont: "Re: Bash redirection problem"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
