Re: Anyone using MySQL 4.x on Apple's G5?

[Gabriel Ricard]

I just loaded (LOAD DATA INFILE ...) the main property table (MyISAM 
type) for our database, which contains about 412,000 records. It took 
167.79 seconds to load the data at about 2,456 records per second. The 
table has 124 fields and 16 single-column keys. The records are around 
900B - 1KB each on average (of actual data) and the actual storage 
space per record is 1,487B (variable length records).

bulk_insert_buffer_size = 256MB
myisam_sort_buffer_size = 512MB
I haven't tried out InnoDB tables yet. I will be soon.

- Gabriel

On Wednesday, October 15, 2003, at 11:23  AM, Fortuno, Adam wrote:

Wow, new dual processor G5... <behavior>drool</behavior>

How are the bulk operations performing?

-----Original Message-----
From: Gabriel Ricard [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 15, 2003 11:05 AM
To: [EMAIL PROTECTED]
Subject: Re: Anyone using MySQL 4.x on Apple's G5?
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.
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.
Anything specific you'd like to see numbers for? This box isn't going
to be in production use for a few weeks anyways.
- Gabriel

On Wednesday, October 15, 2003, at 02:13  AM, Jeremy Zawodny wrote:

If so, how is it working out?  Are you taking advantage of the
64bit memory space?
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,151,820,403 queries
(426/sec. avg)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]


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



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