As mentioned by this tweet, I am interested in accelerating web service.
In this article I accerelated mysql which is database of WordPress.
I performed benchmark before and after.
You can see where it is.
![](https://linuxfun.org/wp-content/uploads/2021/10/image-36.png)
Other improvements are in this article.
![](https://linuxfun.org/wp-content/uploads/2021/10/seo-1-160x90.jpg)
How to accelerate WordPress
In this article let me summarize how to accelerate WordPress. System architecture You can find from my github. Nginx Tar...
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—>
![](https://linuxfun.org/wp-content/uploads/2021/10/image-1024x683.png)
After
<—Mobile Desktop—>
![](https://linuxfun.org/wp-content/uploads/2021/10/image-10-1024x683.png)
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
Comments