Performance improvement of WordPress by accelerating mysql

As mentioned by this tweet, I am interested in accelerating web service.

参考になる。
　最後の製品紹介は抜きにしても。https://t.co/V1eNveC0nU
— ヤッチ@外資系車載機器組込エンジニア (@linux_fun) September 24, 2021

In this article I accerelated mysql which is database of WordPress.
I performed benchmark before and after.

You can see where it is.

What I did

I made some configuraiton files in /etc/mysql/conf.d/.
– Memory size should be customized to align your machine spec.
This is to cache query contents.

[mysqld]
query_cache_size = 32M
innodb_buffer_pool_size = 256M

After making this file don’t forget to restart mysql.

Before vs after

I use this article image which runs on Raspberry Pi 4 as “Before”.

I measured with below condition.

- Using LightHouse in Developers Tools of Chrome browser.
  Checking Performance only
- Taking median as representative(n = 5).
- Measuring on secret tab of Chrome.

Before
<—Mobile Desktop—>

After
<—Mobile Desktop—>

Mobile improved 4 points, Desktop did 7 points!

Conclusion

How was it?

This can improve much with small work!

You can see other improvements.

Nginx

PHP

WordPress

What I did

Before vs after

Conclusion

Comments