ee_message table very large

[lost]

I have been doing regular backups of my DB and noticed the backups getting quite large for MYSQL. Currently I have just over 1000 pictures and my DB is over 18 megs.

I have noticed the majority of that is in ee_message table. It has over 60k lines. Is there any way to reduce this as I have noticed reduced performace over time, which I think is related to this.

From what I can tell it contained every message ever created by EE which I dont think I need. I have tried the built in tools to optimize and defrag but they dont reduce this size.

Thanks

[lost]

Little more info. The table is 48k records and 13 Mb.

[Pekka]

In editor, click "view messages" and there button "Clear messages".

Where ever EE displays message window, there is also the "Clear messages" button.

[lost]

DOH sorry for wasting your time Pekka.

[lost]

That worked great dropped the DB down to 1.5 megs.

[Pekka]

NOTE: When backing up with EE Backup you can also exclude certain tables (deselect from table list with CTRL+click) to make backups smaller. With 1.5RC4 you can safely remove

ee_messages
ee_uncookied
ee_performance

from backup.