Re: Benchmark differences: Mac OS X - Linux

2003-11-07 Thread David Steinbrunner
The Mac was HFS+ journaled. Disk: the stock Apple-supplied one. The Linux machine was a default SuSE 8.0 installation. ext2 as the filesystem? No idea about journaling. No SCSI or RAID, just an internal IDE disk. Both machines are really consumer-level machines, no heavy-duty server hardware.

Re: Benchmark differences: Mac OS X - Linux

2003-11-07 Thread Gabriel Ricard
On Friday, November 7, 2003, at 09:05 AM, David Steinbrunner wrote: The Mac was HFS+ journaled. Disk: the stock Apple-supplied one. The Linux machine was a default SuSE 8.0 installation. ext2 as the filesystem? No idea about journaling. No SCSI or RAID, just an internal IDE disk. Both machines

Re: Benchmark differences: Mac OS X - Linux

2003-11-06 Thread Jeremy Zawodny
On Wed, Nov 05, 2003 at 07:57:00PM +0100, Jan Pieter Kunst wrote: Hi everyone, I recently ran the MySQL benchmark suite on a Dual 1 GHz G4 running Mac OS X Server 10.2.8, and an 800 MHz Intel machine running SuSE Linux 8.0. Both installations used the same my.cnf file. The results are

Re: Benchmark differences: Mac OS X - Linux

2003-11-06 Thread Jan Pieter Kunst
I'd be curious what kind of numbers Panther shows. Once I get my xServe setup, just arrived, I'll try running some tests myself. I just installed Panther on my G5 at home. Unfortunately, for some reason I can't get the Perl module DBD::mysql to install (using CPAN, had no problems doing this in

Re: Benchmark differences: Mac OS X - Linux

2003-11-06 Thread Van
I can't imagine a G4 would be disk bound relative to an Intel machine, unless there is something very wrong with the disk or controller. Also, you might want to defrag your disk on the Mac. G4s have much more disk bandwidth than any Intel I've ever seen. Almost as much as my DEC Alpha. :)

Re: Benchmark differences: Mac OS X - Linux

2003-11-06 Thread Jeremy Zawodny
On Thu, Nov 06, 2003 at 09:56:22AM -0700, Van wrote: I can't imagine a G4 would be disk bound relative to an Intel machine, unless there is something very wrong with the disk or controller. Also, you might want to defrag your disk on the Mac. G4s have much more disk bandwidth than any

Re: Benchmark differences: Mac OS X - Linux

2003-11-06 Thread Van
Jeremy: I believe that's what I was attempting to convey. My suggestion was that the G4 should not be disk bound (limited by disk bandwidth). The CPU on my DEC Alpha is a meagerly 300, but the disk can stream faster than my PIII true Intel 733MHz. That's why I suggested he look at the disk /

Re: Benchmark differences: Mac OS X - Linux

2003-11-06 Thread Jeremy Zawodny
On Thu, Nov 06, 2003 at 10:19:59AM -0700, Van wrote: Jeremy: I believe that's what I was attempting to convey. My suggestion was that the G4 should not be disk bound (limited by disk bandwidth). The CPU on my DEC Alpha is a meagerly 300, but the disk can stream faster than my PIII true

Re: Benchmark differences: Mac OS X - Linux

2003-11-06 Thread Gabriel Ricard
On Thursday, November 6, 2003, at 11:38 AM, Jan Pieter Kunst wrote: I'd be curious what kind of numbers Panther shows. Once I get my xServe setup, just arrived, I'll try running some tests myself. I just installed Panther on my G5 at home. Unfortunately, for some reason I can't get the Perl

Re: Benchmark differences: Mac OS X - Linux

2003-11-06 Thread Jan Pieter Kunst
Jeremy D. Zawodny: I was wondering if there is something I can do, configuration-wise, to do something about those very slow 'inserts' (and 'updates') on the Mac? Thanks in advance for any insight, Did it appear to be disk or CPU bound? Sorry, newbie here. I don't know how I can tell. The

Re: Benchmark differences: Mac OS X - Linux

2003-11-06 Thread Jan Pieter Kunst
I just installed Panther on my G5 at home. Unfortunately, for some reason I can't get the Perl module DBD::mysql to install (using CPAN, had no problems doing this in Jaguar) so I can't run the benchmark suite for now. JP I had similar issues, but I was also using a custom build of MySQL,

Re: Benchmark differences: Mac OS X - Linux

2003-11-06 Thread Jeremy Zawodny
On Thu, Nov 06, 2003 at 07:36:55PM +0100, Jan Pieter Kunst wrote: Jeremy D. Zawodny: I was wondering if there is something I can do, configuration-wise, to do something about those very slow 'inserts' (and 'updates') on the Mac? Thanks in advance for any insight, Did it appear to

Benchmark differences: Mac OS X - Linux

2003-11-05 Thread Jan Pieter Kunst
Hi everyone, I recently ran the MySQL benchmark suite on a Dual 1 GHz G4 running Mac OS X Server 10.2.8, and an 800 MHz Intel machine running SuSE Linux 8.0. Both installations used the same my.cnf file. The results are comparable in all benchmarks except one: the 'insert'. In that one, the Mac

Re: Benchmark differences: Mac OS X - Linux

2003-11-05 Thread Gabriel Ricard
I'm not entirely sure what to do about the slow insert results, they are the slowest part no matter how you configure it, it seems. I've attached some benchmark results I ran on a dual 2GHz G5 for comparison. Both MyISAM and InnoDB. Here are the insert results though: MyISAM: insert: Total

Re: Benchmark differences: Mac OS X - Linux

2003-11-05 Thread Brent Baisley
I'd be curious what the specs of the hard drives are. Using the stock drives in the Mac means you are using a drive that's about average (2MB cache, 7200RPM). I would assume they are both ATA/IDE drives. But I would guess the bottleneck is the drive. Try running top when you are running your

Re: Benchmark differences: Mac OS X - Linux

2003-11-05 Thread Gabriel Ricard
FYI, I've found 'iostat' to be quite useful in monitoring the drive transfer rates while benchmarking in OSX. Then again, in Panther all you really need to do is pop open Activity Monitor (formerly Process Viewer) which now has some nifty graphing for system status: cpu, disk, ram activity and