[wups]

My sa-mp server eats more memory everyday the server is on(about +5mb per day). After a server restart everything gets back to normal. So my first guess was that I missed mysql_free_result(). I checked all mysql_store_result() and didn't find any place that mysql_free_result() was missed.
Any other ideas?

[T0pAz]

How can you be so sure that it's mysql problem. It can also be a problem on OnPlayerUpdate loop or timer loop.

[wups]

Quote:

Originally Posted by T0pAz How can you be so sure that it's mysql problem. It can also be a problem on OnPlayerUpdate loop or timer loop.

Where did I say, that I'm sure it's a mysql problem? That was only a guess.
AFAIK PAWN used memory is always the same, so my guess that it's a problem related to plugins.

[T0pAz]

Quote:

Originally Posted by wups Where did I say, that I'm sure it's a mysql problem? That was only a guess. AFAIK PAWN used memory is always the same, so my guess that it's a problem related to plugins.

Are you 100% sure that it happens every time?

[wups]

Quote:

Originally Posted by T0pAz Are you 100% sure that it happens every time?

Yes, memory usage rises at random times.

[milanosie]

Things to check:

1. Does it do something weird at OnPlayerDisconnect?
2. Do you have a lot of oversized strings?
3. Do you use multiple saving systems or just one?
4. Is it a remote MySQL server or local ( remote takes memory for connecting and receiving the data trough a secured connection)

[T0pAz]

Use this plugin and show me the log.

[The King's Bastard]

Which plugins are you using?

[wups]

Quote:

Originally Posted by The King's Bastard Which plugins are you using?

sscanf(version 2)
mysql(R6 by BlueG)
streamer(by Incognito)

Quote:

Originally Posted by T0pAz Use this plugin and show me the log.

I don't think it's a good idea to use it on a live server.

[wups]

Sorry for bumping, but i really need help.