mysql登陆嘟一声就关闭了_mysql运行几天后就会自动关闭，连接无响应 有日志

软件环境：win2000 IIS+PHP 4.3.9+MySQL 5.0.18+Zend Optimizer 2.6.2+phpMyAdmin2.7+phpwind 4.32

论坛最大在线1000人左右

主要是论坛经常出现：

Connect(0) to MySQL (localhost,wodwjj) failed

The URL Is:

http://www.***.com/index.php?

MySQL Server Error:

Can't connect to MySQL server on 'localhost' (10061) ( 2003 )

You Can Get Help In:

http://www.phpwind.net

重起后正常几天又是这样

mysql日志显示：

060827 21:27:36  InnoDB: Started; log sequence number 0 59236

060827 21:27:38 [Note] G:\mysql\bin\mysqld-nt: ready for connections.

Version: '5.0.18-nt'  socket: ''  port: 3306  MySQL Community Edition (GPL)

060830 12:11:53  InnoDB: Started; log sequence number 0 59236

060830 12:11:55 [Note] G:\mysql\bin\mysqld-nt: ready for connections.

Version: '5.0.18-nt'  socket: ''  port: 3306  MySQL Community Edition (GPL)

060904 23:01:21  InnoDB: Started; log sequence number 0 59236

060904 23:01:23 [Note] G:\mysql\bin\mysqld-nt: ready for connections.

Version: '5.0.18-nt'  socket: ''  port: 3306  MySQL Community Edition (GPL)

060908 14:50:11  InnoDB: Started; log sequence number 0 59236

060908 14:50:13 [Note] G:\mysql\bin\mysqld-nt: ready for connections.

Version: '5.0.18-nt'  socket: ''  port: 3306  MySQL Community Edition (GPL)

060908 14:53:35 [Note] G:\mysql\bin\mysqld-nt: Normal shutdown

060908 14:53:35  InnoDB: Starting shutdown...

060908 14:53:37  InnoDB: Shutdown completed; log sequence number 0 59236

060908 14:53:37 [Note] G:\mysql\bin\mysqld-nt: Shutdown complete

060908 14:55:40  InnoDB: Started; log sequence number 0 59236

060908 14:55:42 [Note] G:\mysql\bin\mysqld-nt: ready for connections.

Version: '5.0.18-nt'  socket: ''  port: 3306  MySQL Community Edition (GPL)

060911 16:20:15 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:27:32 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:27:32 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:28:18 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:28:27 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:28:28 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:28:34 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:28:38 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:28:38 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:28:39 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:28:40 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:28:43 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:28:46 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:28:47 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:28:50 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:28:53 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:28:53 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:28:55 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:28:56 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:29:00 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:29:05 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:29:07 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:29:09 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:29:17 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:29:19 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:29:37 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:29:41 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:29:42 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:29:45 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:29:51 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:29:53 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:29:58 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:29:59 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:30:05 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:30:07 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:30:09 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:30:19 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:30:21 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:30:21 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:30:26 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:30:26 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:30:30 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:30:36 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:30:36 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:30:37 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:30:44 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:30:48 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:30:55 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:30:58 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:30:58 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:31:00 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:31:10 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:31:16 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:31:29 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:31:30 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:31:34 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:31:34 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:31:36 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:31:42 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:31:43 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:31:44 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:31:48 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:31:51 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:31:55 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:31:56 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:31:59 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:32:02 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:32:03 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:32:11 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:32:13 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:32:16 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:32:17 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:32:18 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:32:30 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:32:31 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:32:36 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:32:36 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:32:39 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:32:49 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:33:00 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:33:07 [ERROR] G:\mysql\bin\mysqld-nt: Sort aborted

060911 16:33:14 [Note] G:\mysql\bin\mysqld-nt: Normal shutdown

my.ini 配置：

[client]

port=3306

[mysql]

default-character-set=latin1

[mysqld]

port=3306

basedir="G:/mysql/"

datadir="G:/mysql/Data/"

default-character-set=latin1

default-storage-engine=INNODB

# Set the SQL mode to strict

max_connections=100

query_cache_size=0

table_cache=256

tmp_table_size=9M

thread_cache_size=8

myisam_max_sort_file_size=100G

myisam_max_extra_sort_file_size=100G

myisam_sort_buffer_size=18M

key_buffer_size=11M

read_buffer_size=64K

read_rnd_buffer_size=256K

sort_buffer_size=256K

innodb_additional_mem_pool_size=2M

innodb_flush_log_at_trx_commit=1

innodb_log_buffer_size=1M

innodb_buffer_pool_size=18M

innodb_log_file_size=10M

innodb_thread_concurrency=10

作者: qwezxc

发布时间: 2006-09-13