MySQL Forums
Forum List  »  Performance

MySQL Not Utilizing Multiple CPUs?
Posted by: Sathyan R
Date: February 07, 2009 12:52PM

Hi, We have got new servers for one of our applications and one was setup as a dedicated server for MySQl - Since the time we moved to the new servers we have performance issues and the site goes down too often - Application level issues are almost ruled out and we are looking at the settings etc. The server config is - Intel Xeon CPU - 8 Processors- E5410 @ 2.33 GHz, 4 GB RAM. The salient settings @ config level include - max_connections=500 (increased from 250), key_buffer_size=200M, innodb_buffer_pool_size=1024M, innodb_thread_concurrency=18. The web app is a Java based one and we have seen "Communication Link Failure" Errors on the log and the remote access is enabled for root in all required places - We have also noticed that the CPU usage never goes beyond 30 - 35% and when we look at the Performance graph, out of the 8 only 2 seems to be busy. At the same time, we have carnage happening at App level with the tomcat threads being hung the with too long response times - the point is we seem to be not using all CPU power - Is there a setting which caps mysql usage also what do we need to do explicitly to get/make sure all CPUs are used? (except innodb_thread_concurrency, which is at 18). Please suggest this is an emergency and any help is greatly appreciated - Also does the communication link failure points to network issues?

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Not Utilizing Multiple CPUs?
2651
February 07, 2009 12:52PM
1717
February 07, 2009 04:41PM


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.