There is so many people asking how to improve their mysql instance, and also so many replies that increase key_buffer, sort_buffer, cache size… etc… which believe will lighten up the performance. However, fellows never notice those parameters was actually efficient to their setup.
So here you are MySqlTuner,
Continue reading “MySQL tuning for dummies”
Create new database instance on new destination
chown -R mysql:mysql /u02/mysql
mysql_install_db --datadir=/u02/mysql/data --user=mysql
Continue reading “MySQL multiple instance on CentOS howto”
This tutorial is covering the web server performance tunings on MySQL, PHP and Apache, WordPress and BuddyPress or general web hosting purpose, the tuning example is based on CentOS 5.
The key of the following performance tuning is focus on memory and caching, most of people host a web site or forum or blog without any tunings or even use the all out-of-box setting.