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:

nano /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 🙂