Looks like the load issue got his account suspended.

And BTW what is the SQL code in his last post trying to do?

It seems to be doing a lot of looping or something around SELECT u.email and also doing several very expensive wildcard SELECT u.* queries, which could be a problem on a board with several thousand members. What PunBB PHP would be generating that SQL?

Thanks Anatoly, I'll be very glad to help you test anything you need.

Well I'm still having high loads, but I starting to think that it's a hosting issue, it start happend suddently without a reason...

This are the last errors reported:

*The following query was stopped as it exceeded allowed execution time.*

REPLACE INTO pbb_online (user_id
SELECT u.email
SELECT COUNT(p.id) FROM pbb_posts AS p WHERE p.topic_id=1712 AND p.posted<1211075655
SELECT u.email
SELECT u.email
SELECT u.email
UPDATE pbb_online SET logged=1225862124
SELECT u.*
SELECT u.*
UPDATE pbb_online SET logged=1225862077
SELECT u.email
UPDATE pbb_online SET logged=1225861834
SELECT u.email
SELECT u.id
SELECT u.email
SELECT u.email

PS: I have to note that RC2 is still a development version. And we have discovered several RC2 bugs already (though they are not critical, and hotfixes released).

One is of course the display of Users Online, which you can find under:

Administration > Options:
'Display info on the index page about guests and registered users currently browsing the forums.'

You could also disable the 'User has posted earlier' feature. This feature displays a dot in front of topics in viewforum.php in case the currently logged in user has posted in that topic earlier. Disable if you are experiencing high server load.

Turning these features off might save you a few MySQL queries for each page load.

Are you running any mods? Sometimes they can also add considerable load. If you are, you might look into disabling some of the ones you dont really need.

You should also consider updating to PunBB v1.2.20, which has seen a bit of code tuning which may also help you out a bit.

This is an example of an error report.

The following query was stopped as it exceeded allowed execution time.

- Event Summary:
USER: xxx
PID : 122105
DB : xxxx
CMD :  UPDATE pbb_online SET logged=1225802973 WHERE ident='74.6.18.253'
TIME: 37

Most of the errors are becousse of UPDATEs and INSERTs on the pbb_online table.

Any clue how to fix this? or at least disable actions son this table.

URL of my forum: http://smashingpumpkins.com.ar/board/

I'm using 1.2(guess .10)

Thanksss (sorry for my english)