【Mysql】Mysql從庫每隔一段時間就重啟

背景：HuaYun_Interface-SLAVE從庫每隔一段時間slave復(fù)制進程便停掉，zabbix發(fā)送告警短信

MySQL> show slave status\G;
*************************** 1. row ***************************
Slave_IO_State:
Master_Host: *****
Master_User: repl
Master_Port: 3307
Connect_Retry: 60
Master_Log_File: mysql-bin.000195
Read_Master_Log_Pos: 629275501
Relay_Log_File: mysql-relay-bin.000521
Relay_Log_Pos: 625430128
Relay_Master_Log_File: mysql-bin.000195
Slave_IO_Running: No
Slave_SQL_Running: No

停掉時查看mysql錯誤日志我們發(fā)現(xiàn)端倪

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 -----發(fā)現(xiàn)是mysql服務(wù)重啟了，而我們配置了skip_slave_start（禁止repl進程自動重啟），所以復(fù)制進程處于down狀態(tài)
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發(fā)送的郵件，有l(wèi)inux主機內(nèi)存報警通知

告警主機：_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
Out of 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

[root@NEW-APP-MYSQL-SLAVE ~]# free -m
total used free shared buffers cached
Mem: 7872 7747 124 0 124 1331
-/+ buffers/cache: 6292 1580
Swap: 2047 56 1991

很明顯是linux內(nèi)存不足而發(fā)生了OOM killer現(xiàn)象，沒辦法，加大主機內(nèi)存吧

網(wǎng)頁標(biāo)題：【Mysql】Mysql從庫每隔一段時間就重啟
轉(zhuǎn)載注明：http://chinadenli.net/article10/ihjgdo.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供Google、品牌網(wǎng)站設(shè)計、服務(wù)器托管、定制網(wǎng)站、App設(shè)計、App開發(fā)

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源：創(chuàng)新互聯(lián)

猜你還喜歡下面的內(nèi)容

欧美一区二区三区老妇人-欧美做爰猛烈大尺度电-99久久夜色精品国产亚洲a-亚洲福利视频一区二区

【Mysql】Mysql從庫每隔一段時間就重啟