Re: mysql db's hosed? Help needed badly

>>> David Morton <mortondadgrmm.net> 10/11/2007
1:06 AM >>>
-----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.

______________

I think we're at that point.  Even after running the expire
script with
the values lowered to 1 for both, the quarantine script
still just churns
and churns and churns and never finishes.  Dunno.  :-(


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

_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users

How big is your MySQL database?



-----Original Message-----
From: maia-users-bouncesrenaissoft.com
[mailto:maia-users-bouncesrenaissoft.com] On Behalf
Of Rick Zeman
Sent: Monday, October 15, 2007 9:06 AM
To: David Morton; maia-usersrenaissoft.com
Subject: Re: [Maia-users] mysql db's hosed? Help needed
badly

>>> David Morton <mortondadgrmm.net> 10/11/2007
1:06 AM >>>
-----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.

______________

I think we're at that point.  Even after running the expire
script with
the values lowered to 1 for both, the quarantine script
still just churns
and churns and churns and never finishes.  Dunno.  :-(


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

_______________________________________________
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