EmergencyEMERGENCY? Get 24/7 Help Now!

What CPU Architecture do you prefer for running MySQL In production

 | November 24, 2012 |  Posted In: Events and Announcements, MySQL


Time for another poll! I wonder What CPU Architecture do you use for running MySQL in Production ? I guess most of the game here is between Intel and AMD x86-64 variants though I wonder if there is still a lot of use for others in the wild. If I am missing some Architecture which is still alive in your data center please post a comment and I will add it to the list.
Please select all what applies. If you would like to share what works better for you in the comments I appreciate it.

What CPU Architecture/Vendor do you use for Running MySQL In Production

  • Intel Based CPUs (91%, 502 Votes)
  • AMD Based CPUs (15%, 84 Votes)
  • Sparc Based CPUs (3%, 16 Votes)
  • ARM Based CPUs (1%, 8 Votes)
  • PowerPC Based CPUs (1%, 7 Votes)

Total Voters: 553

Loading ... Loading ...
Peter Zaitsev

Peter managed the High Performance Group within MySQL until 2006, when he founded Percona. Peter has a Master's Degree in Computer Science and is an expert in database kernels, computer hardware, and application scaling.


  • Not sure why you bothered with a poll. Most people run mysql on x86-64 linux, which (even if they didn’t suck rocks) eliminates powerpc and sparc, and intel is way ahead of AMD on price and performance in the enterprise space. I assume ARM was placed in the poll by accident.

  • I would be more interested to see which class of processor is in use– for Intel that would be something like Atom, E3, E5, E7. What do performance numbers look like on an E5-2690 vs. an E7-2670?

  • Running MySQL on your home NAS, HTPC, embedded device, or whatever don’t fit “production”. Peter specifically spoke about hosting in a datacenter.

  • Rodalpho,

    Most people indeed run MySQL on x86 architectures yet I was interested to understand what other architectures are still in use.

    Regarding ARM it is not there by accident. There are some developments in Server level ARM to be used for applications with relatively low performance needs such as this one: http://www.theregister.co.uk/2012/07/09/boston_viridis_arm_server/

  • There’s two different titles on this page which don’t quite mean the same thing:
    – What CPU Architecture/Vendor do you use for Running MySQL In Production
    – What CPU Architecture do you prefer for running MySQL In production

    use != prefer

  • Dalin,

    Use!=Prefer on the personal level but it gets close on the organizational level. When organization made a choice to use certain CPU this means it was preferable choice in decision maker mind compared to alternatives right ?

  • Strange math here! As of my vote it says

    Intel – 93% – 384 votes
    AMD – 16% -66 votes
    Sparc – 2% – 10 votes
    ARM/PPC – 1% 5 + 4 votes

    Total voters: 415

    Though 469 votes have been cast

  • If more detail is helpful, we use only Intel and 99% on Dell two socket servers, usually R420s these days, and often under Xen virtualization (in private clouds, on AWS, etc.), usually 8-64Gb of RAM or more. Usually batter-backed PERC raid on 15K SAS drives, of course.

    For CPUs we use the 5×20 type CPUs, i.e. low end of the mid-range CPUs, usually the slowest/lowest we can get hyperthreading with, on the theory that HT works well with MySQL and Xen, PHP, JAVA etc. that we see most of the time. These seem the best value at scale and broadly we think high-cost high clock rates are a waste, but cores are worth every penny though we are waiting for 8-10 core CPUs to come down in price. New R420s with 24 HT cores, 128-256GB of RAM, 8TB of disk are cheap and powerful machines for MySQL, even in virtualized environments.

Leave a Reply


Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.