MySQL Loading Slowly after upgrade to 0.3dl
#1

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

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

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

mysql_log + ALL will slow down your queries. Check this first.
Reply
#5

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
Reply
#6

Quote:
Originally Posted by Dokins
Посмотреть сообщение
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
Thank you for sharing i used this.
Reply
#7

No problem, I understand the feeling when someone resolves without explaining how.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)