Daniel Mejia wrote: > > Michael Monnerie-5 wrote: >> Just put a max quota on your users accounts, then they *must* delete >> some old e-mails. >> > > We have a 1GB quota on all users, except for more or less, 20 users in the > management level, with the biggest quota at 3GB.
So with 2000 users you have 2 to 3TB storage allocated already? >> How many users do you have, and how much space do they use on average? >> > > Currently, we have 1,879 users, but the number increases, slowly but surely, > when the organization hire new staff (which happens all year round). > > I run the dbmail-util -ay command from a different server, whereas the mysql > database server sits on a different server. This is what happens: So don't run dbmail-util -ay on a 800GB database! > <code> > Repairing DBMAIL for incorrect is_header flags... > Dec 16 13:13:04 mailadmin.mpob.g dbmail-util[16803]: Error:[sql] > dbmysql.c,db_query(+290): [Lost connection to MySQL server during query] > [SELECT MIN(messageblk_idnr),MAX(is_header) FROM dbmail_messageblks GROUP BY > physmessage_id HAVING MAX(is_header)=0] That is the header check (-b). You can safely skip that one, until you decide to rebuild the header cache tables. > Dec 16 13:13:04 mailadmin.mpob.g dbmail-util[16803]: Error:[db] > db.c,db_icheck_isheader(+1788): could not access messageblks table > Failed. An error occured. Please check log. > </code> > > what should i do? from the mysql website: > http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_connect_timeout, > i'm kind of confused with all the *_timeout variables. > > I was thinking of increasing the number of seconds, but not sure which one. > would that help? You're barking up the wrong tree. There's a reason for those timeouts. First find out which query is killing the connection (you did), next find out which command triggers the query (-by). In your case I would very carefully start to tune the dbmail-util runs. Run them all manually, and separately, to find out how long they take, if they're needed at all, how they affect the database, etc... Some of the maintenance options are probably not needed at all, only need to be run once every few days or maybe even weeks. Simply running -ay every night is ok for small to medium sized installations. But with 800GB you're not in Kansas anymore. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
