Hi i need a bang for buck DB server configuration for a php/mysql website. Let me know what you think about my config.
2 x Intel Xeon E5645 2.4Ghz (12 Physical Cores, 24 Logical)
4 X 146GB SAS 15K in RAID 10
Is it bang for buck for the output? or any good configs?
mysql.com versions of mysql 5.1.x won't scale beyond 4-16 cpu cores unless you opt for better performing mysql versions such as mysql 5.5.xx, percona 5.5.10x or mariadb 5.2.6 which can scale up to 12-32 cpu cores depending on mysql settings.
do a google search for "mysql benchmarks mariadb cpu core scaling"
mariadb 5.2.x series is what you want on mysql as it's the fastest for myisam performance and up to 32 cpu cores fastest for innodb. 48-64 cpu cores then percona 5.5.x just takes over from mariadb 5.2.x