INNODB Database Crash - Any DB reduction ideas?

[jjwdesign]

SugarCRM Gurus,

I know this isn't an INNODB database forum, but I recently experienced a complete database crash and am wondering if there are some ways I can reduce the size of my biggest SugarCRM database tables.

Here are some of my biggest culprits:

84 MiB - calls
390 MiB - emails_text
145 MiB - prospects
92 MiB - prospect_lists_prospects
64 MiB - tracker

Total database size is about 1.1 GiB

As you can see, we use the email module and track a ton of prospects (170,000+), which I will be trying to reduce. I'm also wondering if the emails_text table can be partially flushed. Will it rebuild itself if needed?

Thanks

[SugarDev.net]

Consider turning on the Purge task in sugar scheduler. this deletes all (soft-)deleted records. It should be no problem with prospects or emails I think.

[jjwdesign]

I typically do a manual purge and a general clean up using several dozen or so SQL statements that I've written. I understand the soft delete completely. I was wondering if someone could shed some light on the emails_text table and wether or not I could purge part of that table to reduce the size of the database.

[jjwdesign]

The emails_text table is now over 410 MiB in size. Total database size is 1.3 GiB. I would love to hear back from a developer on this issue. There's got to be a way to prune the table data, even if I have to write some custom code.

Thanks.