1 (edited by esupergood 2010-05-24 09:54)

Topic: Punbb forum is hammering the server CPU

My forum has been slow for a while and I've finally gotten around to asking the host tech support for clues as to why. He says out of over 100 sites on the server mine is the 2nd most CPU hungry.

He copy and pasted the below queries and he says he suspects the problem maybe that I have several large tables. This could make sense because there are some topics on my forum that have over 5000 replies and are steadily growing every day. Those large topics have been the very slowest to open.

Actually, I've now closed those large topics and moved them to a hidden admin forum so that they can't be access. That resulted in a much faster forum BUT it has gone slow again this morning.

1064363 mark4321_forum  localhost       mark4321_forum  Query   34      Copying to tmp table    SELECT u.email, u.title, u.url, u.location, u.signature, u.email_setting, u.num_posts, u.registered,
1064376 mark4321_forum  localhost       mark4321_forum  Query   34      Copying to tmp table    SELECT u.email, u.title, u.url, u.location, u.signature, u.email_setting, u.num_posts, u.registered,
1064387 mark4321_forum  localhost       mark4321_forum  Query   31      Locked  UPDATE online SET logged=1274518906, prev_url='http://www.eroyton.co.uk/forum/viewtopic.php?pid=1410
1064388 mark4321_forum  localhost       mark4321_forum  Query   31      Locked  SELECT u.*, g.*, o.logged, o.csrf_token, o.prev_url, o.last_post, o.last_search FROM users AS u INNE

Thanks very much for any help offered
smile

Re: Punbb forum is hammering the server CPU

48 views, no replies.
Hopefully someone can offer someone insight.

I thought PunBB was supposed to be lightweight on CPU usage.
My database is 80MB

But those large topics seem to be what are causing the problems.
Any thoughts?

Re: Punbb forum is hammering the server CPU

I think your issue may be similar to this one:

http://fluxbb.org/forums/viewtopic.php?id=4194

4 (edited by progent 2011-05-29 14:10)

Re: Punbb forum is hammering the server CPU

Hello,
I have the same problem (topics with > 8000 posts).
Do you have an idea to adapt the patch
http://fluxbb.org/forums/viewtopic.php?pid=32253#p32253
for Punbb?
I tried without success: only "Topic RSS feed" was displayed.
Thank you.

Re: Punbb forum is hammering the server CPU

progent wrote:

Hello.

It already implemented in PunBB 1.4dev branch.

For 1.3 branch you can use this extensions — http://forum.iteam.ua/fancy_fast_punbb.tar.gz

Re: Punbb forum is hammering the server CPU

Great! Thank you very much!  smile

Re: Punbb forum is hammering the server CPU

In a case of MySQL DB im recommended use OPTIMIZE and ANALYZE query at least once per week (better every night). Many hostings with CPanel do it automatically.

8 (edited by progent 2011-11-05 15:38)

Re: Punbb forum is hammering the server CPU

Yes, I type the command

mysqlcheck -A -r

regularly.

According to you, is there a benefit to use InnoDB engine instead of MyISAM?

I have a very bad Lock Wait ratio (1 : 287).

Re: Punbb forum is hammering the server CPU

Im not experimented with Engine type.
Im use MyISAM 5 years without any problem on http://forum.iteam.ua but make backup every night.

Re: Punbb forum is hammering the server CPU

Ok,
I just install your extension and large topics are displayed more quickly.  Thank you! cool