[해결]mysql 매분마다 자동시작되요.

   조회 3440   추천 0    

 

안녕하세요. 도움을 청합니다.

mysql이 1분간격으로 재시작이 됩니다. 

스케쥴이 되어있지도 않고, 시스템 오류가 있나해서 /var/log/message 확인해봐도 오류가 없네요.

뭐가 문제 일까요?

/etc/my.cnf 파일을 기본으로 변경해봐도 똑같아요.

mysql log 입니다.

---------------------------------------------------------

181203 11:03:34 [Note] Event Scheduler: Loaded 0 events

181203 11:03:34 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.

Version: '5.1.73-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

181203 11:04:35 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

181203 11:04:35 [Note] Event Scheduler: Purging the queue. 0 events

181203 11:04:37 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete


181203 11:04:37 mysqld_safe mysqld from pid file /usr/local/mysql/data/server.myserver.com.pid ended

181203 11:04:38 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data

181203 11:04:38 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.

181203 11:04:38 [Note] Event Scheduler: Loaded 0 events

181203 11:04:38 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.

Version: '5.1.73-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

181203 11:05:40 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown


181203 11:05:40 [Note] Event Scheduler: Purging the queue. 0 events

181203 11:05:40 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete


181203 11:05:40 mysqld_safe mysqld from pid file /usr/local/mysql/data/server.myserver.com.pid ended

181203 11:05:41 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data

181203 11:05:41 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.

181203 11:05:41 [Note] Event Scheduler: Loaded 0 events

181203 11:05:41 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.

Version: '5.1.73-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

181203 11:06:42 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown


181203 11:06:42 [Note] Event Scheduler: Purging the queue. 0 events

181203 11:06:42 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete


181203 11:06:42 mysqld_safe mysqld from pid file /usr/local/mysql/data/server.myserver.com.pid ended

181203 11:06:44 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data

181203 11:06:44 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.

181203 11:06:44 [Note] Event Scheduler: Loaded 0 events

181203 11:06:44 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.

Version: '5.1.73-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

181203 11:07:45 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown


반갑습니다.
짧은글 일수록 신중하게.
천마건빵 2021-08
monit 이란 데몬으로 mysql, httpd, sshd 를 체크하여 데몬이 죽으면 다시 시작하는 프로그램인데,
이프로그램의 오류인지 반복적으로 mysql이 재시작되는것을 찾아냈습니다.
monit 바로 삭제하였습니다.


QnA
제목Page 4619/5708
2015-12   1674492   백메가
2014-05   5139890   정은준1
2018-07   3336   김건우
2015-01   3335   DDAYs
2014-04   3335   니포
2023-02   3335   신은왜
2019-01   3335   nelson1945
2019-08   3335   블루영상
2020-08   3335   눈부신아침
2021-06   3335   르나풀스
2022-07   3335   군인1
2017-04   3335   슬러그
2017-10   3335   TLaJ3KtYGr
2018-06   3334   쌍cpu
2014-05   3334   황진우
2017-11   3334   NGC
2017-05   3334   두cpu
2018-11   3334   신은왜
2018-05   3334   느낌
2019-04   3334   1CPU지창훈
2018-11   3334   삐돌이슬픔이
2019-12   3334   자객