MySQL Forums
Forum List  »  Performance

Re: MySQL and dual-cpu server
Posted by: James Day
Date: December 29, 2004 11:43AM

It really depends on your workload. What is your current CPU use at high demand times? If it's low you're unlikely to benefit much from more CPU power. If you're doing things like MD5 hashes or lots of string operations in queries, it may make a substantial difference.

I've a server which has been seeing perhaps 150 million queries per day with MySQL/InnoDB on a dual Opteron setup with 6 15K SCSI disks. CPU use averaged about 30% and didn't go over 60% much. But that's with a workload which doesn't make the database server do much calculating. Your workload could easily be very different - this just illustrates how little CPU use you can have even while doing lots of work.

The CPU chart for the system I mentioned is here (master server for Wikipedia): http://zwinger.wikimedia.org/ganglia3/?r=month&c=Miscellaneous&h=ariel

Options: ReplyQuote


Subject
Views
Written By
Posted
2822
December 28, 2004 10:14AM
Re: MySQL and dual-cpu server
2927
December 29, 2004 11:43AM


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.