Geek Answers Handbook

Phpbb3 slow indexing of new posts

I am trying to find a solution to improve indexing of new phpbb3 posts. I have about 10,000 posts on my forum, and each new post adds a VERY long time (20-30 seconds). I checked mysql_slow.log and found there long queries that actually add a message to the phpbb3 index.

Does anyone or any ready-made solutions?

+4
source share
1 answer

Let MySQL run for 72 hours (without restarting), then load and run MySQL Tuner: (as root)

cd ~/ wget http://www.mysqltuner.pl/ -O ./mysqltuner.pl chmod +x ./mysqltuner.pl ./mysqltuner.pl

This will give you an idea of ​​what settings you can make to improve performance based on your actual use and needs. After you make the changes, you will want to restart MySQL and then give it another 48-72 hours before starting the tuner again to find out if there is any kind of fine tuning that you can do.

0
source

More articles:


All Articles