vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   ibProArcade Archive (https://vborg.vbsupport.ru/forumdisplay.php?f=174)
-   -   Excessive System Resource Issue (https://vborg.vbsupport.ru/showthread.php?t=129186)

ChrisTech 10-16-2006 03:34 AM
Excessive System Resource Issue
 
I had my domain recently (today) suspended for high system resource usage due to page views on the forums continually running over 150 MySQL queries each.

Since disabling IBPro Arcade, the high queries went down. Is there any known issue for this to be happening where it queries, what looks like all the high scores from each game?

I have the arcade disabled for now, but if I cannot find a solution to the issue I won't be able to run the mod any longer (on shared hosting). And unfortunally a dedicated isn't an option now (funds-wise).

Any thoughts or ideas here?


Code:
65 Connect    username_vb@localhost on
65 Init DB    username_vbforums
                    65 Query      SELECT arcade_access, p_require FROM vb_usergroup WHERE usergroupid = 1
                    65 Query      SELECT * FROM vb_games_settings
                    65 Query      SELECT m.userid, m.username, m.posts, m.arcade_ban, m.times_played, m.is_arcade_mod AS is_mod,
                    65 Query      SELECT arcade_access, p_require FROM vb_usergroup WHERE usergroupid = 1
                    65 Query      DELETE FROM vb_games_scores WHERE datescored<1158342408
                    65 Query      DELETE FROM vb_games_champs
                    65 Query      SELECT gid, highscore_type, gtitle FROM vb_games_list  ORDER by gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('127','Archery','1940','Gillbert','1159575977','1322')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('100','Asteroids','1','VampYre','1159407981','1430')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('212','Ball Bounce','1940','Gillbert','1160066359','3859')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('205','Ballthrow','74','sick','1160920582','866.6')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('204','Battleship','74','sick','1159670959','4630')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('160','Bejeweled','9','hunnybear','1160574231','2974')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('152','Billards','74','sick','1159417139','6298')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('154','Bingo','1','VampYre','1159493765','6499')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('193','Bloody Orca Slap','74','sick','1160275886','3470')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('103','Bloody Pingu','74','sick','1159705365','1095')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('215','canyonglider','1','VampYre','1160861085','6080')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('142','Casino Blackjack','95','chooks','1159778978','2500')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('187','Cat Batting','82','Apathetic','1159572252','7194')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('129','Cat Bowling','95','chooks','1160891656','100')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('128','Cat-Vac','9','hunnybear','1159565199','3243')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('101','Chopper Challenge','74','sick','1160274029','516')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('216','Chopper Chase','74','sick','1160186698','675')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('202','Collapse','278','jturbo941','1160881166','2905')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('218','Cow Tipping','2288','ScottSAA','1160776271','55')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('188','Cunning Stunt','2288','ScottSAA','1160789844','1497.2')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('118','Curveball','82','Apathetic','1159663667','28415')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('223','Dance Mat','82','Apathetic','1160306165','46')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('221','Dangerous Fishing','2288','ScottSAA','1160718004','1350')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('224','Dare Level','2288','ScottSAA','1160791312','45')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('117','Defend Your Castle','2288','ScottSAA','1160717649','62260')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('217','Desert Battle','74','sick','1160274404','10')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('176','Dirt Bike 2','74','sick','1159629168','1851')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('190','Disco Racer','82','Apathetic','1159594081','4300')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('201','Dolphin Olympics','74','sick','1159718533','274324')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('148','Doom','82','Apathetic','1159572767','101')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('125','Duck Hunt','1940','Gillbert','1160671194','54000')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('143','Fight Man','2288','ScottSAA','1160696399','63400')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('179','Fire Fighter','2288','ScottSAA','1160775488','17130')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('192','Flash Poker','82','Apathetic','1159593265','96')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('199','Gold Miner','95','chooks','1160187433','16879')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('209','Gold Miner Special Edition','1','VampYre','1159667451','23320')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('144','Heli Attack 2','95','chooks','1159416417','7360')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('210','High Wheels','1','VampYre','1159655358','85')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('189','Highway Hunter','82','Apathetic','1159571337','10200')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('120','Home Run Rally','74','sick','1159417600','16')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('157','Ice Age 2: Rising Water','9','hunnybear','1159565900','2475')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('159','Ice Age 4: Ptero Glide','1','VampYre','1159415780','19063')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('198','Ice Age Part 1 - Scrat Jump - Level 2','1','VampYre','1159667831','263.14')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('207','J-Ball','1','VampYre','1160372686','21611')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('150','Kill Stick Figures','2288','ScottSAA','1160718280','3510')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('133','King of the Hill','74','sick','1160277143','37')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('132','Kitten Cannon','74','sick','1159628328','3244')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('161','Knife Throw 2','1','VampYre','1160372792','3000')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('186','Lightning Break','1','VampYre','1160462058','6891')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('163','Lightning Pool','1','VampYre','1159507842','14335')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('121','Mahjong.','3','Rain','1160027137','1320')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('184','Mahjongg Solitaire','3','Rain','1159414174','44090')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('168','Nanaca Crash','1','VampYre','1159718501','3579.84')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('122','Pacman','82','Apathetic','1159670877','8490')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('203','Panda Bounce','74','sick','1159669696','18820')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('222','Parking Zone','74','sick','1160170137','360')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('102','Penguin Bashing','74','sick','1159644000','3172')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('112','Pingu Slap','74','sick','1159704998','479')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('214','Puzzle Express','1','VampYre','1160200375','196485')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('170','Raiden X','1940','Gillbert','1159576812','693400')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('208','Rapid Fire','74','sick','1160276466','4378')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('200','Rumble Ball: Field num.2','1','VampYre','1160027984','21950')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('211','Saints and Sinners Bingo','1','VampYre','1159655899','811')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('165','Shark Attack','74','sick','1159910584','978')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('180','Shoot the Sky.','82','Apathetic','1159571909','15933')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('99','Snake','74','sick','1159628779','1554')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('98','Space Invaders','95','chooks','1159787708','15960')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('105','spankthemonkey','1','VampYre','1160626567','729')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('96','Tetris','6380','EvilKevin','1159610127','32097')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('206','Throw It','74','sick','1159718092','146600')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('166','Tower Defence','74','sick','1160276712','3808')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('146','Tuer Tuer Tuer','74','sick','1159578362','2455')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('178','Ultimate Greed Poker Slingo','82','Apathetic','1159592353','36500')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('131','Yahtzee','82','Apathetic','1159572109','275')
                    65 Query      INSERT INTO vb_games_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('104','Yeti Sports 1.5','74','sick','1159628067','1322')
                    65 Query      SELECT arcade_language FROM vb_games_settings

Mysticales 10-18-2006 02:18 AM
Wondering if you have your cron setup in a way thats making it keep running over and over, check your crons.

ChrisTech 10-18-2006 05:29 PM
I can't find any cronjob that would be doing that. One thing I did have enabled was the icons in the postbit. (for game champs - in which some folks had 20+). Wondering if that had caused it possibly?

CompuJonathan 10-18-2006 06:38 PM
Chris,

I have disabled (never installed) the postbit addon that ibproarcade has and have never had server load issues.

I think the pulling of all that information from the database per post can cause a load that really isn't needed.

- Compu

ChrisTech 10-19-2006 05:24 PM
Other site got nailed today for excessive resource usage.

Quote:
One of your domains, aboutredbox.com, has been suspended for excessive system resource usage due to single PHP page loads on the domain creating MySQL connections that are executing over 220 MySQL queries each. This sort of activity cannot be tolerated in a shared hosting environment. Attached is once such example of this occurring.
I had disabled the icons in the postbit, auto prune is disabled.

For some reason it looks like its trying to check all the high scores for something (100 games in the arcade). No clue why. Trying to get my domain un-suspended so I can go look.

This is a forum running VB 3.6.0 w/ the current release of IPBPro Arcade.


Code:
                    10 Query      SELECT arcade_access, p_require FROM arbusergroup WHERE usergroupid = 1
                    10 Query      SELECT * FROM arbgames_settings
                    10 Query      SELECT m.userid, m.username, m.posts, m.arcade_ban, m.times_played, m.is_arcade_mod AS is_mod,
                    10 Query      DELETE FROM arbgames_scores WHERE datescored<1158677990
                    10 Query      DELETE FROM arbgames_champs
                    10 Query      SELECT gid, highscore_type, gtitle FROM arbgames_list  ORDER by gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
061019  9:59:51            10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      SELECT s.mid, s.gid, s.name, s.datescored, s.score, g.gtitle
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('48','247 Mini Golf','15','Unholy1','1158744801','195854')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('27','Advanced Curveball','4','oldschooljunky','1159640135','25595')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('1','Asteroids','4','oldschooljunky','1159906605','33770')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('54','Ball Bounce','15','Unholy1','1161179746','2672')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('57','Balls','4','oldschooljunky','1160415954','1.26e+06')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('95','Ballthrow','17','Icehawk','1159251343','511.6')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('40','Battleship','4','oldschooljunky','1160073440','3890')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('10','Bejeweled','4','oldschooljunky','1160159983','2284')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('87','Bike Stunts','21','Jsniper','1159052199','173064')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('8','Breakout','15','Unholy1','1159450886','11490')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('107','canyonglider','4','oldschooljunky','1160153523','8740')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('73','Castlevania','4','oldschooljunky','1160071825','3340')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('108','Chopper Chase','4','oldschooljunky','1160181634','590')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('33','Collapse','20','PennGirl','1158892342','1485')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('49','Cursor Balance','15','Unholy1','1161169906','1.08')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('22','Curveball','4','oldschooljunky','1159404710','27135')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('112','Dangerous Fishing','4','oldschooljunky','1161028143','2000')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('111','Dare Level','4','oldschooljunky','1160185823','33')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('38','Deal or No Deal (British Version)','4','oldschooljunky','1159898877','130000')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('110','Defend the Attack','21','Jsniper','1160075884','21')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('50','Dolphin Olympics','7','Zzeta','1160350497','494459')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('90','Driller','1','VampYre','1159997541','500')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('93','Elite Mahjong','15','Unholy1','1161172536','32948')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('69','FallDown 2','7','Zzeta','1160597300','72855')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('16','Fight Man','16','Woodchip','1159346745','70000')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('36','Fishing The Sea','15','Unholy1','1160066976','3378')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('86','Gold Miner','15','Unholy1','1161162402','17698')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('98','Gold Miner Special Edition','4','oldschooljunky','1160440869','33865')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('45','Hangman','4','oldschooljunky','1160189058','578')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('34','Heli Attack 2','4','oldschooljunky','1160672736','8950')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('21','Helicopter','4','oldschooljunky','1160224834','118')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('7','Hexxagon','16','Woodchip','1158735747','36')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('29','High Wheels','4','oldschooljunky','1159234985','100')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('35','Ice Age Part 1 - Scrat Jump - Level 2','4','oldschooljunky','1160064097','293.04')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('37','Ice Age Part 2 - Rising Water','4','oldschooljunky','1160065889','4316.85')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('46','Ice Age Part 3 - Five Acorns','15','Unholy1','1161269952','2645')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('43','Ice Age Part 4 - Ptero Glide','15','Unholy1','1159437151','1814')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('18','J-Ball','4','oldschooljunky','1160836590','8950')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('28','J20','7','Zzeta','1160350644','42960')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('91','Knife Throw','17','Icehawk','1159251613','2100')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('31','Kwik Shot','4','oldschooljunky','1160408004','17700')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('30','Lightning Break','4','oldschooljunky','1159897706','8937')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('12','Lightning Pool','4','oldschooljunky','1160438292','71743')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('63','Mini Jumper','15','Unholy1','1160075818','21.4')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('9','Moon Lander','4','oldschooljunky','1160159038','3200')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('19','Nanaca Crash','4','oldschooljunky','1160066498','3959.76')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('3','Pacman','4','oldschooljunky','1159639630','18820')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('102','Panda Bounce','4','oldschooljunky','1160428378','36730')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('109','Parking Zone','1','VampYre','1160025907','830')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('56','Pendulumeca','1','VampYre','1160452580','1979')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('100','Pong','4','oldschooljunky','1160066164','69')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('76','Pool Jam - 10 Minute Game','4','oldschooljunky','1160363290','30940')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('106','Puzzle Express','1','VampYre','1160261561','254753')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('66','Pyramid Gold','4','oldschooljunky','1160506262','33900')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('20','Rapid Fire','15','Unholy1','1159436028','3164')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('11','Rumble Ball: Field num.2','15','Unholy1','1160151014','25760')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('70','Saints and Sinners Bingo','4','oldschooljunky','1160673318','810')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('89','Schatzgraeber','4','oldschooljunky','1160064872','13175')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('6','Simon','15','Unholy1','1160067061','7')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('103','Slingo Bonus Bet 21','4','oldschooljunky','1160676190','5175')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('101','Slingo Bonus Bet 21 Jumbo','4','oldschooljunky','1159993576','6750')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('5','Snake','4','oldschooljunky','1159404519','696')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('94','Soccer Pong','4','oldschooljunky','1160774198','1610')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('13','Solitare Slingo','15','Unholy1','1161167583','169300')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('2','Space Invaders','15','Unholy1','1159542301','23790')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('25','Spank The Monkey','15','Unholy1','1159346675','698')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('32','Target 2','15','Unholy1','1160824864','500')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('4','Tetris','4','oldschooljunky','1159582093','70517')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('104','Throw It','1','VampYre','1159834471','144217')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('52','Trivial Blitz','15','Unholy1','1160561946','7050')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('85','Tubin` on Lake Tyler','15','Unholy1','1161163049','16600')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('14','Tuer Tuer Tuer','7','Zzeta','1160351459','1585')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('59','Tunnel Rush','4','oldschooljunky','1159838796','99000')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('55','Typing Contest','4','oldschooljunky','1159640241','117')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('84','Western Shooter','22','DUKE01','1159209017','7044')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('60','Xtreme Shell Game - Xtreme','16','Woodchip','1159347435','600')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('68','Yahtzee','4','oldschooljunky','1160426665','293')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('75','Yeti Long Shot: Porpoheus','4','oldschooljunky','1159640334','1194.3')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('79','Yeti Sports 1- Bloody Pingu','4','oldschooljunky','1159653177','3408')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('78','Yeti Sports 2 - Bloody Orca Slap','4','oldschooljunky','1160674968','451.8')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('71','Yeti Sports 2 - Orca Slap','4','oldschooljunky','1160072846','538.5')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('74','Yeti Sports 3- Bloody Seal Bounce','16','Woodchip','1159347088','90060')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('80','Yeti Sports 8- Jungle Swing','4','oldschooljunky','1160364987','120')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('72','Yeti Sports 9 - Final Spit','15','Unholy1','1161165040','157')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('26','Yetisports 3 - Seal Bounce','15','Unholy1','1159546150','431.13')
                    10 Query      INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ_date,champ_score) VALUES ('58','Yetisports6 - Big Wave','15','Unholy1','1160239650','2893')
                    10 Query      SELECT arcade_access, p_require FROM arbusergroup WHERE usergroupid = 1
                    10 Query      SELECT g.gid, g.gtitle, g.gname, g.gcat, cat.password, cat.active FROM arbgames_list AS g, arbgames_cats AS cat WHERE g.active=1 AND cat.active=1 AND g.gcat=cat.c_id AND trim(password)='' ORDER BY g.added DESC LIMIT 15
                    10 Query      SELECT g.gid, g.gtitle, g.gname, g.gcat, cat.password, cat.active FROM arbgames_list AS g, arbgames_cats AS cat WHERE g.active=1 AND cat.active=1 AND g.gcat=cat.c_id AND trim(password)='' ORDER BY g.gcount DESC LIMIT 15
                    10 Query      SELECT g.gid, g.gtitle, g.gname, g.gcat, cat.password, cat.active FROM arbgames_list AS g, arbgames_cats AS cat WHERE g.active=1 AND cat.active=1 AND g.gcat=cat.c_id AND trim(password)='' ORDER BY RAND() LIMIT 1
                    10 Query      SELECT g.gid, c.password from arbgames_list AS g, arbgames_cats AS c WHERE g.active=1 AND g.gcat=c.c_id AND trim(password)='' ORDER BY gcount
                    10 Query      SELECT * FROM arbgames_cats AS c WHERE c.active=1
                    10 Query      SELECT champ_gid AS GID, champ_mid AS MID, champ_name AS name, COUNT(champ_mid) AS total FROM arbgames_champs GROUP BY MID ORDER BY total DESC LIMIT 3
                    10 Query      SELECT user.userid, user.avatarid, user.avatarrevision, avatar.avatarpath, NOT ISNULL(filedata) AS hascustom, customavatar.dateline FROM arbuser AS user LEFT JOIN arbavatar AS avatar ON avatar.avatarid = user.avatarid LEFT JOIN arbcustomavatar AS customavatar ON customavatar.userid = user.userid WHERE customavatar.userid=4 OR user.userid=4
                    10 Query      SELECT user.userid, user.avatarid, user.avatarrevision, avatar.avatarpath, NOT ISNULL(filedata) AS hascustom, customavatar.dateline FROM arbuser AS user LEFT JOIN arbavatar AS avatar ON avatar.avatarid = user.avatarid LEFT JOIN arbcustomavatar AS customavatar ON customavatar.userid = user.userid WHERE customavatar.userid=15 OR user.userid=15
                    10 Query      SELECT user.userid, user.avatarid, user.avatarrevision, avatar.avatarpath, NOT ISNULL(filedata) AS hascustom, customavatar.dateline FROM arbuser AS user LEFT JOIN arbavatar AS avatar ON avatar.avatarid = user.avatarid LEFT JOIN arbcustomavatar AS customavatar ON customavatar.userid = user.userid WHERE customavatar.userid=1 OR user.userid=1
                    10 Query      SELECT g.gid, g.active, count(*) nb, g.bestscore, g.bestmid AS champ_mid, u.username AS champ_name FROM arbgames_list AS g INNER JOIN arbuser AS u ON u.userid=g.bestmid WHERE active=1 GROUP BY bestmid ORDER BY 3 DESC LIMIT 1
                    10 Query      SELECT user.userid, user.avatarid, user.avatarrevision, avatar.avatarpath, NOT ISNULL(filedata) AS hascustom, customavatar.dateline FROM arbuser AS user LEFT JOIN arbavatar AS avatar ON avatar.avatarid = user.avatarid LEFT JOIN arbcustomavatar AS customavatar ON customavatar.userid = user.userid WHERE customavatar.userid=4 OR user.userid=4
                    10 Query      SELECT demare, champion FROM arbtournaments
                    10 Query      SELECT tps.*, ta.tid FROM arbtournament_players_statut tps LEFT JOIN arbtournaments ta ON (tps.tid=ta.tid) WHERE tps.mid='15' AND tps.statut<'3' AND ta.demare = '1'
                    10 Query      SELECT cat_name, c_id, show_all, password, num_of_games, description FROM arbgames_cats WHERE active=1 ORDER BY pos ASC
                    10 Query      SELECT mid, gid, sum(position) AS position, sum(points) AS points FROM arbgames_league  GROUP BY mid ORDER BY points DESC LIMIT 1
                    10 Query      SELECT username FROM arbuser WHERE userid=4
                    10 Query      SELECT champion FROM arbtournaments
                    10 Query      SELECT DISTINCT(p.tid) FROM arbtournaments as t, arbtournament_players as p WHERE t.tid=p.tid AND t.champion='' AND p.mid = '15' ORDER BY t.datestarted ASC
                    10 Query      SELECT s.*, g.gtitle, g.decpoints, c.password FROM arbgames_scores AS s, arbgames_list AS g, arbgames_cats AS c WHERE s.gid=g.gid AND g.gcat=c.c_id AND trim(password)='' ORDER BY datescored DESC LIMIT 0,5
                    10 Query      SELECT c.*, g.gcat, cat.password FROM arbgames_champs AS c, arbgames_list AS g, arbgames_cats AS cat WHERE c.champ_gid=g.gid AND g.gcat=cat.c_id AND trim(password)='' ORDER BY champ_date DESC LIMIT 0,5
                    10 Query      SELECT mid, gid, sum(position) AS position, sum(points) AS points FROM arbgames_league GROUP BY mid ORDER BY points DESC LIMIT 1
                    10 Query      SELECT username FROM arbuser WHERE userid=4
                    10 Query      SELECT user.userid, user.avatarid, user.avatarrevision, avatar.avatarpath, NOT ISNULL(filedata) AS hascustom, customavatar.dateline FROM arbuser AS user LEFT JOIN arbavatar AS avatar ON avatar.avatarid = user.avatarid LEFT JOIN arbcustomavatar AS customavatar ON customavatar.userid = user.userid WHERE customavatar.userid=4 OR user.userid=4
                    10 Query      select g.*, c.password from arbgames_list as g
                    10 Query      SELECT g.bestmid, g.bestscore AS champ_score, g.gid AS champ_gid, g.decpoints, u.username AS champ_name FROM arbgames_list AS g INNER JOIN arbuser AS u ON u.userid=g.bestmid WHERE g.gid IN (4,1,9,8,7) ORDER BY g.gid
                    10 Query      SELECT mid, gid, score AS the_score, MAX(score) FROM arbgames_scores WHERE gid IN (4,1,9,8,7) AND mid=15 GROUP BY score
                    10 Query      SELECT * FROM arbgames_scores WHERE gid=4 ORDER BY score DESC, timespent ASC
                    10 Query      SELECT * FROM arbgames_scores WHERE gid=1 ORDER BY score DESC, timespent ASC
                    10 Query      SELECT * FROM arbgames_scores WHERE gid=9 ORDER BY score DESC, timespent ASC
                    10 Query      SELECT * FROM arbgames_scores WHERE gid=8 ORDER BY score DESC, timespent ASC
                    10 Query      SELECT * FROM arbgames_scores WHERE gid=7 ORDER BY score DESC, timespent ASC

scdurwood 10-24-2006 02:41 AM
THe was previous thread on here that addressed the known issue although I could not follow if a fix was actually released...

has there been any progress to fix these multiple queries? It's affecting my board as well.

ChrisTech 10-24-2006 05:04 AM
I hope there is, else I cannot re-enable this mod unless I go to a dedicated server, which just isn't in the budget right now. =(

Gemma 10-24-2006 07:45 AM
Try disabling score pruning,recording every score and the postbit info - see if that helps - also if you have a shoutbox or any other Ajax hack installed in the arcade remove that.

The score recording process has quite an impact on resources if you are storing every score.

Gemma

scdurwood 10-24-2006 08:21 AM
That's the problem.....I don't have any other AJAX hack installed, do not prune, do not use postbits, and only store the top score.

It appears that the script queires every score and every user each time a score is submitted. Once you get 3 or 4 users playing games that builds to a ton of queries that suffocate the server...

Looks like someone else figured out how to modify the code, but it hasn't been completely shared.

MrZeropage 10-24-2006 09:12 AM
I should do a setting in AdminCP to disable the league-system, this will reduce all those score-calculation-related things ... hmmmmm

TheBlackPoet 10-24-2006 09:17 AM
my host suspended me for using 20% of server resources a couple of times.. i didnt have maybe but a coupld in the games area.... and i couldnt understand what the hell was going on..
reading this thread, i'll be going back and looking at my on cron...

scdurwood 10-24-2006 11:08 AM
Quote:
Originally Posted by MrZeropage
I should do a setting in AdminCP to disable the league-system, this will reduce all those score-calculation-related things ... hmmmmm
what about making it an option to run on command instead of an automated process?

There's no need to update the ranking per game played anyways...

Better yet, can you make it a configurable timeframe in the ACP? In other words, each admin can choose the number of seconds between each calculation...

For the time being, can the function call be disabled without upsetting the "normal" usage of the arcade and if so, what code would I look for?

MrZeropage 10-24-2006 05:46 PM
Ok, I just improved the logic and the performance for the league-stuff and it now definitive has much less queries while saving a result :)

scdurwood 10-24-2006 10:50 PM
Is this a wait for the testing to be done sort of fix? ;)

Mark.B 10-25-2006 12:43 AM
Quote:
Originally Posted by scdurwood
what about making it an option to run on command instead of an automated process?

There's no need to update the ranking per game played anyways...

Better yet, can you make it a configurable timeframe in the ACP? In other words, each admin can choose the number of seconds between each calculation...

For the time being, can the function call be disabled without upsetting the "normal" usage of the arcade and if so, what code would I look for?
I could do with this as well Mr Zeropage sir, if you would be so kind.

I don't use the league at all, and I don't mind editing files to disable it. I have 472 games and score submission takes an age because of this.

MrZeropage 10-25-2006 07:13 AM
score-submission will be quick with v2.5.7+ I just cleaned up that code :)

Mark.B 10-25-2006 09:48 AM
Quote:
Originally Posted by MrZeropage
score-submission will be quick with v2.5.7+ I just cleaned up that code :)
Thank you Mr Zeropage. Great work!

Any chance of a "patch" of this for those of us on earlier versions for whom upgrading is not currently possible?

MrZeropage 10-25-2006 10:27 AM
this is kinda difficult as alot got changed, concerning the league it was somehow completely solved in another way.

Maybe you wait for v2.5.7+ and then compare all the files using "beyond compare" or any other tool, but best way is to always use the current release :)

icemanic 10-25-2006 07:53 PM
ITS SO CLOSE!!!!

99.98% DONE!!!!!!
I CANT WAIT!!!!!!!

im drooling more and more every day!

Mark.B 10-26-2006 12:25 AM
Quote:
Originally Posted by MrZeropage
this is kinda difficult as alot got changed, concerning the league it was somehow completely solved in another way.

Maybe you wait for v2.5.7+ and then compare all the files using "beyond compare" or any other tool, but best way is to always use the current release :)
Thanks Mr Z.

I do want to upgrade at some point, it is very hard for me though due to running both arcades on the same forum...I have to update all references to "arcade" and change it to "ibproarcade" so it doesn't clash with v3arcade. On top of that it's quite heavily customised skinwise.

(I should mention, before anyone points it out, that I'm aware there is no technical reason these days to run both arcades as the games interchange, however I like doing it!!)

ChrisTech 10-26-2006 06:12 AM
Quote:
Originally Posted by Mark.B
Thanks Mr Z.

I do want to upgrade at some point, it is very hard for me though due to running both arcades on the same forum...I have to update all references to "arcade" and change it to "ibproarcade" so it doesn't clash with v3arcade. On top of that it's quite heavily customised skinwise.

(I should mention, before anyone points it out, that I'm aware there is no technical reason these days to run both arcades as the games interchange, however I like doing it!!)
Ahh, someone who enjoys a challenge...

I'm glad I'm not you. :P

ChrisTech 10-30-2006 08:58 PM
Anywho who had an issue with the 2.5.6 have this same issue with 2.5.7?

Asking before I bother to upgrade it.

ChrisTech 11-05-2006 02:10 PM
The newer version seems to of fixed the system resource issue, knock on wood.

=)

MrZeropage 11-05-2006 04:37 PM
Yes, that's what I told in the Release-History ;)


All times are GMT. The time now is 06:38 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01354 seconds
  • Memory Usage 2,112KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (24)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete