Further Optimize my.cnf
lately for some reason I started noticing that my server has some issues and every now and then the sql would stop working and it would not even be able to restart.
Here is my my.cnf can you please think of some way I can further optimize it.
--------------------------------------------------------------------------------------------------
[mysqld]
max_allowed_packet=100M
max_connections=1000
#safe-show-database
# Connection timeout
connect_timeout = 20
# Timeout for inactive connections
wait_timeout = 20
# Network buffer length (I think this is the linux default)
net_buffer_length = 16K
log-error = /etc/httpd/logs/mysqld.err
binlog_cache_size = 2M
table_cache = 6588
query_cache_size = 8M
join_buffer_size = 320M
thread_cache_size = 6
max_heap_table_size = 320M
#query_cache_size = 312M
key_buffer_size = 128M
[client]
socket=/var/lib/mysql/mysql.sock
Subject
Views
Written By
Posted
Further Optimize my.cnf
3189
April 26, 2011 03:18PM
1130
April 29, 2011 01:41PM
1064
May 01, 2011 06:55PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.