List Info

Thread: Re: mysql db's hosed? Help needed badly




Re: mysql db's hosed? Help needed badly
country flaguser name
United States
2007-10-10 11:56:29
2GB, it's not into the swap at all, and vmstat looks good. 
1.73ghz xeon
with software raid 1 SATA drives.

-- 
Rick Zeman
Manager of Information Technology
Melwood Horticultural Training Center
301.599.4574 - HelpDesk
301.599.4560 - MyDesk
http://www.melwood.org


>>> David Sims <dpsimsdpsims.com> 10/10/2007
12:34 PM >>>
Hi,

  How much memory does the machine have?? At least 512 and
probably 1 Gb
would be good....

Dave
************************************************************
*************
On Wed, 10 Oct 2007, Rick Zeman wrote:

> Well....yes and no.  It cures the immediate problem
(the jacked high
> utilization), but running quarantine.pl will still
never finish;
mysqld
> eventually grinds to a halt.  The server isn't even
online now, so
> nothing's being added to the maia.db.  So, that means
that something
is
> fundamentally hosed outside of those tables.  What I'm
not
understanding
> is what messages (at that point) the perl script is
actually
processing
> because the implication from you is that they get
dropped with the
tables
> (but remember, I'm not a dba).
>
> Anyone think of any other options besides nuking the
maia db and
> reimporting its schema?  I'd really hate to lose the
users and their
links
> (we have multiple domains, and some people have up to 4
addresses they
> receive on).
>
> Thanks!
>
> --
> Rick Zeman
> Manager of Information Technology
> Melwood Horticultural Training Center
> 301.599.4574 - HelpDesk
> 301.599.4560 - MyDesk
> http://www.melwood.org 
>
> >>> Erik Weber <twiztargmail.com> 10/4/2007 9:07 AM >>>
> Rick Zeman wrote:
> > Erik:
> >
> > Beautiful!  Thank you so much.  It was rather
interesting to be
> entering
> > the sql commands in one window and then seeing the
utilization
plummet
> in
> > another.
>
> Does that mean it worked? If so, great!
>
> You should try to report a few messages, since
spamassassin won't use
> bayes until it has 200 (of each type) tokens, unless
you tell it
> otherwise.
>
> --
> Erik Weber
> _______________________________________________
> Maia-users mailing list
> Maia-usersrenaissoft.com 
> http://www.renaissoft.com/mailman/listinfo/maia-users 
> _______________________________________________
> Maia-users mailing list
> Maia-usersrenaissoft.com 
> http://www.renaissoft.com/mailman/listinfo/maia-users 
>
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users

Re: mysql db's hosed? Help needed badly
country flaguser name
United States
2007-10-10 12:12:39
Hi,

  As I recall, this machine ran for a while without running
process-quarantine.pl.... I am thinking that you need to
process the
quarantine to remove LOTS of mail.... If it's offline, then
why not just
start up process-quarantine.pl and let it run for a while...
If you do not
run process-quarantine.pl --learn --report it will run
faster...

  Also, there is a setting in /etc/maia.conf that limits
the
process-quarantine.pl to 5 messages at a go... If you become
the amavis
user and run process-quarantine.pl from the command line,
you should see
progress reporting where it is processing mail in batches of
5... Do you
see that? If so, then just let it run until it is done...
and then be
sure to add a line to the amavis user crontab like this:

0 * * * *    
/var/amavisd/maia/scripts/process-quarantine.pl --learn
--report 1> /dev/null

Dave
************************************************************
*************
On Wed, 10 Oct 2007, Rick Zeman wrote:

> 2GB, it's not into the swap at all, and vmstat looks
good.  1.73ghz xeon
> with software raid 1 SATA drives.
>
> --
> Rick Zeman
> Manager of Information Technology
> Melwood Horticultural Training Center
> 301.599.4574 - HelpDesk
> 301.599.4560 - MyDesk
> http://www.melwood.org
>
> >>> David Sims <dpsimsdpsims.com> 10/10/2007 12:34 PM >>>
> Hi,
>
>   How much memory does the machine have?? At least 512
and probably 1 Gb
> would be good....
>
> Dave
>
************************************************************
*************
> On Wed, 10 Oct 2007, Rick Zeman wrote:
>
> > Well....yes and no.  It cures the immediate
problem (the jacked high
> > utilization), but running quarantine.pl will still
never finish;
> mysqld
> > eventually grinds to a halt.  The server isn't
even online now, so
> > nothing's being added to the maia.db.  So, that
means that something
> is
> > fundamentally hosed outside of those tables.  What
I'm not
> understanding
> > is what messages (at that point) the perl script
is actually
> processing
> > because the implication from you is that they get
dropped with the
> tables
> > (but remember, I'm not a dba).
> >
> > Anyone think of any other options besides nuking
the maia db and
> > reimporting its schema?  I'd really hate to lose
the users and their
> links
> > (we have multiple domains, and some people have up
to 4 addresses they
> > receive on).
> >
> > Thanks!
> >
> > --
> > Rick Zeman
> > Manager of Information Technology
> > Melwood Horticultural Training Center
> > 301.599.4574 - HelpDesk
> > 301.599.4560 - MyDesk
> > http://www.melwood.org
> >
> > >>> Erik Weber <twiztargmail.com> 10/4/2007 9:07 AM >>>
> > Rick Zeman wrote:
> > > Erik:
> > >
> > > Beautiful!  Thank you so much.  It was rather
interesting to be
> > entering
> > > the sql commands in one window and then
seeing the utilization
> plummet
> > in
> > > another.
> >
> > Does that mean it worked? If so, great!
> >
> > You should try to report a few messages, since
spamassassin won't use
> > bayes until it has 200 (of each type) tokens,
unless you tell it
> > otherwise.
> >
> > --
> > Erik Weber
> > _______________________________________________
> > Maia-users mailing list
> > Maia-usersrenaissoft.com
> > http://www.renaissoft.com/mailman/listinfo/maia-users
> > _______________________________________________
> > Maia-users mailing list
> > Maia-usersrenaissoft.com
> > http://www.renaissoft.com/mailman/listinfo/maia-users
> >
> _______________________________________________
> Maia-users mailing list
> Maia-usersrenaissoft.com
> http://www.renaissoft.com/mailman/listinfo/maia-users
>
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users

Re: mysql db's hosed? Help needed badly
country flaguser name
United States
2007-10-11 00:06:30
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


On Oct 10, 2007, at 12:12 PM, David Sims wrote:

> Hi,
>
>   As I recall, this machine ran for a while without
running
> process-quarantine.pl.... I am thinking that you need
to process the
> quarantine to remove LOTS of mail.... If it's offline,
then why not  
> just

I'd start by turning down the cache expry time, and running
the  
expire script first, to narrow down the file.

We can also drop and re-add just the tables that hold the
mail, but  
keep the user settings... if we come to that point.

David Morton
Maia Mailguard http://www.maiamailguard
.com
mortondadgrmm.net



-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (Darwin)

iD8DBQFHDa9ZUy30ODPkzl0RAkNzAJ9Y3fQvKFsjvVOT4lwoQ2pSGXT/HwCg
vu9Y
YCwzEEy3+ms0qgKFQaUpj3g=
=j5mO
-----END PGP SIGNATURE-----
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users

[1-3]

about | contact  Other archives ( Real Estate discussion Medical topics )