Mysql
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
僅僅因為一個程序正在
top
使用資源並不意味著它正在經歷錯誤。這對於數據庫來說是意料之中的,尤其是對於 MySQL 等數據庫。要查看 MySQL 到底發生了什麼,您可以在客戶端中使用
mytop
或執行。SHOW FULL PROCESSLIST;``mysql