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

[Tony Clements]

On Fri, Oct 14, 2011 at 12:26 PM, Ken  - Precision Web Hosting, Inc
<kenlists at precisionweb.net> wrote:
>
> ----- 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
>
>
>
> _______________________________________________
> Blueonyx mailing list
> Blueonyx at mail.blueonyx.it
> http://mail.blueonyx.it/mailman/listinfo/blueonyx
>

Used PHPadmin to repair table.
Table  Op  Msg_type  Msg_text
av-spam5.bayes_token repair warning Number of rows changed from
7657124 to 7657129
av-spam5.bayes_token repair status OK