MySQL start problems

IT_Architect

Verified User
Joined
Feb 27, 2006
Messages
1,088
1. Whenever I restart the server, MySQL 5.0 hangs sorta. The PID shows in DA, but I get socket errors. I cannot stop and then start start it from DA. I need to SSH in, find the process, kill it, and start MySQL.

2. When MySQL is up and running fine, then I can go into control panel and stop it and start it.

The behavior is consistent. Any ideas?

Thanks!
 
Please copy/paste in forum your /etc/my.cnf
[mysqld]
datadir=/home/mysql
socket=/tmp/mysql.sock
skip-locking
#skip-innodb
#query_cache_limit=24M

#query_cache_size=228M
#query_cache_type=1
#max_connections=500
#max_user_connections=50
#interactive_timeout=20
wait_timeout=50
#connect_timeout=30
#thread_cache_size=128
#key_buffer=128M
#join_buffer=4M
#max_allowed_packet=16M
#table_cache=1024
#record_buffer=4M
#sort_buffer_size=2M
#read_buffer_size=2M
#max_connect_errors=10
# Try number of CPU's*2 for thread_concurrency
#thread_concurrency=4
#myisam_sort_buffer_size=64M
#log-bin
server-id=1

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
#pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
#safe-updates

[isamchk]
key_buffer=32M
sort_buffer=32M
read_buffer=16M
write_buffer=16M

[myisamchk]
key_buffer=32M
sort_buffer=32M
read_buffer=16M
write_buffer=16M

The server gets massive traffic and runs fine. It's just this little drill we need to do every time we reboot it.

Thanks!
 
Back
Top