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 be disk or CPU bound? > > Sorry, newbie here. I don't know how I can tell. The RUN file says > this about the 'insert': > > insert: Total time: 6811 wallclock secs (881.86 usr 0.00 sys + 0.00 > cusr 0.00 csys = 881.86 CPU) > > Does that mean anything in this regard?
Run the benchmark again. Notice if the CPU is consistently around 100% or not. If not, it's disk bound. Otherwise, it's CPU bound. > >What are the filesystems like on each? Journaling on either? Hard > >disks and cache? RAID/SCSI controllers? > > 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. That's about all I can tell you, I > really don't know that much about the details of the hardware. Sorry, > not much help here, I know. Hmm. The Mac had journaling but the Linux box did not (ext2 is not journaled). That could have influenced things too. I know virtually nothing about HFS+ journaling. > Anyway, I now have Panther (Mac OS X 10.3) and the Perl DBI/DBD stuff > installed on my G5 and I'll run the benchmarks tonight. (I earlier > ran the benchmarks under Jaguar (Mac OS X 10.2) on the G5, and I also > got a relative 'spike' in the insert-test compared to the other > tests, just as on the G4.) I'll report the Panther-results later. Cool. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 53 days, processed 2,006,750,860 queries (431/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
