Database Security. Database Auditing. Database Caching. Database Masking. Get it nowperformance tip
Posted June 24th, 2009 by johnybravo
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
G
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