tune mysql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
redhat-list mailing list
unsubscribe mailto:redhat-list-request@xxxxxxxxxx?subject=unsubscribe
https://www.redhat.com/mailman/listinfo/redhat-list

[Index of Archives]     [CentOS]     [Kernel Development]     [PAM]     [Fedora Users]     [Red Hat Development]     [Big List of Linux Books]     [Linux Admin]     [Gimp]     [Asterisk PBX]     [Yosemite News]     [Red Hat Crash Utility]


  Powered by Linux