Extremely HUGE MySQL usage - 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: Extremely HUGE MySQL usage (/showthread.php?tid=348070)

---

Extremely HUGE MySQL usage - Tee - 04.06.2012

I decided to go through optimizing my gamemode. Then I saw that I had 199 "mysql_free_result()" functions and only 165 "mysql_store_result()" functions, so I went through fixing that. Then checked again and had 165 of both functions. So I thought everything was okay. But to my surprise, when I loaded the gamemode, the RAM started to immensely increase (went up to 2,000 in less than 6 minutes)

I'm using BlueG's MySQL plugin. Here's a screenshot:



Does anyone know what could be the problem? Or what could be causing the leak?

Extra information: I locked the server and watched it for a while. With no one online, it was a steady 24.00 MB, but as soon as I connected it started to double (and I'm not yet logged in) I only have 3 freeing and storing functions under OnPlayerConnect.

---

Re: Extremely HUGE MySQL usage - Rudyy - 10.06.2012

too many sql queries ?

---

Re: Extremely HUGE MySQL usage - Calgon - 10.06.2012

R7 is known to have a memory leak problem. Someone released an update which contains a fix to it, but it hasn't been approved of by the original author (BlueG).

EDIT: Rudyy, you practically necroposted.

---