thanks, I'll think about that in the future. PostgreSQL has a learning
curve. Its administration and setup is much different than MySQL and
I'm used to the latter. I've tried to setup PostgreSQL before and had a
great deal of difficulty. Its not as intuitive as MySQL.
Curtis
Ming-Wei Shih wrote:
I had the same problem, since then I switched to postgresql
with the compression on the text table, it's actually speedier
than mysql+innodb
Ming-Wei
Curtis Maurand wrote:
If your not careful and you don't run mysqloptimize -o -u <username>
-p<password> <dbmail database name> against the innodb database on a
regular basis, your database will grow to an unwieldy size. However, the
database will be locked while you do this. At one point, I ran out of
disk space. I ended up having to dump all of the databases to a separate
machine, drop all of the databases, delete the ibdata files, run
mysql_install_tables, start mysql and reimport all of the database back in
from the dump files. My database size went from 20 GB to 2 GB once I did
that. I was backing up approximately 2 GB per day but not running the
mysqloptimize utility to actually clean up the database. The reason is
that deleted records don't actually get deleted until you run
mysqloptimize.
Curtis
M. J. [Mike] OBrien wrote:
dbmail-util -a -y every night at 11pm...
locks up the DB until around 7 the next morning
Matt:
Do you mean the process is running that whole time? Yikes. Something
sounds
very wrong. DB schema? Slow hardware. (I see a lot of high-end stuff so
maybe I don't know.) How many mailboxes is that? How enormous can that
database be? Try 2.1.6 or later. Maybe you hit a bump in the road before
the
current unstable. Current SVN Trunk seems to install clean on anything
pretty much AFAICS.
Below I have made some admin-style notes just from memory. Every system is
different. dbmail-util -a -y is what you need to achieve as often as
possible. I think in Version 2.2 some changes will come about. I am seeing
a
few things to watch already in the message checking routines.
What I do is write scripts including MTA, DBMail and WebMail
(i.e.:backups,
rotates etc.) routines for cron to do and leave them in the same place on
every box upon which I build a mailserver. I can overwrite a whole new
script whenever a change is needed without opening crontabs. Maybe this
approach will work for your experiments aimed at finding the best
maintenance performance.
dbmail-util -ctupd -y is the whole gambit (dbmail-util -a -y)
dbmail-util -c -y (optimize) is a good high frequency run say every 6
hours.
The more often it runs the less it does and seems to make other
dbmail-util
stuff go more smoothly.
dbmail-util -p (purges marked deletes) daily or every three days or
whatever
you like
dbmail-util -d -y (quotas) can check quotas weekly or even less often
dbmail-util -tub -y (cleanup mesages) fixes null messages and a bunch of
disconnected and missing stuff - a little expensive on large systems :o)
but
needed every so often depending on style of users
Mike
----- Original Message -----
From: "Matthew Sayler" <[EMAIL PROTECTED]>
To: "DBMail mailinglist" <[email protected]>
Sent: Tuesday, May 16, 2006 10:31 AM
Subject: [Dbmail] Which util switch does the OPTIMIZE?
Hi,
I'm in the process of replacing my mail server, but until I do I have
some capactity problems. Currently, cron runs a dbmail-util -a -y every
night at 11pm and this locks up the DB until around 7 the next morning!
I'd like to run a more minimal set of daily maintenance scripts,
but I'm not sure from the man page which dbmail-util subcommands do the
OPTIMIZE TABLEs. I'm running against mysql 4.1 on dbmail SVN from
slightly before 2.1.6 (plan to upgrade at some point, but it's a low
priority for me right now).
Thanks,
Matt
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
