[Tom_Dedi]

Hello,

I have a problem with my server
the server save all accounts, cars .. in MYSQL
but if a user join the server the workmemory from server was constant 15,4 MB
if a user left the server or update his account the workmemory from server go up 2 MB and have than 17,4 MB
with cars and houses need the server after 5 hours 1,9 GB workmemory from server why
only with update I have this problem
here the source from update
http://www.downloads.realoa.de/SAMP/update.rar


-dedi

[iLinx]

Could be the result, I see you storing it but not freeing it. A server using 1.9GB of RAM though, never heard of that one before, even heavily modded srcds servers dont use that much.

[Tom_Dedi]

how i fix the problem?

[Memoryz]

Are you talking about RAM or DiskSpace?

Try restarting the SA-MP server every 2-3 hours to try and clear variables.

[Tom_Dedi]

this is a good idea but I dont want this
i want fix this problem without restart
i mean RAM not Diskspace

[iLinx]

free_result, refer to your mysql plugin's documentation to find the function to use to free the data stored by the query.

[Miguel]

How often is that code getting called?

[Tom_Dedi]

ever the player account get money or died or left the server
ever the player account updated