SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Scripting Help

Reply
 
Thread Tools Display Modes
Old 04/08/2014, 10:09 PM   #1
iAnonymous
Gangsta
 
iAnonymous's Avatar
 
Join Date: Jun 2013
Location: Kingdom of Saudi Arabia
Posts: 809
Reputation: 154
Default Registration Causes Lag [ MYSQL ]. 50-100 Players getting Paused at a time

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]
__________________
Opening a community? Contact me to ask any sort of questions. I'm experienced with handling communities having over 100+ players in their servers all the time. I need no cash, no admin status or anything else. Helping is all I wanna do for now. I can help with dedicated servers and VPSs, Hosts, DDOS protections, Forums.


Experienced EX-Administrator and EX-Management team member of Limitless Gaming Community [www.Lgsamp.com]
[2012-2015]
P.S: I can help you not host for you
iAnonymous is offline   Reply With Quote
Old 04/08/2014, 10:32 PM   #2
Crystallize
High-roller
 
Join Date: Aug 2013
Posts: 1,555
Reputation: 293
Default Re: Registration Causes Lag [ MYSQL ]. 50-100 Players getting Paused at a time

Try changing the DB because it's overloaded purchase to a higher plan
Oh also can you post the register command function please
Crystallize is offline   Reply With Quote
Old 04/08/2014, 10:35 PM   #3
ViniBorn
Godfather
 
ViniBorn's Avatar
 
Join Date: Aug 2010
Location: Brasília
Posts: 5,338
Reputation: 719
Default Re: Registration Causes Lag [ MYSQL ]. 50-100 Players getting Paused at a time

The problem started after reaching 100000 registered players?
__________________




CONTATO: F A C E B O O K: @vinibornpawn


GameMode = Modo de jogo = Masculino
Colabore com os olhos de quem lê. Não diga "Minha GM"!
ViniBorn is offline   Reply With Quote
Old 04/08/2014, 10:38 PM   #4
Vince
Spam Machine
 
Vince's Avatar
 
Join Date: Sep 2007
Location: Belgium
Posts: 11,045
Reputation: 2647
Default Re: Registration Causes Lag [ MYSQL ]. 50-100 Players getting Paused at a time

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.
__________________
Vince is offline   Reply With Quote
Old 04/08/2014, 10:38 PM   #5
iAnonymous
Gangsta
 
iAnonymous's Avatar
 
Join Date: Jun 2013
Location: Kingdom of Saudi Arabia
Posts: 809
Reputation: 154
Default Re: Registration Causes Lag [ MYSQL ]. 50-100 Players getting Paused at a time

Quote:
Originally Posted by ViniBorn View Post
The problem started after reaching 100000 registered players?
Yea.
__________________
Opening a community? Contact me to ask any sort of questions. I'm experienced with handling communities having over 100+ players in their servers all the time. I need no cash, no admin status or anything else. Helping is all I wanna do for now. I can help with dedicated servers and VPSs, Hosts, DDOS protections, Forums.


Experienced EX-Administrator and EX-Management team member of Limitless Gaming Community [www.Lgsamp.com]
[2012-2015]
P.S: I can help you not host for you
iAnonymous is offline   Reply With Quote
Old 04/08/2014, 10:42 PM   #6
Crystallize
High-roller
 
Join Date: Aug 2013
Posts: 1,555
Reputation: 293
Default Re: Registration Causes Lag [ MYSQL ]. 50-100 Players getting Paused at a time

Definitely DB problem try upgrading it
P.S : players are getting freezed because it's taking time to save(write)the account
Crystallize is offline   Reply With Quote
Old 04/08/2014, 10:45 PM   #7
iAnonymous
Gangsta
 
iAnonymous's Avatar
 
Join Date: Jun 2013
Location: Kingdom of Saudi Arabia
Posts: 809
Reputation: 154
Default Re: Registration Causes Lag [ MYSQL ]. 50-100 Players getting Paused at a time

So you mean we have to increase MYSQL Host size ?
__________________
Opening a community? Contact me to ask any sort of questions. I'm experienced with handling communities having over 100+ players in their servers all the time. I need no cash, no admin status or anything else. Helping is all I wanna do for now. I can help with dedicated servers and VPSs, Hosts, DDOS protections, Forums.


Experienced EX-Administrator and EX-Management team member of Limitless Gaming Community [www.Lgsamp.com]
[2012-2015]
P.S: I can help you not host for you
iAnonymous is offline   Reply With Quote
Old 04/08/2014, 10:52 PM   #8
Crystallize
High-roller
 
Join Date: Aug 2013
Posts: 1,555
Reputation: 293
Default Re: Registration Causes Lag [ MYSQL ]. 50-100 Players getting Paused at a time

Yes because it's taking time to write the user that's why player gets freezed
Crystallize is offline   Reply With Quote
Old 04/08/2014, 11:33 PM   #9
iAnonymous
Gangsta
 
iAnonymous's Avatar
 
Join Date: Jun 2013
Location: Kingdom of Saudi Arabia
Posts: 809
Reputation: 154
Default Re: Registration Causes Lag [ MYSQL ]. 50-100 Players getting Paused at a time

Quote:
Originally Posted by WizzardY View Post
Yes because it's taking time to write the user that's why player gets freezed
I know that but what is causing it to take too long to write ?
__________________
Opening a community? Contact me to ask any sort of questions. I'm experienced with handling communities having over 100+ players in their servers all the time. I need no cash, no admin status or anything else. Helping is all I wanna do for now. I can help with dedicated servers and VPSs, Hosts, DDOS protections, Forums.


Experienced EX-Administrator and EX-Management team member of Limitless Gaming Community [www.Lgsamp.com]
[2012-2015]
P.S: I can help you not host for you
iAnonymous is offline   Reply With Quote
Old 05/08/2014, 12:00 AM   #10
Crystallize
High-roller
 
Join Date: Aug 2013
Posts: 1,555
Reputation: 293
Default Re: Registration Causes Lag [ MYSQL ]. 50-100 Players getting Paused at a time

The DB itself as I said it's overloaded btw can you send the dedicated spec's aswell?
Crystallize is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
paused players.... burnuk General 5 01/04/2013 02:46 AM
Is it possible to auto kick paused players without using onplayerupdate? 101 Scripting Help 13 17/01/2013 07:19 PM
Help getting total time paused Mishima Scripting Help 4 13/07/2012 04:06 AM
Detecting paused players? Twisted_Insane Scripting Help 6 14/04/2012 06:24 PM
Kicking Paused Players Michael[NBK] Scripting Help 3 11/11/2011 09:53 PM


All times are GMT. The time now is 10:29 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.