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