[iAnonymous]

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]

[Crystallize]

Try changing the DB because it's overloaded purchase to a higher plan
Oh also can you post the register command function please

[ViniBorn]

The problem started after reaching 100000 registered players?

[Vince]

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.

[iAnonymous]

Quote:

Originally Posted by ViniBorn The problem started after reaching 100000 registered players?

Yea.

[Crystallize]

Definitely DB problem try upgrading it
P.S : players are getting freezed because it's taking time to save(write)the account

[iAnonymous]

So you mean we have to increase MYSQL Host size ?

[Crystallize]

Yes because it's taking time to write the user that's why player gets freezed

[iAnonymous]

Quote:

Originally Posted by WizzardY 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 ?

[Crystallize]

The DB itself as I said it's overloaded btw can you send the dedicated spec's aswell?