Topic
  • 1 reply
  • Latest Post - ‏2013-03-21T13:27:58Z by vakkila
SystemAdmin
SystemAdmin
115 Posts

Pinned topic Reducing the db file size without using the reorganize option

‏2013-03-19T05:45:06Z |
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?
Updated on 2013-03-21T13:27:58Z at 2013-03-21T13:27:58Z by vakkila
  • vakkila
    vakkila
    7 Posts

    Re: Reducing the db file size without using the reorganize option

    ‏2013-03-21T13:27:58Z  
    Hi,

    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.

    -katriina