Login to download the latest version of Mint and your favorite Pepper, purchase additional licenses, or post in the Forum. Don't have an account? Create one!

In Partnership with Media Temple

Mint Forum

Reducing database size?

So from some issue with my installation of Mint 1, I had changed the setting of Mint for a high traffic site of mine to not limit the size of the database. Upgrading to Mint 2 obviously inherited this setting and I had totally forgotten about it.

Now the mint_visit database is over 165MB. How can I get this down? I changed the limit setting to 50MB but it’s yet to change anything.

Is there something else I should do?

Sam Brown
Third-Party Pepper Developer
Posted on Mar 22, '07 at 02:38 am

As time passes the old data will expire and your database size should drop.

Till
Third-Party Pepper Developer
Posted on Mar 22, '07 at 03:28 am

The database should be cleaned on every record and saving the preferences.

Ah okay…I checked it this morning and sure enough it has reduced itself to around 16MB.

Shaun Inman
Mint/Pepper Developer
Posted on Mar 22, '07 at 11:00 am

The database should be cleaned on every record and saving the preferences.

It should be cleared when saving the Preferences but not on every record. _tidySave() is called on every record but only actually cleans up once an hour.

Rather than making Mint user’s set up a cron job for database maintenance Mint assumes that you are receiving visits pretty regularly. If you’re not, then there’s no additional data to remove. It works out pretty well.

You must be logged in to reply. Login above or create an account