[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?

[bbunlock]

well I tried to install the arcade for the first time yeterday on my forum (on dedicated server) did everything I was supposed to but as soon as I got to the "Enter the path to the Product-XML-File: ./includes/xml/product-ibproarcade.xml and click IMPORT" the server went balistic and finaly crashed, at first I wasnt sure if it was the isntall that did it so rebooted server and waited a while, all ok untill I ran that command again and server crashed again.

I then decided to login to ssh and run top, then I ran the above command again from admincp and would check what was happening in top, well as soon as I clicked import the top screen went mad, every process was mysql and the server load went to 74.? and finaly had to reboot server again becuase it was totaly unresponsive.

in total tried to install this 4 times and 4 times it blew my server away and needed to reboot.

some info for you just in case

mod (latest version 2.5.7)
vbul 3.5.3
PHP Version 4.3.10
mysql 3.23.49
server p4 1.8

any ideas would be great

regards

[TonyLuong]

Originally Posted by 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

I have "Method of recording a user's score" set to "Only save users top score". The display 20 games per page.

Some more info:
+ I go ahead and do a test install it on my vertual host account I got from other company and see the differences. (Notes: this also fresh install of vBulletin 3.6.3). The installation went much faster than it did not my server (it takes 10 minutes to import the product-ibproarcade.xml on my server where about 20 sec on this virtual server).
+ The game homepage here load alot faster than the game homepage on my dedicate server (10 times faster).
+ Is this because my board has too many users? to many posts? too many concurrent online? Is there any code in there that makes ibProAcade goes crazy on busy site and big board?

[TonyLuong]

Hello MrZeropage,
Are you looking into this heavy server load issue? I really want to run Arcade on my board that already have lots of users already. But Arcade gives heavy server load problem there. Arcade works on empty vbulletin board for me but that's not where I want to run it. Please help!

[James T Brock]

Can anyone with a big forum who were previously having problems verify whether or not the newest 2.5.8+ fixed their issues?