- Original Message -
From: "Bryce C" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 10, 2002 7:14 AM
Subject: resetting mysql server "gently"
Bryce wrote:
BC> I have a script that runs every minute to deterimine
BC> if the loa
I agree completely with Egor! You should not be killing your processes to
solve load problems. If there is a load problem 1) You need to write your
applications better, 2) you need to have a better database structure, 3) you
need to analyze where indexes would help you, or 4) you need a more
Hello Bryce,
Thursday, October 10, 2002, 8:14:22 AM, you wrote:
BC> I have a mysql + php + apache server that is under
BC> heavy load.
BC> I have a script that runs every minute to deterimine
BC> if the load is above a certain value (or if swap is
BC> high) and if so, it kills all the httpd pr
tober 10, 2002 1:14 PM
Subject: resetting mysql server "gently"
Hi,
I have a mysql + php + apache server that is under
heavy load.
I have a script that runs every minute to deterimine
if the load is above a certain value (or if swap is
high) and if so, it kills all the httpd processes,
does
> I am curious if there is a better way to restart mysql
> that would kill off any hung/long-running queries but
> not totally bring the server down. Any other ideas for
> managing a big load.
What you can do, assuming the mysql user has proper privs, is list and
kill all mysql threads running wh
Hi,
I have a mysql + php + apache server that is under
heavy load.
I have a script that runs every minute to deterimine
if the load is above a certain value (or if swap is
high) and if so, it kills all the httpd processes,
does /etc/rc.d/init.d/mysql stop
The script then starts everything back
