MySQL Forums
Forum List  »  Performance

Re: Choosing CPU(s) for MySQL
Posted by: James Day
Date: March 10, 2005 07:07AM

For the database server side only:

Opterons are good. Wikipedia/Wikimedia has 5 dual Opterons and is buying more. Hyperthreading can be worth up to about 30% more and you use it if your CPU supports it.

Whether you'll get a benefit depends on whether your load is CPU-limited or not. Personally, even though CPU use is normally only 10-30% ont he Wikimedia servers, I find it very convenient to have the other so that backup-related tasks like gzip can use a full CPU without hurting the database server.

For the Apaches:

You may be able to use as much CPU power as you can buy. Depends on how your'e building your web pages. Opterons also looked good for this. Might not be best value/performance for your work if you're doing lots of Apache CPU, really heavily depends on your particular applications and the prices of the pieces.

Apache can significantly increase your RAM needs. If you can avoid it, it's nice ot have Apache and database on different servers so you can add more Apache boxes as you need the CPU power and so DB and Apache don't fight over the RAM.

Wikipedia has pretty CPU-intensive Apache/PHP work and runs at about 6-7 Apache servers (2.8-32.GHz P4s) per DB server.

Options: ReplyQuote


Subject
Views
Written By
Posted
2718
March 08, 2005 06:19PM
Re: Choosing CPU(s) for MySQL
1802
March 10, 2005 07:07AM
1839
March 10, 2005 04:47PM


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.