GreenSQL

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