MySQL Server stops responding

[Roshan Iqbal]

Hi,

New at MySQL. We are experience 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