Re: mysql scaling questions

2007-12-01 Thread Mike Tancsa
At 08:54 PM 12/1/2007, Peter Losher wrote: Manjunath R Gowda wrote: > On 12/1/07, Boris Samorodov <[EMAIL PROTECTED]> wrote: >> >> 3ware driver is under GIANT at 7.x. I don't know if it's the same for >> linux. > > It is not under GIANT any more, MPSAFE starting from 7.0 BETA1. I know in one cas

Re: mysql scaling questions

2007-12-01 Thread Peter Losher
Manjunath R Gowda wrote: > On 12/1/07, Boris Samorodov <[EMAIL PROTECTED]> wrote: >> >> 3ware driver is under GIANT at 7.x. I don't know if it's the same for >> linux. > > It is not under GIANT any more, MPSAFE starting from 7.0 BETA1. I know in one case on a box running BETA2 the kernel dmesg re

Re: mysql scaling questions

2007-12-01 Thread Manjunath R Gowda
On 12/1/07, Boris Samorodov <[EMAIL PROTECTED]> wrote: > > > 3ware driver is under GIANT at 7.x. I don't know if it's the same for > linux. It is not under GIANT any more, MPSAFE starting from 7.0 BETA1. -Manjunath ___ freebsd-performance@freebsd.org

Re: mysql scaling questions

2007-12-01 Thread Boris Samorodov
On Sat, 1 Dec 2007 17:33:34 +0100 Gergely CZUCZY wrote: > I am using sysbench, with read-write tests. > The test-table has 10M tuples, and i'm querying it for two minutes. [...] > The testbox has a dual opteron 246, 12G of memory and a 3ware-9550 with > two disks in a mirror for the rootfs (also t

Re: mysql scaling questions

2007-12-01 Thread Jeff Roberson
On Sat, 1 Dec 2007, Gergely CZUCZY wrote: On Sat, Dec 01, 2007 at 04:06:55PM -0500, Mike Tancsa wrote: At 03:56 PM 12/1/2007, Gergely CZUCZY wrote: I don't quite understand the question. It's the very same box, with a dualboot configuration. Fire up the 3ware controller's RAID management sof

Re: ULE vs. 4BSD in RELENG_7

2007-12-01 Thread Josh Carroll
> I just ran through some of my benchmarks on a kernel build from > sources as of today, and I've noticed an improvement for the ffmpeg > workload. Here's a comparison of 4bsd, ule (BETA1) and ule (BETA3). > This is vanilla source with no patches applied: Sorry, the ministat output was mangled. I'

Re: mysql scaling questions

2007-12-01 Thread Gergely CZUCZY
On Sat, Dec 01, 2007 at 04:06:55PM -0500, Mike Tancsa wrote: > At 03:56 PM 12/1/2007, Gergely CZUCZY wrote: > >I don't quite understand the question. It's the very same box, with > >a dualboot configuration. > > Fire up the 3ware controller's RAID management software and make sure the > same writ

Re: mysql scaling questions

2007-12-01 Thread Mike Tancsa
At 03:56 PM 12/1/2007, Gergely CZUCZY wrote: I don't quite understand the question. It's the very same box, with a dualboot configuration. Fire up the 3ware controller's RAID management software and make sure the same write caching strategy is set for FreeBSD and Linux. The driver my default

Re: mysql scaling questions

2007-12-01 Thread Gergely CZUCZY
On Sat, Dec 01, 2007 at 03:53:08PM -0500, Mike Tancsa wrote: > At 11:33 AM 12/1/2007, Gergely CZUCZY wrote: > >> > > >> >The box is a dual opteron 246 with 12GB of memory with 10K RPM > >> >SATA disks on a 9550 3ware. > >> > > >> >So, what can cause this big difference? > > Are the caching options

Re: mysql scaling questions

2007-12-01 Thread Mike Tancsa
At 11:33 AM 12/1/2007, Gergely CZUCZY wrote: > > > >The box is a dual opteron 246 with 12GB of memory with 10K RPM > >SATA disks on a 9550 3ware. > > > >So, what can cause this big difference? Are the caching options for the 3ware the same on FreeBSD as Linux ? ---Mike _

Re: ULE vs. 4BSD in RELENG_7

2007-12-01 Thread Josh Carroll
Jeff, I just ran through some of my benchmarks on a kernel build from sources as of today, and I've noticed an improvement for the ffmpeg workload. Here's a comparison of 4bsd, ule (BETA1) and ule (BETA3). This is vanilla source with no patches applied: x 4bsd + ule * uleb3 +-

Re: mysql scaling questions

2007-12-01 Thread Gergely CZUCZY
On Fri, Nov 30, 2007 at 02:31:50PM -1000, Jeff Roberson wrote: > I've forwarded this mail to the freebsd performance list so more people can > take a look at it. Thanks for all of the details. What > was the test that you're doing? sysbench? With writes or without? Or some > other benchmark

Re: mysql scaling questions

2007-12-01 Thread Miroslav Lachman
Jeff Roberson wrote: [...] the MySQL binary is statically linked, i've built it that way. ldd: /usr/local/libexec/mysqld: not a dynamic executable Though, maybe I should rebuild it dynamically to ensure it's linked against libthr (and not pthread or c_r)... So, any tips, guesses, anything what