WordPress on Ubuntu 18.04 OneClick - What are the custom MySQL and other settings?

April 12, 2019 291 views
WordPress

Hi there, I am very impressed with the security and speed of the WordPress on Ubuntu 18.04 OneClick install, fastest WP I have ever used and scores over 90 on PageSpeed. I am just wondering exactly the customization’s to Ubuntu, MySQL, Apache etc that DigitalOcean does to make it run so fast? I picked up a few things in MySQL cnf’s but not sure that would increase the speed that much?

Cheers, Richie

1 Answer

Hello, Richie

You can optimize your database via phpMyAdmin or via ssh.
You can also use a WordPress plugin to do that, this one is really good: https://wordpress.org/plugins/wp-dbmanager/

Also you can mysqltunner (it’s a really cool script written in perl). It will check your current mysql values and it will suggest some values to adjust in the my.cnf file:

Download the MySQLTuner script:

wget http://mysqltuner.com/mysqltuner.pl

Change the scripts permissions to be executable:

chmod +x mysqltuner.pl

```Run the mysqltuner.pl script. You will be prompted to enter in your MySQL administrative login and password:

./mysqltuner.pl

You should see some recommended values that you can tweak in the my.cmf file. This should help you optimize your database a bit.

Let me know if you have some questions.

Alex
Have another answer? Share your knowledge.