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:gabe@stripped]
> Sent: Wednesday, October 15, 2003 11:05 AM
> To: mysql@stripped
> 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!
>> <Jeremy@stripped> | 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/mysql?unsub=1
>>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
