PDA

View Full Version : Excessive System Resource Issue

ChrisTech
10-16-2006, 03:34 AM
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?



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','1 322')
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','143 0')
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','2 974')
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','849 0')
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','32 097')
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','27 5')
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.


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.



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','2559 5')
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','116007344 0','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','116015 3523','8740')
10 Query INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ _date,champ_score) VALUES ('73','Castlevania','4','oldschooljunky','11600718 25','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','148 5')
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','13000 0')
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','116022483 4','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','1 8820')
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','19 79')
10 Query INSERT INTO arbgames_champs (champ_gid,champ_gtitle,champ_mid,champ_name,champ _date,champ_score) VALUES ('100','Pong','4','oldschooljunky','1160066164','6 9')
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','116006 4872','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','69 6')
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','7 0517')
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
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
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
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
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
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 ;)