In the next weeks I’ll move my webproject from a rather small server to a big one. The specs:
AMD Athlon 64 X2 6000+ Dual Core
8 GB DDR2 RAM
2 x 750 GB SATA II (Hardware RAID1)
1 GBit OnBoard Network
I read some tutorials and blog posts about configuring mysql, especially innodb, but most of them are focused on MySQL-only servers (e.g. “use 80% of your memory for innodb_buffer_size” and so on). I’ve to run MySQL 5, Apache, PHP 5 etc. on the same server, so these recommendations doesn’t really fit to my new server.
So what do you suggest are good values for the most important mysql configuration settings? It’s for a community website with heavy database use and a lot of traffic. The main databases are running with InnoDB, only databases for third-party-scripts (like a blog system) use MyISAM.