Page 1 of 1

mysql slow?

Posted: Wed Apr 04, 2007 10:08 am
by kp_downarrow
so i was testing the mysql save xp thing, and i dont know why but it is really slow

the database is on my own computer AND i have counter strike playing

the ping in counter strike is 60ms
when someone says changerace, it takes 10 seconds for the race menu to show up, i monitored my bandwidth usage, it is no where near full

i do not think that its my server host that limits mysql bandwidth

anyone else use mysql?


War3ft Version: rc3
Amxmodx Version: 1.76?

Posted: Wed Apr 04, 2007 1:34 pm
by Geesu
You need to be more specific

Same computer:
- half life server
- mysql sever
- game client running?

if so - yea it's going to run like shit

Posted: Wed Apr 04, 2007 2:02 pm
by kp_downarrow
CS1.6 SERVER @ chicago

CSclient&MySQL server @ california

game ping: ~70

changerace menu delay: 10 seconds

Posted: Wed Apr 04, 2007 8:34 pm
by Geesu
what is the ping from the chicago server to the CA one - sounds like that is why there is lag... remember that game servers react INSTANTLY - so a 70ms ping is very high, you need the ping to the mysql server to be under 10, ideally