On Tue, 2005-11-29 at 10:44 -0500, Benjamin Adams wrote:
> Dual G5 8G Ram
> # Here follows entries for some specific programs
What kind of application are you running ?
How many connections and how complex are queries ?
What storage engines are you using ?
I think you bump your per thread variables too high - do no do it unless
you have clear indication it would help.
In general increasing key_buffer_size to some 2-3GB is probably best
use of your memory if you use MyISAM tables exclusively.
> # The MySQL server
> port = 3306
> socket = /tmp/mysql.sock
> #socket = /var/mysql/mysql.sock
> key_buffer = 128M
> max_allowed_packet = 64M #20M
> table_cache = 3000
> sort_buffer_size = 16M #2M
> read_buffer_size = 16M #2M
> read_rnd_buffer_size = 32M #8M
> myisam_sort_buffer_size = 64M
> join_buffer_size = 16M #no default
> thread_cache = 64 #40 #8
> thread_cache_size = 200
> long_query_time = 5
> low_priority_updates = ON
> query_cache_type = 1
> query_cache_size = 32M #64M
> query_cache_limit = 1M
> wait_timeout = 100 #28800
> interactive_timeout = 300
> tmp_table_size = 32M
> # Try number of CPU's*2 for thread_concurrency
> #thread_concurrency = 10
> #This section has been added for Logging
> cache is the problem I'm having, I think
Peter Zaitsev, Senior Performance Engineer
MySQL AB, www.mysql.com