[HELP] 2.5.6 is putting a load in my server

I already made a post about this but there seems to be no interest on this and I'm not sure but I think it is a bug.

My site is a busy site but the latest version, 2.5.6, is putting a high load to my server, sometimes bringing my server to not working condition.

All the mysql processes show something like these:

| 4315 | xxxxxx | localhost | xxxxxxx | Query | 0 | Locked | UPDATE vbb_games_league SET mid='2122',gid='16',position='1560',points='0',cat ='1' WHERE gid=16 AND |
| 4411 | xxxxxx | localhost | xxxxxxx | Query | 0 | Locked | UPDATE vbb_games_league SET mid='1831',gid='16',position='1476',points='0',cat ='1' WHERE gid=16 AND |

And this processes become so intense that the load of the server go to the top. If I shut down the arcade the server behaves without a problem.

Right now, if there is no answer for this could someone tolde me if it is safe to roll back to 2.5.5 and if so, I will only need to upload the files from that version and overwrite the product, right?

[Barabaika]

You should put this in your my.cnf:

long_query_time=1
log-slow-query=/var/log/mysql/mysql-slow.log

1 second is the lowest setting for now, but that's good enough to find the slowest queries.
If the log says that to find 1 entry it scanned 50000 entries, that means something is wrong with the query.

You can analyze the slow query:
EXPLAIN SELECT .... WHERE user.avatarid=avatar.userid ...
If it says ALL entries, that's bad.
For example, in the former statement there must be indexes ON
user.avatarid
avatar.userid

[MrZeropage]

Originally Posted by Barabaika

At least, it's much faster for me now.
I've created indexes and fixed several queries.

When I had looked at the server load, it was mainly MySQL that created it by getting the data for the arcade page.

Maybe you can hand those changes to me for integrating in v2.5.7 ?

[scdurwood]

Originally Posted by MrZeropage

I think I found the code that causes a higher serverload, just waiting for confirmation of that.

Well, "it's not a bug, it's a feature"
It is a feature I implemented and if that was the reason I will do a switch in AdminCP to turn it on/off ... Until v2.5.7+ is out I will provide a QuickFix for that here

Have you released the quickfix?

Server loads via the arcade are an issue on my site as well...

Originally Posted by Barabaika

At least, it's much faster for me now.
I've created indexes and fixed several queries.

When I had looked at the server load, it was mainly MySQL that created it by getting the data for the arcade page.

The easiest way is to log slow queries in MySQL and then investigate them.
http://dev.mysql.com/doc/refman/5.0/...query-log.html


There can be other problems as well.

Please explain how you indexed each table and the other query fixes you implemented...

[MrZeropage]

I am also waiting for response on the improvements he did ...

[ArchangelX]

Oh man...I just upgraded to 2.5.6...is this a problem for everyone? Quickfix please, just in case!

[MrZeropage]

just update to v2.5.7+ now

[gazzak]

Just as a side note. I had a big load on my server at all times when the arcade was running. Turning off the option to show high scores in the postbit totally cut the load. I've not seen that mentioned in this thread so give it a try.

[MrZeropage]

did you use v2.5.7+ ?

[TonyLuong]

I just installed ibProArcade 2.5.7+ for 2 days on a dedicated 3.2 Dual Xeon 2GB RAM. My server crashes so often right after having ibProArcade there.

My site is busy on forums 1000+ current online but not many people on arcade (around 10 at once max) my board having about 500,000 members and about 457,000 posts.

I don't have "Show Highscores in Postbit" set
I don't have "Show Tournaments won in Postbit" set
I don't have any tournament created

Just the arcade home itself take very long time to load. My forumhome takes about 1 sec to load for me where arcade home takes about 20 sec.

Anyone running 2.5.7+ and experience this slow and high server load? Any fix here?

[MrZeropage]

wwhat are your settings about score-saving ? should be "save users top score per game" ...

Also make sure not to display 100 games per page