Dear Martin,
you could also use Maatkit toolkit from Percona to investigate MySQL issues. I
believe using mk-query-digest on slow.log would give you good results...
cheers, Jernej
On Mar 26, 2010, at 10:45 AM, Martin Svensson wrote:
>
> Hi,
>
> Thanks for your responses, it's much appreciated
Hi,
Thanks for your responses, it's much appreciated.
Our main cause of concern is that the problem started all of a sudden on a
Monday morning. We have handled roughly the same amount of messages during
the last 12 months, we haven't made any changes at all to the config and we
haven't seen anyt
Dear Martin,
we are dealing with almost the same amount of emails as you are and we are
handling it with two dedicated MySQL servers (master-slave) with 8GB of RAM and
we haven't hit the limit (yet). (bayes_seen ~5M records, awl ~1M records,
bayes_token, ~2M records)
If MySQL is the bottleneck
On 3/25/10 2:20 AM, Martin Svensson wrote:
> The setup in SA:
> use_bayes 1
> bayes_auto_learn 1
> bayes_store_module Mail::SpamAssassin::BayesStore::MySQL
> loadplugin Mail::SpamAssassin::BayesStore::SQL
>
>
in the faq's. disable opportunistic expiration, and do it in a cronjob
when thi
Hi List,
I posted this a couple of days ago on the SA-user list, but haven't received
any feedback. I know that it's not Amavis functionality but still hope that
someone might have a clue of what's causing this in this list, even if it's
a bit OT.
The setup consists of 2 spam-eating servers runni
