1 Topic by chali

  • From: Buenos Aires
  • Registered: 2006-01-20
  • Posts: 32

Topic: High loads

Hi, I'm having problems with my hosting provider becouse of the heavy loads my forum is generating.

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)

chali's Website

  • sirena
  • sirena
  • Senior Member
  • Offline
  • Registered: 2006-04-06
  • Posts: 473

Re: High loads

In the Administration area there are several options you can turn off to reduce server load.

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.

3 Reply by chali

  • From: Buenos Aires
  • Registered: 2006-01-20
  • Posts: 32

Re: High loads

Thanks! I'll disable both features.
I'm only running the private messages mod, that shouldn't be a problem i guess.
I'm waiting for 1.3 to make only one upgrade smile

chali's Website

  • From: Russia
  • Registered: 2007-12-13
  • Posts: 642

Re: High loads

chali, have you just upgraded your forum to RC2? How did the server load change?
Please, report us any issues. Your feedback will be very useful.

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).

Carpe diem

Anatoly's Website

5 Reply by chali

  • From: Buenos Aires
  • Registered: 2006-01-20
  • Posts: 32

Re: High loads

Yes I've uploaded to 1.3RC2 becouse I was still having problems 1.2 even after turning off the items mentioned before.

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

chali's Website

  • From: Russia
  • Registered: 2007-12-13
  • Posts: 642

Re: High loads

This really depends on the hosting software configuration.
Nevertheless, sirena's recommendations are right.

Carpe diem

Anatoly's Website

  • sirena
  • sirena
  • Senior Member
  • Offline
  • Registered: 2006-04-06
  • Posts: 473

Re: High loads

Ouch. I just saw this notice when I went to the OP's forum page:

This Account Has Been Suspended
Please contact the billing/support department as soon as possible.

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?