How to shrink /var/spool/imap/db/* ...
Is it possible? total 13032 -rw--- 1 cyrus mail 8192 Jan 30 10:44 __db.001 -rw--- 1 cyrus mail270336 Jan 30 10:44 __db.002 -rw--- 1 cyrus mail 98304 Jan 30 10:44 __db.003 -rw--- 1 cyrus mail 16064512 Jan 30 10:44 __db.004 -rw--- 1 cyrus mail 24576 Jan 30 10:44 __db.005 -rw--- 1 cyrus mail553922 Jan 30 10:43 log.02 -rw--- 1 cyrus mail 2003662 Jan 17 10:34 log.01 rapmweb# ls -lt .. total 24 drwxr-xr-x 2 cyrus mail512 Jan 30 10:43 proc drwxr-xr-x 2 cyrus mail512 Jan 17 10:50 db drwx-- 2 cyrus mail512 Jan 17 10:50 socket drwxr-xr-x 3 cyrus mail 1024 Jan 17 10:50 deliverdb -rw--- 1 cyrus mail 16384 Sep 4 13:12 mailboxes.db drwxr-xr-x 28 cyrus mail512 Jun 8 2001 quota drwxr-xr-x 28 cyrus mail512 Jun 8 2001 user drwxr-xr-x 2 cyrus mail512 Oct 29 2000 log drwxr-xr-x 2 cyrus mail512 Oct 29 2000 msg rapmweb# pwd /var/spool/imap/db rapmweb# My /var/spool/mail directory is smaller then /var/spool/imap: rapmweb# du -sk /var/spool/mail 111 /var/spool/mail rapmweb# du -sk /var/spool/imap 14057 /var/spool/imap And doing a 'strings' on __db.004 shows its empty: rapmweb# strings __db.002 0 default admin lrswipcda user.admin.sent-mail 0 default admin lrswipcda cyrus lrswipcda user.admin 0 default cweberman lrswipcda cyrus lrswipcda user.cweberman 0 default andy lrswipcda cyrus lrswipcda user.andy- 0 default sysadmin lrswipcda cyrus lrswipcda user.sysadmin. 0 default webmaster lrswipcda cyrus lrswipcda user.webmaster 0 default sales lrswipcda cyrus lrswipcda user.sales 0 default sec lrswipcda cyrus lrswipcda user.sec 0 default help lrswipcda cyrus lrswipcda user.help) 0 default info lrswipcda cyrus lrswipcda user.info 0 default cyrus lrswipcda user.cyrus /var/spool/imap/mailboxes.db rapmweb# strings __db.004 rapmweb# Seems a waste of 16meg for nothing ... no? System is Cyrus IMAP 2.0.16 ... Thanks ...
Re: How to shrink /var/spool/imap/db/* ...
Marc G. Fournier wrote: Is it possible? http://www.sleepycat.com/docs/utility/db_archive.html FYI, we are working on adding functionality like this to ctl_cyrusdb. total 13032 -rw--- 1 cyrus mail 8192 Jan 30 10:44 __db.001 -rw--- 1 cyrus mail270336 Jan 30 10:44 __db.002 -rw--- 1 cyrus mail 98304 Jan 30 10:44 __db.003 -rw--- 1 cyrus mail 16064512 Jan 30 10:44 __db.004 -rw--- 1 cyrus mail 24576 Jan 30 10:44 __db.005 -rw--- 1 cyrus mail553922 Jan 30 10:43 log.02 -rw--- 1 cyrus mail 2003662 Jan 17 10:34 log.01 rapmweb# ls -lt .. total 24 drwxr-xr-x 2 cyrus mail512 Jan 30 10:43 proc drwxr-xr-x 2 cyrus mail512 Jan 17 10:50 db drwx-- 2 cyrus mail512 Jan 17 10:50 socket drwxr-xr-x 3 cyrus mail 1024 Jan 17 10:50 deliverdb -rw--- 1 cyrus mail 16384 Sep 4 13:12 mailboxes.db drwxr-xr-x 28 cyrus mail512 Jun 8 2001 quota drwxr-xr-x 28 cyrus mail512 Jun 8 2001 user drwxr-xr-x 2 cyrus mail512 Oct 29 2000 log drwxr-xr-x 2 cyrus mail512 Oct 29 2000 msg rapmweb# pwd /var/spool/imap/db rapmweb# My /var/spool/mail directory is smaller then /var/spool/imap: rapmweb# du -sk /var/spool/mail 111 /var/spool/mail rapmweb# du -sk /var/spool/imap 14057 /var/spool/imap And doing a 'strings' on __db.004 shows its empty: rapmweb# strings __db.002 0 default admin lrswipcda user.admin.sent-mail 0 default admin lrswipcda cyrus lrswipcda user.admin 0 default cweberman lrswipcda cyrus lrswipcda user.cweberman 0 default andy lrswipcda cyrus lrswipcda user.andy- 0 default sysadmin lrswipcda cyrus lrswipcda user.sysadmin. 0 default webmaster lrswipcda cyrus lrswipcda user.webmaster 0 default sales lrswipcda cyrus lrswipcda user.sales 0 default sec lrswipcda cyrus lrswipcda user.sec 0 default help lrswipcda cyrus lrswipcda user.help) 0 default info lrswipcda cyrus lrswipcda user.info 0 default cyrus lrswipcda user.cyrus /var/spool/imap/mailboxes.db rapmweb# strings __db.004 rapmweb# Seems a waste of 16meg for nothing ... no? System is Cyrus IMAP 2.0.16 ... Thanks ... -- Kenneth Murchison Oceana Matrix Ltd. Software Engineer 21 Princeton Place 716-662-8973 x26 Orchard Park, NY 14127 --PGP Public Key--http://www.oceana.com/~ken/ksm.pgp
Re: How to shrink /var/spool/imap/db/* ...
Ken Murchison wrote: Marc G. Fournier wrote: Is it possible? http://www.sleepycat.com/docs/utility/db_archive.html FYI, we are working on adding functionality like this to ctl_cyrusdb. Did I get that right? What I did: -- 1. -- binky:/var/imap/db # /etc/init.d/cyrus-imapd stop -- 2. -- binky:/var/imap/db # du -s /var/imap/ 11510 /var/imap binky:/var/imap/db # du -s /var/spool/imap/ 6175/var/spool/imap binky:/var/imap/db # l total 14797 drwxr-xr-x2 cyrusmail 185 Jan 30 18:55 ./ drwxr-x--- 11 cyrusmail 331 Jan 24 11:47 ../ -rw---1 cyrusmail 8192 Jan 30 16:27 __db.001 -rw---1 cyrusmail 11550720 Jan 30 16:27 __db.002 -rw---1 cyrusmail98304 Jan 30 16:27 __db.003 -rw---1 cyrusmail 270336 Jan 30 16:27 __db.004 -rw---1 cyrusmail24576 Jan 30 16:27 __db.005 -rw---1 cyrusmail 3595221 Jan 30 18:55 log.01 Yup, same situation. -- 3. -- binky:/var/imap/db # db_archive -s deliver.db mailboxes.db tls_sessions.db So /var/imap/db/* are obsolete files, right? Let's see... -- 4. -- binky:/var/imap/db # rm * binky:/var/imap/db # l total 1 drwxr-xr-x2 cyrusmail 35 Jan 30 18:58 ./ drwxr-x--- 11 cyrusmail 331 Jan 24 11:47 ../ -- 5. -- binky:/var/imap/db # /etc/init.d/cyrus-imapd start Initializing Cyrus IMAPD: done -- 6. -- binky:/var/imap/db # l total 11161 drwxr-xr-x2 cyrusmail 185 Jan 30 18:58 ./ drwxr-x--- 11 cyrusmail 331 Jan 24 11:47 ../ -rw---1 cyrusmail 8192 Jan 30 18:58 __db.001 -rw---1 cyrusmail 11550720 Jan 30 18:58 __db.002 -rw---1 cyrusmail98304 Jan 30 18:58 __db.003 -rw---1 cyrusmail 270336 Jan 30 18:58 __db.004 -rw---1 cyrusmail24576 Jan 30 18:58 __db.005 -rw---1 cyrusmail 333 Jan 30 18:58 log.01 I really did not win much space here, but at least the log file has gone. -- 7. -- binky:/var/imap/db # db_archive -s deliver.db tls_sessions.db Why is it no longer necessary to back up mailboxes.db? At least all IMAP folders and messages seem to be there... Olaf
Re: How to shrink /var/spool/imap/db/* ...
Olaf Zaplinski wrote: Ken Murchison wrote: Marc G. Fournier wrote: Is it possible? http://www.sleepycat.com/docs/utility/db_archive.html FYI, we are working on adding functionality like this to ctl_cyrusdb. Did I get that right? What I did: -- 1. -- binky:/var/imap/db # /etc/init.d/cyrus-imapd stop -- 2. -- binky:/var/imap/db # du -s /var/imap/ 11510 /var/imap binky:/var/imap/db # du -s /var/spool/imap/ 6175/var/spool/imap binky:/var/imap/db # l total 14797 drwxr-xr-x2 cyrusmail 185 Jan 30 18:55 ./ drwxr-x--- 11 cyrusmail 331 Jan 24 11:47 ../ -rw---1 cyrusmail 8192 Jan 30 16:27 __db.001 -rw---1 cyrusmail 11550720 Jan 30 16:27 __db.002 -rw---1 cyrusmail98304 Jan 30 16:27 __db.003 -rw---1 cyrusmail 270336 Jan 30 16:27 __db.004 -rw---1 cyrusmail24576 Jan 30 16:27 __db.005 -rw---1 cyrusmail 3595221 Jan 30 18:55 log.01 Yup, same situation. -- 3. -- binky:/var/imap/db # db_archive -s deliver.db mailboxes.db tls_sessions.db So /var/imap/db/* are obsolete files, right? Let's see... NO! 'db_archive -s' tells you which databases should be archived, it does NOT tell you to delete anything. If you're looking to archive/remove log files, you just want to do 'db_archive' (no options). The listed files can be archived/removed. Ken -- Kenneth Murchison Oceana Matrix Ltd. Software Engineer 21 Princeton Place 716-662-8973 x26 Orchard Park, NY 14127 --PGP Public Key--http://www.oceana.com/~ken/ksm.pgp
Re: How to shrink /var/spool/imap/db/* ...
Date: Wed, 30 Jan 2002 11:49:46 -0400 (AST) From: Marc G. Fournier [EMAIL PROTECTED] Is it possible? [...] Seems a waste of 16meg for nothing ... no? The large files are used for inter-process synchronization in Berkeley db. They may not be removed when the server is running. 16 megs is equivalent to, what, 5 cents? Note that these files (unlike the log files) never grow, so it's a constant amount of disk space. The log files can be periodically removed by doing cd /var/imap/db ; rm `db_archive` Larry
