Server lag after using MySQL in the gamemode
#1

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!
Reply
#2

Use threaded queries and just don't send an overload of queries and you should be fine.
Reply
#3

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.
Reply
#4

Bump! Anyone?
Reply
#5

May i Know Which Host You use.
Try To Contact Your Host Owner or Supporters
Reply
#6

It is a romanian host. I tried to contact them, but they say it is from the script as well.
Reply
#7

bump
Reply
#8

Is your MYSQL in a different location/server then your gameserver?

This has known to cause quite some issues as well.
Reply
#9

No, the MySQL database runs on the same location.
Reply
#10

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?
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)