MySQL Forums
Forum List  »  Performance

Re: Number of used connections soar high every 30 minutes
Posted by: Julien Walther
Date: May 02, 2005 03:14PM

Hi,

for anyone who's interested (as this was a very weird issue): We solved the problem. Had to do with lots of concurrent unauthenticated connections and reverse dns-lookup problems.


Julien Walther wrote:
> 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
Re: Number of used connections soar high every 30 minutes
2728
May 02, 2005 03:14PM


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.