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!
<[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/

MySQL 4.0.15-Yahoo-SMP: up 31 days, processed 1,183,880,635 queries (431/sec. avg)

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to