June 19, 2013

Comment: What CPU Architecture do you prefer for running MySQL In production

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.

Post: What CPU Architecture do you prefer 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…

Comment: Intel Nehalem vs AMD Opteron shootout in sysbench workload

You are all confusing the issue with the cores: Intel: 12 cores + hyperthreading. AMD: 48 cores. Forget about “threads” and “virtual cores…

Comment: Intel Nehalem vs AMD Opteron shootout in sysbench workload

Jeffrey, Vadim has corrected it is 12 cores 24 threads here. It is 2 sockets Intel vs 4 socket AMD

Comment: Intel Nehalem vs AMD Opteron shootout in sysbench workload

… energy consumption during average use, it’s probably closer to AMD than Intel.

Comment: Intel Nehalem vs AMD Opteron shootout in sysbench workload

Surprising results would of though a Nehalem based processor running at much higher clock speed would have a more substantial lead. How would innodb_buffer_pool_instances come into play would it make a difference ? Noticed Intel and AMD servers have different vm.dirty_ratio of 40% and 20%

Comment: Intel Nehalem vs AMD Opteron shootout in sysbench workload

You are all confusing the issue with the cores: Intel: 12 cores + hyperthreading. AMD: 48 cores. Forget about “threads” and “virtual cores…

Comment: Intel Nehalem vs AMD Opteron shootout in sysbench workload

Jeffrey, Vadim has corrected it is 12 cores 24 threads here. It is 2 sockets Intel vs 4 socket AMD

Comment: Intel Nehalem vs AMD Opteron shootout in sysbench workload

… energy consumption during average use, it’s probably closer to AMD than Intel.

Comment: Intel Nehalem vs AMD Opteron shootout in sysbench workload

Surprising results would of though a Nehalem based processor running at much higher clock speed would have a more substantial lead. How would innodb_buffer_pool_instances come into play would it make a difference ? Noticed Intel and AMD servers have different vm.dirty_ratio of 40% and 20%