I've had a situation where vServer used 95% of RAM and all connections were slow.
Is there any way to release memory?
Restart solved the problem but it is not regular.
regards,
Zoran
Please check, that cursors are destroyed. Judging on the vServer logs you sent me recently - there are tons of cursors - living but not used.
Hi,
A Cursor can be destroyed only by who have created it.
Cursor not always means a lot of RAM. It depends on query. Some cursors can select only 1 record, other can select a lot of records.
Good advice is - use a query that selects a small number of records.
Hi,
A Cursor can be destroyed only by who have created it.
Cursor not always means a lot of RAM. It depends on query. Some cursors can select only 1 record, other can select a lot of records.
Good advice is - use a query that selects a small number of records.
Connections crashes should be ok - it is just "unexpected connection termination" for vServer.
Cursors are destroyed either by calling vCursor's destructor on particular connection side or by closing vClient database/connection.
All scenarios above lead to closing vServer-side cursors.
Also, vServer may decide to disconnect some client (idle timeout for example). In this case its cursors will be destroyed as well.
I guess you have some long-running connections which are not destroying own cursors. There are no external way to destroy such cursors except killing such connections.
But better check your client-side workflow - obviously there are dangling objects and memory leaks.
Connections crashes should be ok - it is just "unexpected connection termination" for vServer.
Cursors are destroyed either by calling vCursor's destructor on particular connection side or by closing vClient database/connection.
All scenarios above lead to closing vServer-side cursors.
Also, vServer may decide to disconnect some client (idle timeout for example). In this case its cursors will be destroyed as well.
I guess you have some long-running connections which are not destroying own cursors. There are no external way to destroy such cursors except killing such connections.
But better check your client-side workflow - obviously there are dangling objects and memory leaks.
I will try to reproduce it first - send me the vServer log pleaseAny news?