hi!
i'm using mysql 4.0.13 from the standard freebsd 5.1 ports distribution,
and i keep getting repeated random table corruptions. the same thing
happens when building both with the native threading lib, and with
linuxthreads.
i figured it would be related to threading as it's always happening when
the mysql server is loaded, that is has lots of concurrent queries on
the same table going on. suddenly the table would get corrupted, and i
have to run a "repair table" on it (this always nukes a few rows from
the table). it's reproducable only in the sense that it keeps happening
randomly ;)
are there any known issues with this combination, or with mysql 4.0.13
or freebsd 5.1 in general? what could be the cause for this, and how
could it be fixed?
tia
richard