MySQL Forums :: Newbie :: Both master and slave stop accepting connections


Advanced Search

Both master and slave stop accepting connections
Posted by: Ueberbach JP ()
Date: September 29, 2011 07:37AM

We have a high performance website using mysql community server 5.1.58.

We monitor the connection for this mysql server with mysql server administrator.

After a while both master and slave stop accepting connections and both the processes need to be killed and started in order to let them accept connections again.

When this occurs we have taken a look at the stats in mysql server administrator.

Connection usage seems to be normal, nothing special there. Memory usage is normal, everything is normal. All graphs are hanging.

The strange thing is that the behavior immediately affects the slave as well.

We process millions of queries before this behavior happens.

We use a lot of select into outfile and load data queries.

Below you will find the configuration of the master

[mysqld]
skip-name-resolve
enable-named-pipe
socket=MYSQLPIPENL
tmpdir=D:/mercurius/nl/mysql/data/keyfiles/mercurius_nl/temp
basedir=D:/mercurius/nl/mysql
datadir=D:/mercurius/nl/mysql/data
init-file=D:/mercurius/nl/temp/loader.read.sql
init-connect=D:/mercurius/nl/web/admin/libs/init_connect.sql
port=3301
pid-file=D:/mercurius/nl/mysqld.6.pid
myisam_use_mmap

ft_min_word_len=4
ft_max_word_len=14

net_buffer_length=1048576
read_buffer_size=2048k
read_rnd_buffer_size=2048k
query_alloc_block_size=2048k
range_alloc_block_size=2048k
preload_buffer_size=32768k
sort_buffer_size=2048k
query_prealloc_size=1024k
join_buffer_size=4096k
connect_timeout=2
wait_timeout=6
net_read_timeout=5
net_write_timeout=5
max_sort_length=8
max_length_for_sort_data=8
bulk_insert_buffer_size=32768k



query_cache_size=20M # Query cache is used to cache SELECT results and later return them
# without actual executing the same query once again.

query_cache_min_res_unit=512
query_cache_limit=4194304
max_allowed_packet=8M

max_heap_table_size=838860800
key_buffer_size=8M

default-character-set=utf8 # The default character set

default-storage-engine=INNODB # The default storage engine

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" # Set the SQL mode to strict

max_connections=40 # The maximum amount of concurrent sessions the MySQL server will allow.

table_cache=128 # The number of open tables for all threads.

tmp_table_size=128M # Maximum size for internal (in-memory) temporary tables

thread_cache_size=10 # How many threads we should keep in a cache for reuse.

myisam_max_sort_file_size=2048k # The maximum size of the temporary file MySQL is allowed to use

myisam_max_extra_sort_file_size=2048k # If the temporary file used for fast index creation would be bigger
# than using the key cache by the amount specified here

myisam_sort_buffer_size=20M # If the temporary file used for fast index creation would be bigger
# than using the key cache by the amount specified here

innodb_open_files = 300
innodb_file_per_table
innodb_buffer_pool_size = 100M
innodb_flush_log_at_trx_commit = 2
innodb_thread_concurrency =8
innodb_lock_wait_timeout = 200
interactive_timeout = 10
back_log = 75
table_cache = 240
thread_concurrency = 8
innodb_log_file_size = 5242880

innodb_log_buffer_size=4M

transaction-isolation=READ-UNCOMMITTED



#--------------------------------------------------
server-id = 1
replicate-same-server-id = 0
auto-increment-increment = 2
auto-increment-offset = 1
log-bin=F:/BINLOG/mercurius_NL/binlog.log
binlog-do-db=ilocal
binlog-ignore-db=mysql
binlog-ignore-db=test
binlog-ignore-db=memlocal
binlog_format=ROW
sync_binlog=1
expire_logs_days=7

Options: ReplyQuote


Subject Written By Posted
Both master and slave stop accepting connections Ueberbach JP 09/29/2011 07:37AM
Re: Both master and slave stop accepting connections Rick James 09/30/2011 09:34PM
Re: Both master and slave stop accepting connections admin www.mercuriusgids.nl 10/05/2011 09:35AM
Re: Both master and slave stop accepting connections admin www.mercuriusgids.nl 10/05/2011 11:51PM
Re: Both master and slave stop accepting connections Rick James 10/09/2011 07:42AM
Re: Both master and slave stop accepting connections admin www.mercuriusgids.nl 10/10/2011 01:31AM
Re: Both master and slave stop accepting connections Ueberbach JP 11/10/2011 06:26AM
Re: Both master and slave stop accepting connections (solved) Ueberbach JP 11/10/2011 06:31AM


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.