Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I've had a look at the help documentation for Base 2, as well as Menial's product page, but haven't found an answer there. I've even clicked on the vacuum button and not noticed any change. What does that button do?

share|improve this question
up vote 2 down vote accepted

DISCLAIMER : Not a Menial Base 2 person

VACUUM is a sqlite operation for defragmenting tables and tablespaces. It also helps reclaim diskspace.

It defragments all sqlite tables by copying data from the sqlite tables to a temp tablespace. The VACUUM operation will then swap out the old tablespace and use the new one. Database pages lost due to DELETEs and UPDATEs will no longer exist.

MONyog also uses sqlite tables for collecting database statistics and features a VACUUM operation.

share|improve this answer
So it's analogous to defragmenting the database? – Agi Hammerthief Mar 18 '14 at 15:45
Yes. This concept is also in PostgrSQL : – RolandoMySQLDBA Mar 18 '14 at 15:59

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.