Tweet
Hey guys,
Today we had a problem that I can not resolve with mysql. All of a sudden mysql just stop accepting connections. Of course I thought that a table had become corrupt as it has before therefore you just run stop the db and run myisamchk and restart the server.
Upon trying to stop the server I noticed that the server just kept trying to stop but kept giving up. I then sent a killall -9 mysqld and noticed on the command line that the server automatically sent a nohup to the server and restarted the service. I finally was able to stop the service but noticed in the error logs the following:
[ERROR] /db/mysql/libexec/mysqld: Forcing close of thread 877 user: ''
I proceeded to repair the db and restart the server. Once the server was restarted, I still could not connect via the web but could via the mysql monitor. While in the monitor i check all tables again and the status was "OK" but no connections. I tried to stop the service and once again the service would not stop. I dont know what else to do.. I have even optimized the tables to no avail.. the server has been running fine with the exception of the normail mysql problems, repairing various table from time to time
Here is my my.cnf
# Example mysql config file for large systems.
#
# This is for large system with memory = 512M where the system runs mainly
# MySQL.
#
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /db/mysql/var) or
# ~/.my.cnf to set user-specific options.
#
# One can in this file use all long options that the program supports.
# If you want to know which options a program support, run the program
# with --help option.
# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
#socket = 3306
socket = /tmp/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3306
#socket = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 80M
max_allowed_packet = 16M
table_cache = 1024
sort_buffer_size = 2M
read_buffer_size = 2M
myisam_sort_buffer_size = 64M
thread_cache = 64
query_cache_size= 40M
max_connections=800
join_buffer=2M
record_buffer=5M
thread_stack=128K
wait_timeout=1800
connect_timeout=10
max_connect_errors=10
query_cache_limit=1M
query_cache_size = 64M
query_cache_type = 1
tmp_table_size = 32M
read_rnd_buffer_size = 524288
skip-innodb
bind-address=69.56.175.224
old_passwords
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
#
#skip-networking
# Replication Master Server (default)
# binary logging is required for replication
log-bin
# required unique id between 1 and 2^32 - 1
#
#
#
.....
#
#
# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = /db/mysql/var/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /db/mysql/var/
innodb_log_arch_dir = /db/mysql/var/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 256M
innodb_additional_mem_pool_size = 100M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 64M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
[mysqld_safe]
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 4M
write_buffer = 4M
[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 16M
write_buffer = 16M
[mysqlhotcopy]
interactive-timeout
Any suggestions would be appreciated
Thanks
Today we had a problem that I can not resolve with mysql. All of a sudden mysql just stop accepting connections. Of course I thought that a table had become corrupt as it has before therefore you just run stop the db and run myisamchk and restart the server.
Upon trying to stop the server I noticed that the server just kept trying to stop but kept giving up. I then sent a killall -9 mysqld and noticed on the command line that the server automatically sent a nohup to the server and restarted the service. I finally was able to stop the service but noticed in the error logs the following:
[ERROR] /db/mysql/libexec/mysqld: Forcing close of thread 877 user: ''
I proceeded to repair the db and restart the server. Once the server was restarted, I still could not connect via the web but could via the mysql monitor. While in the monitor i check all tables again and the status was "OK" but no connections. I tried to stop the service and once again the service would not stop. I dont know what else to do.. I have even optimized the tables to no avail.. the server has been running fine with the exception of the normail mysql problems, repairing various table from time to time
Here is my my.cnf
# Example mysql config file for large systems.
#
# This is for large system with memory = 512M where the system runs mainly
# MySQL.
#
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /db/mysql/var) or
# ~/.my.cnf to set user-specific options.
#
# One can in this file use all long options that the program supports.
# If you want to know which options a program support, run the program
# with --help option.
# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
#socket = 3306
socket = /tmp/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3306
#socket = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 80M
max_allowed_packet = 16M
table_cache = 1024
sort_buffer_size = 2M
read_buffer_size = 2M
myisam_sort_buffer_size = 64M
thread_cache = 64
query_cache_size= 40M
max_connections=800
join_buffer=2M
record_buffer=5M
thread_stack=128K
wait_timeout=1800
connect_timeout=10
max_connect_errors=10
query_cache_limit=1M
query_cache_size = 64M
query_cache_type = 1
tmp_table_size = 32M
read_rnd_buffer_size = 524288
skip-innodb
bind-address=69.56.175.224
old_passwords
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
#
#skip-networking
# Replication Master Server (default)
# binary logging is required for replication
log-bin
# required unique id between 1 and 2^32 - 1
#
#
#
.....
#
#
# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = /db/mysql/var/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /db/mysql/var/
innodb_log_arch_dir = /db/mysql/var/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 256M
innodb_additional_mem_pool_size = 100M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 64M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
[mysqld_safe]
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 4M
write_buffer = 4M
[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 16M
write_buffer = 16M
[mysqlhotcopy]
interactive-timeout
Any suggestions would be appreciated
Thanks
Comment