May 29, 2012
tom
No Comments

What database server will benefit from 4 CPUs

Question

I use MySQL server on Debian GNU/Linux machine with 4 CPUs (Linode 4096) and there are performace issue on havy load (in the middle of the day) but machine is not overload only queries are slow.

What other database I can use that will use those 4 CPUs? I read that MySQL use only one. Is there SQL dababse or do I need to use NoSQL? Most queries are selects.

Asked by jcubic

Answer

You are asking the wrong question. Find out what the performance bottleneck is instead of searching for a database server that makes better use of the resource you obviously have enough of (CPU power).

Answered by SvenW

Check more discussion of this question.

Related posts:

  1. How does Oracle Database Standard Edition (One) benefit from running on a dual CPU server?
  2. For a new database server, which partition will benefit the most from SSDs?
  3. How can I tell if an Oracle database is mounted and activated?
  4. Which database server scales better: PostgreSQL or MySQL?
  5. Dedicated database server or local database server for performance

Leave a comment