[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]