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.
Other improvements are in this article.
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.
Mobile improved 4 points, Desktop did 7 points!
How was it?
This can improve much with small work!
You can see other improvements.