tune mysql
madunix
madunix at gmail.com
Fri Jan 15 15:30:06 UTC 2010
i have an old server running redhat 32bit on dual 2GHz and 2GBRAM with mysql4
am thinking to improve mysql with the following parameter can you
check it please.
skip-locking
skip-innodb
query_cache_type=1
query_cache_limit=1M
query_cache_size=32M
max_connections=200
interactive_timeout=100
# Reduced wait_timeout to prevent idle clients holding connections.
wait_timeout=15
connect_timeout=10
# Checked opened tables and adjusted accordingly after running for a while.
table_cache=512
tmp_table_size=32M
# Reduced it to 32 to prevent memory hogging. Also, see notes below.
thread_cache=32
# Reduced it by checking current size of *.MYI files, see notes below.
key_buffer=128M
# Commented out the buffer sizes and keeping the default.
sort_buffer_size=2M
#read_buffer
# 1Mb of read_rnd_buffer_size for 1GB RAM -- see notes below.
read_rnd_buffer_size=1M
read_buffer_size=1M
# myisam_sort_buffer_size used for ALTER, OPTIMIZE, REPAIR TABLE commands.
myisam_sort_buffer_size=32M
# thread_concurrency = 2 * (no. of CPU)
thread_concurrency=2
#logs
log_slow_queries=/var/log/mysqld.slow.log
long_query_time=2
Thanks
More information about the redhat-list
mailing list