My db file size after inserting the application data is 2,512,064 KB. We have a inbuilt purge logic, which deletes the data after a specific duration. This is because of the limited disk size we have for DB.
But when I delete the data in soliddb, I do no see any change in the file size. But if I shutdown the DB and run the reorganize command, I see the file size has reduced.
Shutting down the DB is not a choice in production, can you let me know what is the alternative solution for this?
This topic has been locked.
1 reply Latest Post - 2013-03-21T13:27:58Z by vakkila
Pinned topic Reducing the db file size without using the reorganize option
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-03-21T13:27:58Z at 2013-03-21T13:27:58Z by vakkila
vakkila 270001JJKB7 PostsACCEPTED ANSWER
Re: Reducing the db file size without using the reorganize option2013-03-21T13:27:58Z in response to SystemAdminHi,
Unfortunately there is no alternative; the only way to compact the database files is to shutdown the server and then restart it using the '-x reorganize' option.