MySQL Performance: MySQL => Tips regarding mysql configuration needed

Tips regarding mysql configuration needed [message #3619]

Fri, 10 October 2008 05:17

Carsten_H.
Messages: 9
Registered: August 2006

Junior Member

Hello!

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.

Greetings
Carsten

Report message to a moderator