4

I try to found solution to improve phpbb3 new message indexing. I have about 10000 messages on my forum, and each new message adds VERY long time (20-30 sec). I've checked mysql_slow.log and found long queries there which is actually adding message into phpbb3's index.

Do someone have or find any ready solutions?

hakre
  • 193,403
  • 52
  • 435
  • 836
Epsiloncool
  • 1,435
  • 16
  • 39

1 Answers1

0

Let MySQL run for 72+ hours (without being restarted) and then download and run MySQL Tuner: (as root)

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

That will give you a good idea of what tweaks you can do to improve performance based upon your actual usage and needs. After you make the tweaks you'll want to restart MySQL and then give it another 48 to 72 hours before you run the tuner again to see if there is any finer tuning you can do.

Terence
  • 10,533
  • 1
  • 14
  • 20
  • you should also check the phpBB forums for large community site tweaks, as far as I can remember from the phpBB 2.x era phpBB is actually not intended for large communities – Terence Oct 27 '11 at 22:39