Take the 2-minute tour ×
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. It's 100% free, no registration required.

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

1 Answer 1

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? –  snot waffle Mar 18 at 15:45
    
Yes. This concept is also in PostgrSQL : postgresql.org/docs/current/static/sql-vacuum.html –  RolandoMySQLDBA Mar 18 at 15:59

Your Answer

 
discard

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.