Here's what I've got for a my.cnf
We literally went from 30 second plus querries to 2.3 seconds. Dunno if it was changing from 3.2 to 4.0 or changing from openbsd to redhat either way I'm a happy dude
We just added another 256Meg of ram, so I've got a total of 512 to play with... heh heh...
[mysqld]<br />datadir=/var/lib/mysql<br />socket=/var/lib/mysql/mysql.sock<br />max_connections = 500<br />skip-innodb<br />query_cache_limit = 1<br />query_cache_size = 64<br />query_cache_type = 1<br />interactive_timeout = 100<br />wait_timeout = 100<br />connect_timeout = 10<br />thread_cache_size = 128<br />key_buffer = 64M<br />join_buffer = 1M<br />max_allowed_packet = 16M<br />table_cache = 2048<br />record_buffer = 2M<br />sort_buffer_size = 8M<br />read_buffer_size = 8M<br />read_rnd_buffer_size=768K<br />max_connect_errors = 10<br />thread_concurrency = 2<br /><br /><br />[mysql.server]<br />user=mysql<br />basedir=/var/lib<br /><br />[safe_mysqld]<br />err-log=/var/log/mysqld.log<br />pid-file=/var/run/mysqld/mysqld.pid<br />