Registration Causes Lag [ MYSQL ]. 50-100 Players getting Paused at a time - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Registration Causes Lag [ MYSQL ]. 50-100 Players getting Paused at a time (/showthread.php?tid=529968)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Registration Causes Lag [ MYSQL ]. 50-100 Players getting Paused at a time (/showthread.php?tid=529968)
Registration Causes Lag [ MYSQL ]. 50-100 Players getting Paused at a time - iAnonymous - 04.08.2014
Hello Everyone.
These days Our server is facing an very ODD problem. The problem is that whenever someone tries to register in the server it makes OTHER players lag like hell They all go AFK for 5-6 seconds and then they continue.
We have like 100500+ Players registered in the server. This lag caused our playerbase to decrease from 150-160 to Just 50-70.
Please have a look here in this video which will explain the matter very clearly to you.
The guy in the STAFF uniform is acting as an player and I am trying to catch him BUT when a player named " Zz Victor zZ " Joined and tried to register The Staff member suddenly went AFK and then came back to normal position.
NOTE :
The MYSQL HOST and Server is hosted on the same dedi/vps.
[ame]http://www.youtube.com/watch?v=aHP6hDkln1k[/ame]
Re: Registration Causes Lag [ MYSQL ]. 50-100 Players getting Paused at a time - Crystallize - 04.08.2014
Try changing the DB because it's overloaded purchase to a higher plan
Oh also can you post the register command function please
Re: Registration Causes Lag [ MYSQL ]. 50-100 Players getting Paused at a time - ViniBorn - 04.08.2014
The problem started after reaching 100000 registered players?
Re: Registration Causes Lag [ MYSQL ]. 50-100 Players getting Paused at a time - Vince - 04.08.2014
Use threaded queries for a start. Also, since you have a large database, make sure that it is properly indexed. Use the explain command extensively. Avoid full table scans.
Re: Registration Causes Lag [ MYSQL ]. 50-100 Players getting Paused at a time - iAnonymous - 04.08.2014
Quote:
|
Originally Posted by ViniBorn
 The problem started after reaching 100000 registered players?
|
Re: Registration Causes Lag [ MYSQL ]. 50-100 Players getting Paused at a time - Crystallize - 04.08.2014
Definitely DB problem try upgrading it
P.S : players are getting freezed because it's taking time to save(write)the account
Re: Registration Causes Lag [ MYSQL ]. 50-100 Players getting Paused at a time - iAnonymous - 04.08.2014
So you mean we have to increase MYSQL Host size ?
Re: Registration Causes Lag [ MYSQL ]. 50-100 Players getting Paused at a time - Crystallize - 04.08.2014
Yes because it's taking time to write the user that's why player gets freezed
Re: Registration Causes Lag [ MYSQL ]. 50-100 Players getting Paused at a time - iAnonymous - 04.08.2014
Quote:
|
Originally Posted by WizzardY
Yes because it's taking time to write the user that's why player gets freezed
|
Re: Registration Causes Lag [ MYSQL ]. 50-100 Players getting Paused at a time - Crystallize - 04.08.2014
The DB itself as I said it's overloaded btw can you send the dedicated spec's aswell?