Forums

Robin
Robin
Offline
Resolved
0 votes
We have been on 5.2 for a couple of years as our "mail/spam/malware" relay

Yesterday I found the system out of disk space. The largest file bein /var/lib/system-mysql/ibdata1 at 4.5GB

I managed to free up a little space, then thismornign mounted an nfs share on our NAS and did

rebuild-database

this has only freed up andother 500MB.

What is in teh DB, how can I get it back to and keep a reasonable size?

Cheers

Rob
Wednesday, November 20 2013, 09:55 AM
Share this post:
Responses (4)
  • Accepted Answer

    Robin
    Robin
    Offline
    Saturday, November 23 2013, 10:19 PM - #Permalink
    Resolved
    0 votes
    our system is primarily just a relay with Spam/AV scanning.

    We clear down the quarantine with the delete all button every day or two using the hidden delete all hack.

    from what i have read ibdata1 does not reduce in size in normal operation, so an sql delete does not actualy delete the record in the database entirely. I thought, from reading that dropping and recreating the DB would fix this so did the rebuild-database. It has reduced it but not by much more than 10%

    Accessing the spam quarantine even when there is only 100 or so items is very slow, so I guess it is parsing this 4.5GB file to find valid live quarantine items.

    I am working on a 6.x platform to replace the current one as I don't think it's going to last long ( been in service 2 years though )

    Cheers

    Rob
    The reply is currently minimized Show
  • Accepted Answer

    Saturday, November 23 2013, 10:06 PM - #Permalink
    Resolved
    0 votes
    Yup the mail quarantine is there... this might help
    http://tracker.clearfoundation.com/view.php?id=242
    The reply is currently minimized Show
  • Accepted Answer

    Robin
    Robin
    Offline
    Saturday, November 23 2013, 09:22 PM - #Permalink
    Resolved
    0 votes
    So how has it got to 4.5GB?

    Where is quarantine stored?

    Cheers, Rob.
    The reply is currently minimized Show
  • Accepted Answer

    Saturday, November 23 2013, 09:20 PM - #Permalink
    Resolved
    0 votes
    System-mysql is the backend sandboxed version of Mysql for the webconfig. In ClearOS 5.2 it wasn't used to store much unless you used Zarafa to keep your mail there?
    The reply is currently minimized Show
Your Reply