Need information

MARCOTTE PIERRE wrote:
>
> Hi all,
>
> We are using spamassassin + maia mailguard for the last
6 months with
> a couple of thousands of users.
>
> Since the last couple of weeks, we are experiencing
slowness trouble
> with the spam quarantine management.
>
> In the db (maia_mail) we have about 600,000 entries, I
tried the find
> a way to reduce the number of entries in this table.
>
>  
>
> So, I build a mysql test server from a bkp.
>
> I did delete manually records from maia_mail, mysql :
delete from
> maia_mail where score > 33;
>
> Now when I go for managing my spams, the counter do not
display the
> real number of records in the database.
>
> The first couple of displayed page are blanks and the
real spams
> records show after a few displayed pages.
>
>  
>
> How could I reflect the counter (rebuild the counter)
from the real
> number of spams?
>
>  
>
> Thanks in advance, any help would very appreciated.
>
>  
>


There are other tables that depend on the maia_mail table,
you have
deleted out some referential information.

Run the process and expire scripts, I think they should
clean it up.
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users