Posts: 1,648
Threads: 482
Joined: Jun 2010
I'm currently using MySQL r39-3 for my server, I've not started it in a long time and I've just upgraded to 0.3DL - R1.
When I send for a login, it takes a LONG time to spawn. Is this just a case of updating a MySQL plugin?
Posts: 1,071
Threads: 24
Joined: Aug 2014
Reputation:
0
Didnt happen to me when I upgraded from 0.3.7 to 0.3DL. Its probably because you're running some kind of big loop before a player logs in. Post the Code which lets user log in and spawn.
Posts: 1,648
Threads: 482
Joined: Jun 2010
There's a lot of sections for that. I'll double check and get back to you. I don't think I'm running any loops currently.
Posts: 1,228
Threads: 1
Joined: May 2018
Reputation:
0
mysql_log + ALL will slow down your queries. Check this first.
Posts: 1,648
Threads: 482
Joined: Jun 2010
I don't have that on. I'm not sure why at all.
EDIT: Resolved.
Sleep mode was set to 0.
More info:
https://sampwiki.blast.hk/wiki/Server.cfg
Posts: 1,648
Threads: 482
Joined: Jun 2010
No problem, I understand the feeling when someone resolves without explaining how.