☰

MySQL 进程显示在顶部但没有记录错误

tag-icon • tag-icon mysql top
MySQL 进程显示在顶部但没有记录错误

我在 TOP 中看到以下内容

 2311 mysql      20   0 1324M  646M  9188 S  0.0 17.1  0:00.00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/ip-172-30-3-82.err --pid-file=/var/lib/mysql/ip-172-30-3-82.pid

当我跟踪错误文件时，我没有看到任何新内容。我怎样才能阻止这些（或者这很重要吗？）

tail -f /var/lib/mysql/ip-172-30-3-82.err
2015-06-08 14:20:40 2310 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.24-72.2 started; log sequence number 25825378787
2015-06-08 14:20:40 2310 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.
2015-06-08 14:20:40 2310 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.
2015-06-08 14:20:40 2310 [Note] Server hostname (bind-address): '*'; port: 3306
2015-06-08 14:20:40 2310 [Note] IPv6 is available.
2015-06-08 14:20:40 2310 [Note]   - '::' resolves to '::';
2015-06-08 14:20:40 2310 [Note] Server socket created on IP: '::'.
2015-06-08 14:20:40 2310 [Note] Event Scheduler: Loaded 0 events
2015-06-08 14:20:40 2310 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.24-72.2'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Percona Server (GPL), Release 72.2, Revision 8d0f85b

答案1

仅仅因为进程正在运行top并正在利用资源并不意味着它遇到了错误。这是数据库的预期，尤其是 MySQL 等数据库。

要查看 MySQL 到底发生了什么，您可以在客户端中使用mytop或运行。SHOW FULL PROCESSLIST;mysql

相关内容