Mautic Community Forums

Database run up to 1GB! Issue

Guys, i have unexpected problem with one mautic installation. Can you help me with this?



It turns out that my table email_copies in the database is increasing rapidly to about 700 МВ. And some other as well. This does not look to me normal. Can someone help me to resolve it?

Guys, i have unexpected problem with one mautic installation. Can you help me with this?

It turns out that my table email_copies in the database is increasing rapidly to about 700 МВ. And some other as well. This does not look to me normal. Can someone help me to resolve it?

My biggest tables are as follows:

email_copies	~19,270 raws  - 712.6 MiB	-
email_stats		~25,244 raws  - 99.1 MiB	-
page_hits		~82,405 raws -	64.6 MiB	-
audit_log		~84,597 raws - 	29.6 MiB	-
campaign_lead_event_log	~80,341 raws - 21 MiB	-
ip_addresses	~28,044 raws - 19 MiB	-

I have only 6000 leads. How do i clear them or reduce the size? Thanks in advance,

What would happen if i empty the table?

Have you tried to go to phpmyadmin and optimize each table. I don’t think It resolve the problem but you can get some space…

The way I understand it, Mautic keeps copies of your email for the web view links. To reduce the size, you could remove all rows whose creation date is greater than 2 months (or whatever arbitrary date range you want to choose), that way you’re not keeping really old email copies that probably don’t need to be kept any longer.

We’re considering putting in the ability to purge old entries from these tables.

Hi @DonGilbert, “We’re considering putting in the ability to purge old entries from these tables.” any news on that? My email_stats table is 1,2Gb! I’m also experiencing high Mysql CPU usage, I wonder if this big tables could be the problem.
Thanks

+1

I have the same issue.

What can I delete? My biggest table is audit_log.

What is this useful to? Can I delete everything? Will it delete my leads datas (as first name, last name…) or just the email copies and unuseful datas?

By the way, which mysql request can I apply to make an automation to delete unuseful datas regulary.

Thanks for your reply.

I have as well page hits which 250Mb

What can I delete and what is useful with all the tables.

Cleaning out old data
WARNING: this is a destructive process which will result in deletion of data

This cron job allows you to clean out old data - note that not all data can be purged with this task. Currently supported are audit log entries, visitors (anonymous contacts), and visitor page hits. Use –dry-run to view the number of records to be purged before making any changes. This will permanently delete data! Be sure to keep database backups.

path/to/php /path/to/mautic/app/console mautic:maintenance:cleanup --days-old=365 --dry-run

Thk you mate :slight_smile:

Arf, I have access denied.

My host say it’s because of the htaccess do you know something about it?

I really drive crazy with this software, nothing works!

I have access denied…is there a mysql command that I could try through phpmyadmin?