PunBB Forums — Punbb forum is hammering the server CPU

Re: Punbb forum is hammering the server CPU

null@example.com (progent) — Sun, 29 May 2011 18:17:44 +0000

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

Re: Punbb forum is hammering the server CPU

null@example.com (dimkalinux) — Sun, 29 May 2011 18:07:07 +0000

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

null@example.com (progent) — Sun, 29 May 2011 18:01:35 +0000

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

null@example.com (dimkalinux) — Sun, 29 May 2011 17:32:18 +0000

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.

Re: Punbb forum is hammering the server CPU

null@example.com (progent) — Sun, 29 May 2011 17:24:26 +0000

Great! Thank you very much!

Re: Punbb forum is hammering the server CPU

null@example.com (dimkalinux) — Sun, 29 May 2011 17:09:00 +0000

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

null@example.com (progent) — Sun, 29 May 2011 14:09:51 +0000

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

null@example.com (sirena) — Tue, 25 May 2010 20:55:06 +0000

I think your issue may be similar to this one:

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

Re: Punbb forum is hammering the server CPU

null@example.com (esupergood) — Tue, 25 May 2010 11:06:05 +0000

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?

Punbb forum is hammering the server CPU

null@example.com (esupergood) — Mon, 24 May 2010 09:53:45 +0000

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