Re: MySQL Performance 6.0rc1

On Thu, 27 Oct 2005, Greg 'groggy' Lehey wrote:

> This would be interesting to know, doubtless, but please note that MySQL 
> 4.0 is either no longer supported or will reach that status in the 
> immediate future.  It would be more interesting to see what the 
> performance difference is between Linux and FreeBSD with MySQL 5.0, 
> which has just been released.
>
> If you find reasons to believe that any problems you're seeing are a 
> MySQL problem, please let me know.

I'm not certain it's a "MySQL Problem" so much as a set of changes that 
happen to be less optimal on FreeBSD than Linux.  It could even be a 
bugfix that makes MySQL more correct :-).  However, the differential 
change is interesting, and it would be useful (if nothing else) to compare 
system call activity between the two versions for the same load and see if 
there's anything obvious (like lots more calls to sync data, or changing 
select model, or...)

As I said, I haven't had time to investigate much lately, but hope to get 
back to MySQL investigation in the next few weeks or month.  It would be 
quite useful to know more about the changes between 4.0 and 4.1, and I 
don't doubt there's a release page somewhere that would tell me.

Robert N M Watson