Mysql錯誤處理: /usr/bin/mysqld_safe: line xxx: xxxx Killed ... (mysql自動停止 Plugin FEDERATED is disabled 的完美解決方法)

哈哈哈，問題總算解決，内心抑不住的開心

centos mysql 問題：Plugin 'FEDERATED' is disabled. /usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist

早上看到伺服器mysql挂掉了。于是重新開機mysql,啟動失敗:

/usr/bin/mysqld_safe: line 183: 23638 Killed                  nohup /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock < /dev/null > /dev/null 2>&1

MySQL Daemon failed to start.

Starting mysqld:                                           [FAILED]

解決:

vim /etc/my.cnf

[root@YoujiePMP ~]# vim /etc/my.cnf

加入配置:

key_buffer=16K

table_open_cache=4

query_cache_limit=256K

query_cache_size=4M

max_allowed_packet=1M

sort_buffer_size=64K

read_buffer_size=256K

thread_stack=64K

innodb_buffer_pool_size = 56M

儲存。重新開機mysql

service mysqld restart

解決之。