Paul J Stevens wrote: > > So with 2000 users you have 2 to 3TB storage allocated already? >
There is a 3TB of storage, with 800Gb used. > So don't run dbmail-util -ay on a 800GB database! > ... > That is the header check (-b). You can safely skip that one, until you > decide to rebuild the header cache tables. > Rebuild header cache tables = ALTER TABLE ? > 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. > at last someone gives an answer straight! thanx! will try exactly that. -- View this message in context: http://old.nabble.com/dbmail---mysql-..-tp7810337p26808762.html Sent from the dbmail users mailing list archive at Nabble.com. _______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail