Database Security. Database Auditing. Database Caching. Database Masking. Get it now

performance tip

in

Though the following tip has nothing todo with improving GreenSQL it should increase performance.

Install MySQLTuner
http://wiki.mysqltuner.com/MySQLTuner#Downloading_MySQLTuner

Optimize MySQL

# ./mysqltuner.pl

Optimize GreenSQL

# ./mysqltuner.pl --host 127.0.0.1 --port 3305 --forcemem YOURMEMORYINMBHERE

You will need to change GreenSQL not to block the queries for a few secs. If you do not want to change any settings you can bypass GreenSQL but still gain some insights to improving performance by skipping the --host option. It will then go over localhost.

Perhaps something to add to the performance article you wrote recently?

Best,

Johny

Comments

Hello Thank you for the tip.

Hello

Thank you for the tip. I am going to test this utility ASAP.

Yuli

fedora users: # yum -y

fedora users:


# yum -y install mysqltuner

Back to top