Hello, How to add MySQLTuner Recommendation / Variable value on our Nginx? I have open /etc/mysql/my.cnf And have added this :
query_cache_type= 1 tmp_table_size = 16M max_heap_table_size= 16M
But it show error to start service.mysql.
Any advice for that?
Thank you, Frans W
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
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!
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.