MySQLTuner / Adding it on Ubuntu / Nginx

Posted June 11, 2016 3.7k views

Hello, How to add MySQLTuner Recommendation / Variable value on our Nginx?
I have open /etc/mysql/my.cnf
And have added this :

querycachetype= 1
tmptablesize = 16M
maxheaptable_size= 16M

But it show error to start service.mysql.

Any advice for that?

Thank you,
Frans W

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
1 answer

Hi @franswiradinata,

The modifications you have detailed should go into that file, but under the [mysql] section. If moving them in there doesn’t work, check the mysql server logs, and update us accordingly! Hope that helps, and let us know if you get stuck!