If you're using only MyISAM tables for your data, then key_buffer
should generally have as much RAM as it can have (up to the point
where it makes sense, i.e., only has much RAM as is needed to store
your index data). myisam_sort_buffer_size ought to be about 1/4 of
your RAM.
I re-ran the bench
This is what I'm currently using on the dual 2GHz w/4GB of RAM:
set-variable = query_cache_type=1
set-variable = query_cache_size=1024M
set-variable = net_buffer_length=32760
set-variable = bulk_insert_buffer_size=32M
set-variable= key_buffer=1024M
set-variable= join_buffer_size=128M
set-v
Look in the support-files directory in the mysql directory. There are a
bunch of sample config files that you can look at that named pretty
obviously: small,medium,large,huge.
Each one has a description on what kind of system these should be used
on, based on RAM and usage. For instance, huge is
At 13:21 -0500 07-11-2003, Gabriel Ricard wrote:
[1.8 GHz G5:]
select: Total time: 1428 wallclock secs (67.50 usr 25.18 sys +
0.00 cusr 0.00 csys = 92.68 CPU)
[dual 2.0 GHz G5:]
select: Total time: 146 wallclock secs (42.52 usr 33.74 sys + 0.00
cusr 0.00 csys = 76.26 CPU)
How the select po
On Friday, November 7, 2003, at 03:06 AM, Jan Pieter Kunst wrote:
Hardware: 1.8 GHz G5 with 1GB RAM
Panther (Mac OS X 10.3) doesn't have the sudden slowness in the
'insert' test that Jaguar (Mac OS X 10.2) has. Total time for Panther
is faster than total time for Jaguar (5561.00 secs vs. 677
I was wondering if you had journaling turned on in Panther and not
in Jaguar? I'm not sure if it would have any effect on selects, I
would think it would slow down inserts not selects. You notice the
CPU breakdown is different.
Journaling was turned on in both cases.
JP
--
MySQL General Mailin
Thanks for posting the comparison, it's something I've been meaning to
do myself.
I was wondering if you had journaling turned on in Panther and not in
Jaguar? I'm not sure if it would have any effect on selects, I would
think it would slow down inserts not selects. You notice the CPU
breakdow
Hardware: 1.8 GHz G5 with 1GB RAM
Panther (Mac OS X 10.3) doesn't have the sudden slowness in the
'insert' test that Jaguar (Mac OS X 10.2) has. Total time for Panther
is faster than total time for Jaguar (5561.00 secs vs. 6770.00 secs).
'Insert' is faster on Panther than on Jaguar (3316 secs v
