show slave status\G; *******************..."/>
溫馨提示×

溫馨提示×

您好，登錄后才能下訂單哦！

密碼登錄×
登錄注冊×
其他方式登錄
點擊 登錄注冊 即表示同意《億速云用戶服務(wù)條款》

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

發(fā)布時間：2020-08-11 13:59:01 來源：ITPUB博客 閱讀：265 作者：小亮520cl 欄目：MySQL數(shù)據(jù)庫
背景：HuaYun_Interface-SLAVE從庫每隔一段時間slave復(fù)制進(jìn)程便停掉，zabbix發(fā)送告警短信
  1. mysql> show slave status\G;
  2. *************************** 1. row ***************************
  3.                Slave_IO_State:
  4.                   Master_Host: *****
  5.                   Master_User: repl
  6.                   Master_Port: 3307
  7.                 Connect_Retry: 60
  8.               Master_Log_File: mysql-bin.000195
  9.           Read_Master_Log_Pos: 629275501
  10.                Relay_Log_File: mysql-relay-bin.000521
  11.                 Relay_Log_Pos: 625430128
  12.         Relay_Master_Log_File: mysql-bin.000195
  13.              Slave_IO_Running: No
  14.             Slave_SQL_Running: No


停掉時查看mysql錯誤日志我們發(fā)現(xiàn)端倪
  1. 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進(jìn)程自動重啟），所以復(fù)制進(jìn)程處于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)存報警通知
  1. 告警主機：_HuaYun_Interface-SLAVE
  2. 主機IP： ******
  3. 告警時間：2016.06.23 15:08:06
  4. 告警等級：Average
  5. 告警信息：Lack of available memory on server HuaYun_Interface-SLAVE
  6. 問題詳情：Available memory:163.15 MB
  7. 事件ID： 42590

登上主機檢查
  1. [root@NEW-APP-MYSQL-SLAVE ~]# dmesg 
  2. Out of memory: Kill process 32289 (mysqld) score 966 or sacrifice child
  3. 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)存吧
向AI問一下細(xì)節(jié)

免責(zé)聲明：本站發(fā)布的內(nèi)容（圖片、視頻和文字）以原創(chuàng)、轉(zhuǎn)載和分享為主，文章觀點不代表本網(wǎng)站立場，如果涉及侵權(quán)請聯(lián)系站長郵箱：is@yisu.com進(jìn)行舉報，并提供相關(guān)證據(jù)，一經(jīng)查實，將立刻刪除涉嫌侵權(quán)內(nèi)容。

AI
助
手