MySQL Server stops responding
Posted by: Roshan Iqbal
Date: May 04, 2005 12:41PM

Hi,

New at MySQL. We are experiencing that the database freezes
leading to requring us restart the machine. This has occured
twice in a span of 1 week. We are able to obtain connections to the
server. But once we try to execute a query the server
freezes and stops responding.

I have captured some more details regarding configuration below.

Configuration
================
Windows Standard Edition 2003 with 4GB RAM
MySQL Server 4.1.10
Connector/J 3.1.7
Database Engine InnoDB
Current database size is 6 GB

my.ini
=======
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 256M
max_connections = 100
max_allowed_packet = 1M
table_cache = 400
sort_buffer_size = 4M
tmp_table_size = 64M
read_buffer_size = 4M
read_rnd_buffer_size = 4M
thread_cache = 100
query_cache_size= 32M
thread_concurrency = 4

skip-name-resolve
log-bin
server-id = 1

innodb_buffer_pool_size = 1G
innodb_additional_mem_pool_size = 8M
innodb_file_io_threads = 8
innodb_thread_concurrency = 4
innodb_log_file_size = 256M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

[mysqldump]
quick
max_allowed_packet = 1M


Questions
============
1. Where should we look for fixing this problem?
2. What kinds of tracing will help in getting more details on the cause of this problem?
3. Are there are any monitoring tools that can be
used to check the health of MySQL server to track any symptoms?

Appreciate your help.

regards
Roshan

Options: ReplyQuote


Subject
Written By
Posted
MySQL Server stops responding
May 04, 2005 12:41PM


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.