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! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.13: up 25 days, processed 813,050,547 queries (362/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]