[skariko]

Hi guys, just to let you know, i've noticed an abnormal amount of load
put on the cpu by the mysql server, after installing the ibProArcade
mod.

This only happens if you enable the display of "tournament winner" in
the postbit.

I'm referring to those two options :
- Show Highscores in Postbitsaves
- Show Tournaments won in Postbitsaves

If you enable those two options, i've noticed that the load on the
server will increase dramatically.

I've a dedicated double xeon server, running vbullettin 3.6.7 on
Apache2.0+PHP5+MYSQL5 and the usual server load with 500 simultaneous
users connected to the forum doesn't exceed the 1.0 on an average.

With those two ibpro options turned on, i've noticed a heavy increase
on the server load, i'm talking about DOUBLE load, a 1.8 - 2.0 on an
average basis?

Moreover in three distinct occasions the mysql database has gone into
a sort of loop and the server load has grown over 40.0.

It took to me a long time to understand what query was causing all
that load, and the problematic query was SELECT t.champion, u.userid
FROM tournaments AS t LEFT JOIN user AS u ON (t.champion = u.usernam
…) etc ...

So, i don't know if that's specific to my configuration, but i've
thought to share this with you.
If you notice an enormous load on your sql server, try to disable
those two previously mentioned options, and things should definitely
improve. Hope it helps

Greetings