Skip navigation links

MySQL Forums :: Performance :: Number of used connections soar high every 30 minutes


Advanced Search

Number of used connections soar high every 30 minutes
Posted by: Julien Walther ()
Date: May 01, 2005 06:01AM

Hi, all,

maybe the problem has nothing to do with mySql at all, nonetheless I will try to seek some advice here.

We are operating a fairly large online-community, running on php/mysql/apache. We have three webservers, one db master and two db slaves.

Recently we are trying to figure out one of the weirdest behaviours ever noticed:
Every 30 minutes, to the full and half hour (absolute accurate world time), the simultaneously used connections of our DB master go up from an avg. of usually 12 to 800 or more, make the whole website almost unusable for a few seconds. Then it goes back to normal load.

We have stopped ALL crons for testing; the problem still remains. There is no script running at this interval.

There must be any internal or external cause for this problem. But even a high-performance (malicious) apache bench or the like will not cause such a traffic.

Does anyone have the slightest hint on what this might be?

Thanks a lot in advance.

Julien,
Hamburg/Germany

Options: ReplyQuote


Subject Views Written By Posted
Number of used connections soar high every 30 minutes 6335 Julien Walther 05/01/2005 06:01AM
Re: Number of used connections soar high every 30 minutes 2067 Julien Walther 05/02/2005 03:14PM
Re: Number of used connections soar high every 30 minutes 2001 05/25/2005 04:58AM
Re: Number of used connections soar high every 30 minutes 1972 Daniel Nichter 05/25/2005 07:29AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.