On Sat, Jun 28, 2003 at 01:14:37PM +0200, Richard Fuchs wrote:
> 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?
You seem to be the first reporting a problem with FreeBSD 5.1 and
MySQL.
Do you *need* to use 5.1 or could you try 4.8 to see if the problem
goes away? That'd help to narrow it down to eithe MySQL or something
specific to FreeBSD 5.1.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped> | http://jeremy.zawodny.com/
MySQL 4.0.13: up 25 days, processed 813,050,547 queries (362/sec. avg)
