MySQL tuning

Today I find very interesting article for mysql tuning. It’s used google’s perftools (google-perftools package).
First we need to install those packages:


apt-get install google-perftools

After this we need to tell the mysql init script to use it:
ano /etc/init.d/mysql

put
export LD_PRELOAD="/usr/lib/libtcmalloc_minimal.so"
on it and save. Now restart mysql server and test!
Example test is :
SHOW ENGINE INNODB STATUS;
before and after the google-perftools installation 🙂