2016-06-23 14:06:56 32289 [Warning] 'proxies_priv' entry '@ root@sh275' ignored in --skip-name-resolve mode. 160623 15:03:49 mysqld_safe Number of processes running now: 0 160623 15:03:49 mysqld_safe mysqld restarted -----發現是mysql服務重啟了，而我們配置了skip_slave_start（禁止repl進程自動重啟），所以復制進程處于down狀態
2016-06-23 15:03:50 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-06-23 15:03:50 0 [Note] /home/data/mysql/bin/mysqld (mysqld 5.6.24-log) starting as process 22569 ...
2016-06-23 15:03:50 22569 [Note] Plugin 'FEDERATED' is disabled.
2016-06-23 15:03:50 22569 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-06-23 15:03:50 22569 [Note] InnoDB: The InnoDB memory heap is disabled
2016-06-23 15:03:50 22569 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-06-23 15:03:50 22569 [Note] InnoDB: Memory barrier is not used
2016-06-23 15:03:50 22569 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-06-23 15:03:50 22569 [Note] InnoDB: Using Linux native AIO
2016-06-23 15:03:50 22569 [Note] InnoDB: Not using CPU crc32 instructions
2016-06-23 15:03:50 22569 [Note] InnoDB: Initializing buffer pool, size = 10.0G
2016-06-23 15:03:51 22569 [Note] InnoDB: Completed initialization of buffer pool
同時我們查看zabbix發送的郵件，有linux主機內存報警通知
告警主機：_HuaYun_Interface-SLAVE
主機IP： ******
告警時間：2016.06.23 15:08:06
告警等級：Average
告警信息：Lack of available memory on server HuaYun_Interface-SLAVE
問題詳情：Available memory:163.15 MB
事件ID： 42590
登上主機檢查
[root@NEW-APP-MYSQL-SLAVE ~]# dmesg
Outof memory: Kill process 32289 (mysqld) score 966 or sacrifice child
Killed process 32289, UID 498,(mysqld) total-vm:14630648kB, anon-rss:7711284kB, file-rss:360kB
