EmergencyEMERGENCY? Get 24/7 Help Now!

What CPU Architecture do you prefer for running MySQL In production

Posted on:



Share Button

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 ...
Share Button

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.

Events and Announcements, MySQL, Polls

  • 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.


  • there are a some users, using their home nas as a mysql server, like a qnap wich is based on a Marvell 6281.


  • 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/


  • Neat, I hadn’t seen that product. I too wonder if anyone is using it.


  • The fastest (frquency) Intel CPU you can buy as it heavily influences latency of individual queries in mysql.


  • 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


  • Somebody please sell me an ARM blade!


  • 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


  • Nate,

    I allowed multiple choices in this poll. I assume there are number of people who run both Intal and AMD in their data center


  • 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.

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