Skip navigation links

MySQL Forums :: Install & Repo :: Sending more queries seems to bottleneck MySQL


Advanced Search

Sending more queries seems to bottleneck MySQL
Posted by: Charles Richard ()
Date: October 03, 2012 01:55PM

Hi,

I've been performance testing a site here at work and noticed today that for the same load with different connection pool sizes for c3p0 that the less connections c3p0 establishes to the MySQL server, the better my application performs.

This seems to tell me that the MySQL Server itself is the bottleneck. From the basic stats I know how to monitor, I don't really see the MySQL server struggling. The CPU is churning quite a bit and load is close to 10 (Red Hat) but I'm not sure where the bottleneck is.

Any suggestions on what I could look at to help me further, likely MySQL stats in "show status" that might help me?

Cheers!
Charles

Options: ReplyQuote


Subject Written By Posted
Sending more queries seems to bottleneck MySQL Charles Richard 10/03/2012 01:55PM
Re: Sending more queries seems to bottleneck MySQL Peter Brawley 10/04/2012 08:23AM
Re: Sending more queries seems to bottleneck MySQL Charles Richard 10/04/2012 08:38AM


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.