最近发现面板经常出现节点离线的情况,主机CPU也时不时超过100,查看Longview记录,发现问题出在mysql进程上,由于安装完之后一直保持默认设置,mysql进程的内存占用一直在10%左右,推测可能是由于同时查询量过多导致MySQL内存溢出丢失连接
环境
- MariaDB 10.1
检查
下载mysql-tuner
wget http://mysqltuner.pl/ -O mysqltuner.pl wget https://raw.githubusercontent.com/major/MySQLTuner-perl/master/basic_passwords.txt -O basic_passwords.txt wget https://raw.githubusercontent.com/major/MySQLTuner-perl/master/vulnerabilities.csv -O vulnerabilities.csv