MySQL Forums
Forum List  »  Optimizer & Parser

Further Optimize my.cnf
Posted by: Chirag Patel
Date: April 26, 2011 03:18PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Further Optimize my.cnf
3087
April 26, 2011 03:18PM
1077
April 29, 2011 01:41PM
1010
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.