On Wed, Oct 15, 2003 at 11:04:47AM -0400, Gabriel Ricard wrote:
> I am currently testing this on a new dual 2GHz G5 with 4GB of RAM.
> Seems pretty nice so far. I've loaded up a copy of our production
> database (4GB of data for real estate web sites) and moderate property
> search queries of ours run much faster than on our dual G4 MDD
> PowerMac. I guess we're really not taking advantage of the 64 bit
> memory space as we've only got 4GB of RAM in it currently, heh.
What sort of disks are you using? IDE? SCSI?
> I've been running the sql-bench/run-all-tests benchmark and trying to
> figure out why insert_key is taking 2440 wall clock seconds. Everything
> else is damn zippy.
Is it CPU or I/O bound at that point?
> Anything specific you'd like to see numbers for? This box isn't going
> to be in production use for a few weeks anyways.
I'd be interested to know if you can get a test running that uses
either a key_buffer or an innodb_buffer_pool in the 3.5GB range.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped> | http://jeremy.zawodny.com/
MySQL 4.0.15-Yahoo-SMP: up 31 days, processed 1,183,880,635 queries (431/sec. avg)
