Server lag after using MySQL in the gamemode - Printable Version
+- SA-MP Forums Archive (
https://sampforum.blast.hk)
+-- Forum: SA-MP Server (
https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (
https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: Server lag after using MySQL in the gamemode (
/showthread.php?tid=321350)
Server lag after using MySQL in the gamemode -
dgcyears - 26.02.2012
Hello! We have put our GM on MySQL, but it kinda lags when there are something like 2-3 players online. It is sure from the script and not from the host as it was working fine before putting mysql onto it and + we played some time on Grand Larency and no damn lag. Also if you type while jumping the text delays with 1-2 seconds. It is really annoying, can someone help us? Thanks!
Re: Server lag after using MySQL in the gamemode -
Vince - 26.02.2012
Use threaded queries and just don't send an overload of queries and you should be fine.
Re: Server lag after using MySQL in the gamemode -
dgcyears - 26.02.2012
I don't really get what you mean, could you give me an example please? Sorry but i'm a newbie when it comes about scripting.
Re: Server lag after using MySQL in the gamemode -
dgcyears - 26.02.2012
Bump! Anyone?
Re: Server lag after using MySQL in the gamemode -
RBTDM - 27.02.2012
May i Know Which Host You use.
Try To Contact Your Host Owner or Supporters
Re: Server lag after using MySQL in the gamemode -
dgcyears - 27.02.2012
It is a romanian host. I tried to contact them, but they say it is from the script as well.
Re: Server lag after using MySQL in the gamemode -
dgcyears - 27.02.2012
bump
Re: Server lag after using MySQL in the gamemode -
ColorHost-Kevin - 27.02.2012
Is your MYSQL in a different location/server then your gameserver?
This has known to cause quite some issues as well.
Re: Server lag after using MySQL in the gamemode -
dgcyears - 28.02.2012
No, the MySQL database runs on the same location.
Re: Server lag after using MySQL in the gamemode -
Abbott - 28.02.2012
Quote:
Originally Posted by dgcyears
No, the MySQL database runs on the same location.
|
How big is the database?
There could possibly be restrictions with the my.ini file, have you tried contacting your host?