[BlueOnyx:08844] Re: Mysql error from av-spam filling up mysql log file. Now over 350m and growing....

[Ken - Precision Web Hosting, Inc]

----- Original Message ----- 
From: "Tony Clements" <tdclements at gmail.com>
To: "BlueOnyx General Mailing List" <blueonyx at mail.blueonyx.it>
Sent: Friday, October 14, 2011 9:03 AM
Subject: [BlueOnyx:08843] Re: Mysql error from av-spam filling up mysql log 
file. Now over 350m and growing....


> On Fri, Oct 14, 2011 at 11:52 AM, Steven Howes
> <steve-lists at geekinter.net> wrote:
>>
>> On 14 Oct 2011, at 16:48, Tony Clements wrote:
>>> Result...
>>> Warning: option 'key_buffer_size': unsigned value 18446744073709551615
>>> adjusted to 4294963200
>>> Warning: option 'read_buffer_size': unsigned value
>>> 18446744073709551615 adjusted to 4294967295
>>> Warning: option 'write_buffer_size': unsigned value
>>> 18446744073709551615 adjusted to 4294967295
>>> Warning: option 'sort_buffer_size': unsigned value
>>> 18446744073709551615 adjusted to 4294967295
>>
>> Ok. Did it fix it?
>>
>> S
>>
>> _______________________________________________
>> Blueonyx mailing list
>> Blueonyx at mail.blueonyx.it
>> http://mail.blueonyx.it/mailman/listinfo/blueonyx
>>
>
> REPAIR TABLE `/av-spam5/bayes_token`
> Did not fix the issue either....
>

Set your spam assassin to not use MySQL.  That will lower the load on your 
server also.


----
Ken Marcus
Precision Web Hosting, Inc.
http://www.precisionweb.net