Re: mysql db's hosed? Help needed badly

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