On Sun, Jun 29, 2003 at 09:38:09AM +0200, Richard Fuchs wrote:
>
> well it wasn't my choice. personally i'm a linux guy, but right now i'd
> rather have minimum downtime w/o too much playing around.
Ah, got it.
> > Interesting. The skip-name-resolve shouldn't be an issue when using
> > LinuxThreads. As for enable-locking, that sounds suspicious. You
> > weren't running other proceses outside of MySQL that might work with
> > the data files (myisamchk, for example), were you?
>
> no of course not :) unless the default freebsd install comes with some
> cron jobs or something that do something nasty with the tables behind
> the scenes (just kidding, but i've actually checked for that).
Good.
> is it possible that the internal locking is broken and doesnt work
> right, and the use of external locking works as a kind of workaround
> for this?
Yeah, that's what it's starting to sounds like.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped> | http://jeremy.zawodny.com/
MySQL 4.0.13: up 26 days, processed 815,367,494 queries (362/sec. avg)
