MySQL Forums
Forum List  »  Install & Repo

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
October 03, 2012 01:55PM


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.