Re: MySQL performance on FreeBSD compared to Linux

2004-05-25 Thread Atle Veka
Hello Chris, I'm not familiar with super-smack, but it's compared to Apaches 'ab' which IMO is great for getting quick performance numbers but should in no way be trusted compared to a real world production environment. We run probably about 50+ dedicated mysql servers on various FreeBSD 4.X rele

Re: MySQL performance on FreeBSD compared to Linux

2004-05-23 Thread Chris Elsworth
On Sat, May 22, 2004 at 11:25:54PM -0500, mos wrote: > > > >Once I wiped this and tried Linux (both gentoo, with their > >patched-to-the-hilt 2.6.5 kernel, and Debian, with a stock 2.6.6 which > >had just been released by the time I installed) this figure jumped to > >35,000 queries per second. >

Re: MySQL performance on FreeBSD compared to Linux

2004-05-22 Thread Chris Nolan
mos wrote: At 04:42 PM 5/21/2004, you wrote: Forenote: I have no wish to start an OS debate. Hello, Once I wiped this and tried Linux (both gentoo, with their patched-to-the-hilt 2.6.5 kernel, and Debian, with a stock 2.6.6 which had just been released by the time I installed) this figure jumped to

Re: MySQL performance on FreeBSD compared to Linux

2004-05-22 Thread mos
At 04:42 PM 5/21/2004, you wrote: Forenote: I have no wish to start an OS debate. Hello, Once I wiped this and tried Linux (both gentoo, with their patched-to-the-hilt 2.6.5 kernel, and Debian, with a stock 2.6.6 which had just been released by the time I installed) this figure jumped to 35,000 que

Re: MySQL performance on FreeBSD compared to Linux

2004-05-21 Thread Chris Elsworth
On Fri, May 21, 2004 at 05:18:09PM -0600, Sasha Pachev wrote: > > It looks like FreeBSD was using only one CPU from your numbers. Try the > test with only 1 thread and a lot of iterations to avoid the influence of > overhead. I know very little about FreeBSD, but one thing I would check is > if

Re: MySQL performance on FreeBSD compared to Linux

2004-05-21 Thread Sasha Pachev
Chris Elsworth wrote: Forenote: I have no wish to start an OS debate. Hello, I'm in the fortunate position of having a dual 2.8GHz Xeon with 4G of ram and 4 10k SCSI disks (configured in RAID-10) to deploy as a new MySQL server. Since I'm a numbers freak, I've been running super-smack on it for the

MySQL performance on FreeBSD compared to Linux

2004-05-21 Thread Chris Elsworth
Forenote: I have no wish to start an OS debate. Hello, I'm in the fortunate position of having a dual 2.8GHz Xeon with 4G of ram and 4 10k SCSI disks (configured in RAID-10) to deploy as a new MySQL server. Since I'm a numbers freak, I've been running super-smack on it for the last few days to s