Re: MYsql getting crash
Hi James
I am having 32 GB Ram and i have allocated 80 % o Mysql. Please have look on my My.cnf
max_connections=800
log-bin=mysql-bin
innodb_file_per_table
key_buffer=256M
max_allowed_packet=64M
table_cache=2048
sort_buffer_size=2M
read_buffer_size=2M
join_buffer_size=2M
tmp_table_size=32M
query_cache_size=256M
#To log queries that take more than 3 secs to execute
log_slow_queries=/var/log/mysqld.slow.log
long_query_time=3
skip-bdb
# Innodb Related
innodb_buffer_pool_size=4G
innodb_log_file_size=512M
innodb_log_buffer_size=16M
thread_cache=32
#connect_timeout=360
#removed wait_timeout - let this default to system limit
#wait_timeout = 300
# The default storage engine to be used when new tables are created
default-storage-engine=innodb
Thanks
Subject
Written By
Posted
Re: MYsql getting crash
October 26, 2009 11:51PM
November 06, 2009 02:33AM
November 06, 2009 10:28AM
December 06, 2009 07:51AM
December 30, 2009 11:42PM
December 31, 2009 03:06AM
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.