Known Issues: eximstats mysql database get unoptimized

From CPWiki

Jump to: navigation, search

Eximstats delete from their Mysql databases often so it quickly get unoptimized.

[edit] Case Example

Before optimize my eximstats mysql database had 40MB.

After it 10MB was freed.

[edit] Fix

Fo fix it, add at root crontab:

10 10 */7 * *  echo "OPTIMIZE TABLE eximstats.sends, eximstats.smtp;" | mysql

[edit] Bugzilla

Personal tools