How to reduce MongoDB storage space after deleting a large amount of data

Question

I have a database in MongoDB, called dump. Currently, it reached 6GB in my server. I decided to delete 90% of data in this database to reduce the disk space it occupied. But after doing that its size is still 6GB, while the true storage size is only 250MB.

I guess this is the design of MongoDB? Is there any convinient way to reduce its size? Thank in advance.

score 18 · Accepted Answer · edited Mar 14 '17 at 12:36

18

Try (source):

$ mongo mydb
> db.repairDatabase()

edited Mar 14 '17 at 12:36

Himavanth

400
5
15

answered May 27 '11 at 11:17

Denis de Bernardy

75,850
13
131
154

1

Sadly, that doens't work with MongoDB 1.8 and journaling enabled. – David Raab May 30 '11 at 09:22

score 5 · Answer 2 · answered May 27 '11 at 12:46

5

To compress the data files, you can run either start up MongoDB with mongod --repair, or connect to the database through the shell and run db.repairDatabase().

There's also a new compact command scheduled for v1.9 that will do in-place compaction.

answered May 27 '11 at 12:46

Chris Fulstow

41,170
10
86
110

5

fyi for 'compact' the docs say: "This operation will not reduce the amount of disk space used on the filesystem. Storage size is the amount of data allocated within the database files, not the size/number of the files on file system." Repair is still the only option to recover disk space. – Darryl E. Clarke Feb 01 '12 at 18:52

How to reduce MongoDB storage space after deleting a large amount of data

2 Answers2