mysql最近总是无故自动关闭，求助啊！

第2韩非

mysql最近总是无故自动关闭，上着上着突然上不去网站，top一下发现进程没有mysql选项，重启以后就没事了，过一段时间继续这样。
错误日志如下：
111222 20:42:15 [Note] /usr/local/libexec/mysqld: Normal shutdown

111222 20:42:15 [Note] Event Scheduler: Purging the queue. 0 events
111222 20:42:17 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 482929  user: 'root'

111222 20:45:36 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
111222 20:45:37 [Note] Plugin 'FEDERATED' is disabled.
111222 20:45:37  InnoDB: Initializing buffer pool, size = 8.0M
111222 20:45:37  InnoDB: Completed initialization of buffer pool
111222 20:45:37  InnoDB: Started; log sequence number 0 44273
111222 20:45:37 [Note] Recovering after a crash using mysql-bin
111222 20:45:40 [Note] Starting crash recovery...
111222 20:45:40 [Note] Crash recovery finished.
111222 20:45:40 [Note] Event Scheduler: Loaded 0 events
111222 20:45:40 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.1.56-log'  socket: '/tmp/mysql.sock'  port: 3306  FreeBSD port: mysql-server-5.1.56

希望各位老大给老弟指点下。

第2韩非

{:3_185:}，没人啊。

小版主杀手

第2韩非 发表于 2011-12-23 10:48
，没人啊。

mysql 占用CPU过高?

第2韩非

没有，有的时候晚上也能卡死，很低的时候也能卡死

第2韩非

小版主杀手 发表于 2011-12-23 11:10
mysql 占用CPU过高?

没呢，不高。

小版主杀手

感觉是程序问题,贴下配置看看

第2韩非

小版主杀手 发表于 2011-12-23 11:19
感觉是程序问题

我用的discuz的程序，有什么需要优化的吗，给指点指点吧。

第2韩非

小版主杀手 发表于 2011-12-23 11:19
感觉是程序问题,贴下配置看看

[mysqld]
port                = 3306
socket                = /tmp/mysql.sock
#skip-locking
skip-external-locking
skip-name-resolve
back_log = 500
key_buffer_size = 1024M
max_allowed_packet = 64M
table_open_cache = 512
sort_buffer_size = 8M
read_buffer_size = 8M
join_buffer_size = 8M
read_rnd_buffer_size = 16M
myisam_sort_buffer_size = 64M
thread_cache_size = 64
query_cache_size= 64M
query_cache_limit = 2M
log_slow_queries= /var/log/slow_query.log
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
tmp_table_size = 256M
max_connections = 1000
max_connect_errors = 10000000

wait_timeout=100
interactive_timeout = 100

# 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=mysql-bin

# binary logging format - mixed recommended
binlog_format=mixed
mysql的配置。

小版主杀手

第2韩非 发表于 2011-12-23 11:21
[mysqld]
port                = 3306
socket                = /tmp/mysql.sock

你内存有多大
按你这个配置
内存至少要18G

第2韩非

小版主杀手 发表于 2011-12-23 11:40
你内存有多大
按你这个配置
内存至少要18G

应该是24G，装的freebsd amd64位系统。