|
原帖由 fan_zhen_hua 于 2010-8-16 14:11 发表 ![]()
Server version: 5.1.46,linux4.8
磁盘没满,当时的IO看过没有问题。日志也没有任何错误。我怀疑是不是session过多的情况下引起的异常。
另外,这个机器内核参数是没有修改的。(因为机器当时不是我装的。)
$ cat /etc/my.cnf
[client]
default-character-set = gbk
socket=/data/mysqldata/mysql.sock
[mysqld]
open-files-limit=45056
datadir=/data/mysqldata
socket=/data/mysqldata/mysql.sock
user=mysql
character-set-server=GBK
max_connections=5000
old_passwords=1
innodb_file_per_table = 1
innodb_buffer_pool_size=5G
innodb_additional_mem_pool_size=50M
innodb_log_file_size=500M
innodb_log_buffer_size=4M
innodb_flush_log_at_trx_commit=1
innodb_lock_wait_timeout=15
transaction_isolation='READ-COMMITTED'
default-storage-engine = INNODB
lower_case_table_names = 1
safe-user-create
local-infile = 0
tmpdir=/data/mysqllog/tmp
log-bin=/data/mysqllog/binlog
max_binlog_size = 500M
binlog_cache_size = 5M
binlog-format=ROW
sync_binlog = 0
expire_logs_days=3
max_allowed_packet=25M
#log
log-error = /data/mysqllog/log/alert.log
slow_query_log_file = /data/mysqllog/log/slow.log
slow_query_log = 1
long_query_time = 1
[mysql]
socket=/data/mysqldata/mysql.sock
[mysqladmin]
socket=/data/mysqldata/mysql.sock
session过多的情况下引起的异常
------------------------------------
session过多引起内存分配不够的话,日志中应该有记录的
这台主机没做监控吗?看看之前的io/cpu状况 |
|