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

[Tony Clements]

On Fri, Oct 14, 2011 at 11:43 AM, Matthew Komar <mkomar at serverrack.net> wrote:
> myisamchk will probably get you going again.
>
> On 10/14/2011 11:36 AM, Tony Clements wrote:
>> Not sure how to fix av-spam mysql error, but the issue is killing my /var....
>> Error reads:
>> 111014 11:31:30 [ERROR] /usr/libexec/mysqld: Table
>> './av-spam5/bayes_token' is marked as crashed and should be repaired
>> 111014 11:31:30 [ERROR] /usr/libexec/mysqld: Table
>> './av-spam5/bayes_token' is marked as crashed and should be repaired
>> 111014 11:31:30 [ERROR] /usr/libexec/mysqld: Table
>> './av-spam5/bayes_token' is marked as crashed and should be repaired
>> 111014 11:31:30 [ERROR] /usr/libexec/mysqld: Table
>> './av-spam5/bayes_token' is marked as crashed and should be repaired
>> 111014 11:31:30 [ERROR] /usr/libexec/mysqld: Table
>> './av-spam5/bayes_token' is marked as crashed and should be repaired
>> 111014 11:31:30 [ERROR] /usr/libexec/mysqld: Table
>> './av-spam5/bayes_token' is marked as crashed and should be repaired
>> 111014 11:31:30 [ERROR] /usr/libexec/mysqld: Table
>> './av-spam5/bayes_token' is marked as crashed and should be repaired
>> 111014 11:31:30 [ERROR] /usr/libexec/mysqld: Table
>> './av-spam5/bayes_token' is marked as crashed and should be repaired
>> 111014 11:31:30 [ERROR] /usr/libexec/mysqld: Table
>> './av-spam5/bayes_token' is marked as crashed and should be repaired
>> 111014 11:31:30 [ERROR] /usr/libexec/mysqld: Table
>> './av-spam5/bayes_token' is marked as crashed and should be repaired
>> Does anyone know how to repair this?
>> The av-spam is pkg from solarspeed not self installed.
>> Thanks if you can shed some light on this.
>> Tony
>> _______________________________________________
>> Blueonyx mailing list
>> Blueonyx at mail.blueonyx.it
>> http://mail.blueonyx.it/mailman/listinfo/blueonyx
> _______________________________________________
> Blueonyx mailing list
> Blueonyx at mail.blueonyx.it
> http://mail.blueonyx.it/mailman/listinfo/blueonyx
>

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