Why is MySQL nearly twice as fast on Linux?

[Julian Elischer]

On Sat, 22 May 2004, JG wrote:

> 
> 
> >Along with the other benchmarks it's still a little apples
> >and oranges.  I've seen different versions of mysql run
> >with different versions of FreeBSD.
> 
> I'm going to stick with 4.0.20 from now for tests.
> 
> Most of my tests were done on 4.0.20.
> 
> 
> >  I'd like to see the
> >same mysql version run on the same hardware with libpthread
> >and linuxthreads.
> 
> I'll have to do that on the i386 install tomorrow, as Linuxthreads
> is not available for FreeBSD/AMD64.
> 
> 
> >This shows that -current (both SMP and UP) with libpthread is
> >faster than linuxthreads (different versions of FreeBSD and
> >mysql, though).
> 
> For FreeBSD nothing (remote) has been faster than the i386 Linuxthreads
> test.
> 
> I'll do everything local tomorrow.
> 
> 
> >Also, if you use the default mysql config settings, then
> >FreeBSD remote vs Linuxthreads remote also wins (2685.53
> >vs. 2091.10 from earlier post).
> 
> I understand what you're saying, but those numbers are horrible.
> 
> 
> >What modifications are you making to /etc/my.cnf and why
> >do they turn the results around the other way?
> 
> I used either my-huge.cnf or no config file at all (as noted in the 
> benchmarks).
> 
> 
> 
> 

For a start there are the following variations to try:

SCHED_ULE vs SCHED_4BSD
SCOPE_SYSTEM vs SCOPE_PROCESS threads


> Tell me all the FreeBSD tests you want to see & I'll do them if I can.
> 
> 
> _______________________________________________
> freebsd-threads at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-threads
> To unsubscribe, send any mail to "freebsd-threads-unsubscribe at freebsd.org"
>