Each one has a description on what kind of system these should be used on, based on RAM and usage. For instance, huge is for systems with 512MB. If you have 2GB on your box, you may want to base your settings on the huge config file, which is for systems with 1-2GB.
I'm no expert on the settings so you may have to dig in the online manual to customize for your needs.
On Friday, November 7, 2003, at 06:32 PM, Jan Pieter Kunst wrote:
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 portion of the test could be 10x slower, I'm not sure. Have you tuned MySQL at all? key_buffer, etc?
Well, I'm looking for advice on how I should tune MySQL. These are the relevant parts of the my.cnf I used:
[mysqld] skip-locking set-variable = key_buffer=64M set-variable = max_allowed_packet=1M set-variable = table_cache=256 set-variable = sort_buffer=4M set-variable = net_buffer_length=8K set-variable = record_buffer=1M set-variable = thread_cache=8 set-variable = myisam_sort_buffer_size=8M log-bin server-id = 1
[mysqldump] quick set-variable = max_allowed_packet=16M
[mysql] no-auto-rehash
[isamchk] set-variable = key_buffer=20M set-variable = sort_buffer=20M set-variable = read_buffer=2M set-variable = write_buffer=2M
[myisamchk] set-variable = key_buffer=20M set-variable = sort_buffer=20M set-variable = read_buffer=2M set-variable = write_buffer=2M
If you have any advice on what I could change here to get faster selects, I'm all ears.
Thanks in advance, Jan Pieter Kunst
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]