MySQL Loading Slowly after upgrade to 0.3dl - 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: MySQL Loading Slowly after upgrade to 0.3dl (/showthread.php?tid=655577)

---

MySQL Loading Slowly after upgrade to 0.3dl - Dokins - 24.06.2018

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?

---

Re: MySQL Loading Slowly after upgrade to 0.3dl - GTLS - 24.06.2018

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.

---

Re: MySQL Loading Slowly after upgrade to 0.3dl - Dokins - 24.06.2018

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.

---

Re: MySQL Loading Slowly after upgrade to 0.3dl - Calisthenics - 24.06.2018

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

---

Re: MySQL Loading Slowly after upgrade to 0.3dl - Dokins - 24.06.2018

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

---

Re: MySQL Loading Slowly after upgrade to 0.3dl - DerickClark - 24.06.2018

Thank you for sharing i used this.

---

Re: MySQL Loading Slowly after upgrade to 0.3dl - Dokins - 24.06.2018

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

---