[dev] shares performance hit (was Re: disable shares)

Didi Rieder adrieder at sbox.tugraz.at
Tue Jun 17 07:59:30 UTC 2008


Quoting duck <duck at obala.net>:

> On Tue, 2008-06-10 at 17:00 +0200, Didi Rieder wrote:
>> So the only thing left would be the "thread_cache_size" which is
>> smaller then you are suggesing. I'll increase it and see if it helps.
>
> Maybe. Starting a new process for each new request gets pretty expensive
> pretty quickly. Set your thread cache high enough that the
> Threads_created value in SHOW STATUS stops increasing. Your CPU will
> thank you. If is this the only reason maybe is a problem with thread
> implementation or system I/O. Is your server build from source or do you
> use an offical binary? A lot of maybe. As I just thinking about your
> input.

I think I found now the right mysql-server settings,  with which
the performance is quite Ok. Increasing the sort_buffer_size was one
of the changes that helped.

skip-external-locking
skip-thread-priority
key_buffer = 64M
max_connections = 1024
max_connect_errors = 1000
max_allowed_packet = 8M
table_cache = 512
sort_buffer_size = 8M
read_buffer_size = 1M
read_rnd_buffer_size = 2M
myisam_sort_buffer_size = 64M
thread_cache_size = 50
query_cache_size = 128M
tmp_table_size= 1024M
thread_concurrency = 12
wait_timeout = 60
interactive_timeout = 60
log_slow_queries

Thanks Duck for your help!!!

Didi

-- 
-------------------------
Didi Rieder
adrieder at sbox.tugraz.at
PGPKey ID: 3431D0B0
-------------------------



More information about the dev mailing list