MySQL optimization

Optimization of MySQL:

Install the mysql workbench from http://www.mysql.com/downloads/workbench/

Start the Workbench (insert your password, probably sap2011), and then click on Local MySQL:

In the Admin screen click the option files, click the Networking tab, and scroll down to wait_timeout:

Check it, and replace the default value by 9999999

Scroll down, and click apply (and confirm in the popup box).

Next, in the performance tab and set cache Query and cache limit to at least 256M (or try 500M)

Then click “Apply changes”

Next go to Advance tab, scroll all the way down and set Bulk insert buffer to at least 256M