Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > Premium Archives > ibProArcade Archive
Reload this Page Excessive System Resource Issue
FAQ Community Calendar Today's Posts Search

Reply
Page 1 of 3 1 23
 
Thread Tools
Excessive System Resource Issue Details »»
Excessive System Resource Issue
Version: , by ChrisTech ChrisTech is offline
Developer Last Online: Jun 2020 Show Printable Version Email this Page
Version: Unknown Rating:
Released: 10-16-2006 Last Update: Never Installs: 0
 
No support by the author.

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

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 10-18-2006, 02:18 AM
Mysticales's Avatar
Mysticales Mysticales is offline
 
Join Date: Oct 2005
Posts: 168
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Wondering if you have your cron setup in a way thats making it keep running over and over, check your crons.
Reply With Quote
  #3  
Old 10-18-2006, 05:29 PM
ChrisTech ChrisTech is offline
 
Join Date: Oct 2005
Location: St. Louis, MO
Posts: 105
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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?
Reply With Quote
  #4  
Old 10-18-2006, 06:38 PM
CompuJonathan CompuJonathan is offline
 
Join Date: Nov 2004
Location: Georgia, USA
Posts: 66
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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
Reply With Quote
  #5  
Old 10-19-2006, 05:24 PM
ChrisTech ChrisTech is offline
 
Join Date: Oct 2005
Location: St. Louis, MO
Posts: 105
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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
Reply With Quote
  #6  
Old 10-24-2006, 02:41 AM
scdurwood scdurwood is offline
 
Join Date: Aug 2006
Posts: 69
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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.
Reply With Quote
  #7  
Old 10-24-2006, 05:04 AM
ChrisTech ChrisTech is offline
 
Join Date: Oct 2005
Location: St. Louis, MO
Posts: 105
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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. =(
Reply With Quote
  #8  
Old 10-24-2006, 07:45 AM
Gemma's Avatar
Gemma Gemma is offline
 
Join Date: Apr 2004
Location: Scotland
Posts: 1,229
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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
Reply With Quote
  #9  
Old 10-24-2006, 08:21 AM
scdurwood scdurwood is offline
 
Join Date: Aug 2006
Posts: 69
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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.
Reply With Quote
  #10  
Old 10-24-2006, 09:12 AM
MrZeropage's Avatar
MrZeropage MrZeropage is offline
 
Join Date: Nov 2003
Location: Munich, Germany
Posts: 3,012
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I should do a setting in AdminCP to disable the league-system, this will reduce all those score-calculation-related things ... hmmmmm
Reply With Quote
Reply
Page 1 of 3 1 23

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT. The time now is 03:58 PM.

Contact Us - Archive - Top

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.09712 seconds
  • Memory Usage 2,433KB
  • Queries Executed 23 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (2)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (9)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 
Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete