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

   조회 3455   추천 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 1081/5708
2015-12   1675078   백메가
2014-05   5140458   정은준1
2017-03   3318   김제연
2017-06   3318   Super64
2017-03   3318   비오는날우산
2016-10   3318   행아범
2018-12   3318   arcane
2019-08   3318   구십평
2019-05   3318   굴렁쇠
2017-04   3318   창원자게이
2021-04   3318   pdahn
2017-05   3318   신은왜
2019-09   3319   배가나왔어
2019-01   3319   노랑두꺼비
2021-02   3319   안형곤
2018-12   3319   전진
2019-01   3319   online9
2021-02   3319   안형곤
2017-05   3319   밤기차
2014-03   3319   바램쓰
2021-11   3319   종소리
2015-06   3319   회원K