Database Size is very large

[kennyhoward]

I am concerned that my zencart database is too large. At last check, it was over 800mb.

What data can I dispose of? The cart is currently running 1.3.7.1 and I am in the process of upgrading it to 1.3.9f - I want to do some major house cleaning on the site and remove all old/outdated addons. I am also considering removing order history if that is going to reduce the size of the database considerably. The site has been operating since March of 2008.

Any advice would be appreciated.

[DrByte]

If you've got it set to archive all outgoing emails, then you could truncate/empty the email_archive table in the database and turn off email archiving: Admin->Configuration->Email Options.

You could optionally also prune the admin_activity_log table if you've got a backup up its content.

Naturally, you should make a complete backup of the data, and store it for safe keeping along with your business sales and tax records, before you go deleting anything.

[nigelt74]

Wow thats big

can you see what tables are large via phpmyadmin?

have you "optimised" the tables

admin --> Tools --> Store manager --> Optimize Database (2nd to last option)

although when i ran it, it only reduced my db size fractionally


and emptied the admin activity log (the annoying message you get) same page as above

[kennyhoward]

user_tracking was the table that was the culprit! I have purged all data.

Size was: 899.2 MiB

Size now is: 20.4 MiB

Wow! I didn't realize this add-on could just run wild like that.

I won't be including it when I upgrade.

[samar777]

user_tracking was the table that was the culprit! I have purged all data.

Size was: 899.2 MiB

Size now is: 20.4 MiB

Wow! I didn't realize this add-on could just run wild like that.

I won't be including it when I upgrade.

How did you accomplish this? Whats the query/ patch that you ran, to purge data in that table.

[kennyhoward]

TRUNCATE TABLE user_tracking;

I also disabled the add-on in the admin panel. I had ran the function within the admin panel to empty the past entries, but nothing happened. So I had to manually empty the table.