[Dbmail] Re: Size, vacuum, performance, etc

2005-11-18 Thread Thomas Mueller
Matthew T. O'Connor wrote: > Niblett, David A wrote: > >> Wow, then I'm completely lost looking at your numbers. >> >> I set my shmall and shmmax to 805306368, so that the DB (which >> is the only thing using memory on the box) could have 800M of >> shared RAM. Am I crazy here? > > PostgreSQL us

[Dbmail] DBMail Logging question

2005-11-18 Thread Simon
Hi There, DBMail 2.0.7 on debian sarge. DBMail logs to both the /var/log/mail.log and the /var/log/syslog. Is there a way to stop it logging to var/log/syslog? Im guessing that this might be a syslog question more than a DBMail question - but wonder if anyone has had the same issue and could

Re: [Dbmail] DBMail Logging question

2005-11-18 Thread Blake Mitchell
It is completely a syslog question, edit your /etc/syslog.conf to direct log messages to the appropriate files. Simon wrote: Hi There, DBMail 2.0.7 on debian sarge. DBMail logs to both the /var/log/mail.log and the /var/log/syslog. Is there a way to stop it logging to var/log/syslog? Im gues

Re: [Dbmail] Max_data_length for dbmail_messageblks reached

2005-11-18 Thread Simon
It looks like we have reached the Max_data_length for the dbmail_messageblks table, this is currently 4294967295 (which is 4GB im gussing - which is about right). From the mysql docs, this can be easliery solved by running: ALTER TABLE tbl_name MAX_ROWS=10 AVG_ROW_LENGTH=nnn; Any idea

Re: [Dbmail] Size, vacuum, performance, etc

2005-11-18 Thread Paul J Stevens
Niblett, David A wrote: > As for the dbmail-util, I would love not to run that part each > night, but I thought that was recommended. Maybe Paul or one > of the other developers could shed some light on the recommended > dbmail-util schedule. I checked my logs and I've never had a > single mess

Re: [Dbmail] Max_data_length for dbmail_messageblks reached

2005-11-18 Thread M. J. [Mike] O'Brien
Simon: This issue is version specific in its resolution. Notwisthstanding some fairly large 'real' ones, I have built some enormous dev mail databases with 'fake' users -- perl scripts pumping 'stuff' for days. I have had varying results depending on the MySQL version, file system and the driv

RE: [Dbmail] Size, vacuum, performance, etc

2005-11-18 Thread Niblett, David A
Interesting, I guess I didn't understand the concept of what dbmail-util was for. I assumed you should run the -a (all) feature. So for the sake of an upcoming consolidation of all this information into hopefully a wiki or at least my own documentation... I've changed my dbmail-util strategy to

[Dbmail] delivering mail to /dev/null

2005-11-18 Thread igor
Hi, How to deliver mail to /dev/null using aliases table? Thanks, Igor.

Re: [Dbmail] delivering mail to /dev/null

2005-11-18 Thread Jesse Norell
To actually put it all in /dev/null, you'd have to use something like '| /bin/cat > /dev/null' .. but it might be more efficient to use '| /bin/true' (since true(1) won't read all the data from stdin and write to stdout, just to be discarded). Nothing else very clever comes to mind (dbmail doesn'