Re: mysql performance tuning @ FreeBSD6

2006-01-28 Thread Mike Jakubik
Michael Vince wrote: Joao Barros wrote: No real difference here too... I started a thread on that subject not long ago and following Robert's tip setting net.inet.tcp.inflight.enable=0 yielded better results. -- Joao Barros ___ With the new TCP/IP

Re: mysql performance tuning @ FreeBSD6

2006-01-28 Thread Dr. Rich Murphey
Michael Vince wrote: Joao Barros wrote: On 1/26/06, Mike Jakubik <[EMAIL PROTECTED]> wrote: Rich Murphey wrote: I'm curious whether Robert's patch might have an effect on samba3 performance as well. No real difference here, tried ACPI-fast, i8254, and TSC. :( My transfers still av

Re: mysql performance tuning @ FreeBSD6

2006-01-26 Thread Michael Vince
Joao Barros wrote: On 1/26/06, Mike Jakubik <[EMAIL PROTECTED]> wrote: Rich Murphey wrote: I'm curious whether Robert's patch might have an effect on samba3 performance as well. No real difference here, tried ACPI-fast, i8254, and TSC. :( My transfers still average at 10MB/s (a

Re: mysql performance tuning @ FreeBSD6

2006-01-26 Thread Mike Jakubik
Joao Barros wrote: On 1/26/06, Mike Jakubik <[EMAIL PROTECTED]> wrote: Rich Murphey wrote: I'm curious whether Robert's patch might have an effect on samba3 performance as well. No real difference here, tried ACPI-fast, i8254, and TSC. :( My transfers still average at 10MB/s (al

Re: mysql performance tuning @ FreeBSD6

2006-01-26 Thread Joao Barros
On 1/26/06, Mike Jakubik <[EMAIL PROTECTED]> wrote: > Rich Murphey wrote: > > I'm curious whether Robert's patch might have an > > effect on samba3 performance as well. > > No real difference here, tried ACPI-fast, i8254, and TSC. :( My > transfers still average at 10MB/s (although it did peak at 2

Re: mysql performance tuning @ FreeBSD6

2006-01-26 Thread Mike Jakubik
Rich Murphey wrote: I'm curious whether Robert's patch might have an effect on samba3 performance as well. No real difference here, tried ACPI-fast, i8254, and TSC. :( My transfers still average at 10MB/s (although it did peak at 20MB/s once) Which is really horrible for a em gigabit link wit

Re: mysql performance tuning @ FreeBSD6

2006-01-26 Thread Rich Murphey
I'm curious whether Robert's patch might have an effect on samba3 performance as well. This isn't very methodical, but I see about 60% increase samba3 read bandwidth (from 14MB/s to 26Mb/s) when changing from the default kern.timecounter.hardware=i8254 to TSC, which makes me wonder whether it mig

Re: mysql performance tuning @ FreeBSD6

2006-01-25 Thread Robert Watson
On Wed, 25 Jan 2006, Ivan Voras wrote: Thomas Krause (Webmatic) wrote: But with static linked libraries, I cannot switch between libthread and libthr - right? Could somebody give me an inspiration/ recommendation? Unless you are ready to count individual CPU cycles, you won't find a notica

Re: mysql performance tuning @ FreeBSD6

2006-01-25 Thread Ivan Voras
Thomas Krause (Webmatic) wrote: But with static linked libraries, I cannot switch between libthread and libthr - right? Could somebody give me an inspiration/ recommendation? Unless you are ready to count individual CPU cycles, you won't find a noticable difference between static and dynamic

mysql performance tuning @ FreeBSD6

2006-01-25 Thread Thomas Krause (Webmatic)
Hi, I've read a lot about mysql performance tuning - also on this list. 1) I can switch from libpthread to libthr, which should give a perfomance benefit. This is done in /etc/libmap.conf 2) I can build a static linked version of mysqld (BUILD_OPTIMIZED=yes), which should also give a per