Convex self hosted on my sql
Hi I have been running a self hosted convex instance with MySQL backend for a side project.
I noticed that the document table growth is linear even if the amount of documents in the system is stable.
From the very helpful doc AI I have learned.
Old versions are not immediately deleted from the log, which explains why the table grows and does not shrink even as documents are deleted or updated How Convex Works: The Transaction Log.
If you are concerned about storage growth, you may want to look into any available log compaction or pruning features in future Convex releases, but as of the information in the knowledge sources, this is the expected behavior.
Does anybody know of a way of running housekeeping manually?
BR
I noticed that the document table growth is linear even if the amount of documents in the system is stable.
From the very helpful doc AI I have learned.
Old versions are not immediately deleted from the log, which explains why the table grows and does not shrink even as documents are deleted or updated How Convex Works: The Transaction Log.
If you are concerned about storage growth, you may want to look into any available log compaction or pruning features in future Convex releases, but as of the information in the knowledge sources, this is the expected behavior.
Does anybody know of a way of running housekeeping manually?
BR
