我的Lnmp环境下的Mysql数据库这段时间老是挂掉,求帮解决!
我的服务器是安装的lnmp集成环境,16G内存,8核,1T硬盘,服务器上放的是400多个小站组成的站群,网站目前流量很小,一天才一两百IP,一般蜘蛛一天也就爬几万个页面而已,但是服务器上的mysql数据库最近老是出现死掉无法连接的问题,都是在晚上的0点到第二天的早上9点这个时间段出现。我在网上找了很久没有找到解决的办法,所以现在来论坛求助,麻烦帮看一下问题在哪里,我把my.cnf配置文件贴出来。port= 3306
socket= /tmp/mysql.sock
datadir = /usr/local/mysql/var
skip-external-locking
key_buffer_size = 160M
max_allowed_packet = 1M
table_open_cache = 1024
sort_buffer_size = 8M
net_buffer_length = 8K
read_buffer_size = 8M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 80M
max_connections = 1500
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
quick
max_allowed_packet = 16M
no-auto-rehash
key_buffer_size = 215M
sort_buffer_size = 512M
read_buffer = 64M
write_buffer = 16M
interactive-timeout
https://bbs.vpser.net/viewthread.php?tid=8914&page=1&fromuid=3#pid26041
页:
[1]