조회 수 76 댓글 3

사이트에서 too many connections 에러가 떠서 my.cnf 에서

1024까지 늘리고 mysql을 재시작 명령을 내렸고

 

Checking for corrupt, not cleanly closed and upgrade needing tables.

이런 얘기가 나왔고 로그는 아래와 같습니다.

 

별 신경 안 써도 되는 로그인지요???

 

ubuntu@serv.name:~$ sudo service mysql restart
 * Stopping MariaDB database server mysqld                               [ OK ]
 * Starting MariaDB database server mysqld                               [ OK ]
 * Checking for corrupt, not cleanly closed and upgrade needing tables.
ubuntu@serv.name:~$ ^C
ubuntu@serv.name:~$ grep mysql /var/log/syslog | less
Nov 21 08:39:58 serv.name mysqld: 2016-11-21  8:39:58 140177073531648 [Note] InnoDB: Online DDL : Start
Nov 21 08:39:58 serv.name mysqld: 2016-11-21  8:39:58 140177073531648 [Note] InnoDB: Online DDL : Start reading clustered index of the table and create temporary files
Nov 21 08:39:58 serv.name mysqld: 2016-11-21  8:39:58 140177073531648 [Note] InnoDB: Online DDL : End of reading clustered index of the table and create temporary files
Nov 21 08:39:58 serv.name mysqld: 2016-11-21  8:39:58 140177073531648 [Note] InnoDB: Online DDL : Start merge-sorting index `PRIMARY` (1 / 3), estimated cost : 10.0000
Nov 21 08:39:58 serv.name mysqld: 2016-11-21  8:39:58 140177073531648 [Note] InnoDB: Online DDL : End of  merge-sorting index `PRIMARY` (1 / 3)
Nov 21 08:39:58 serv.name mysqld: 2016-11-21  8:39:58 140177073531648 [Note] InnoDB: Online DDL : Start building index `PRIMARY` (1 / 3), estimated cost : 15.0000
Nov 21 08:39:58 serv.name mysqld: 2016-11-21  8:39:58 140177073531648 [Note] InnoDB: Online DDL : End of building index `PRIMARY` (1 / 3)
Nov 21 08:39:58 serv.name mysqld: 2016-11-21  8:39:58 140177073531648 [Note] InnoDB: Online DDL : Completed
Nov 21 08:39:58 serv.name mysqld: 2016-11-21  8:39:58 140177073531648 [Note] InnoDB: Online DDL : Start merge-sorting index `index1` (2 / 3), estimated cost : 10.0000
Nov 21 08:39:58 serv.name mysqld: 2016-11-21  8:39:58 140177073531648 [Note] InnoDB: Online DDL : End of  merge-sorting index `index1` (2 / 3)
Nov 21 08:39:58 serv.name mysqld: 2016-11-21  8:39:58 140177073531648 [Note] InnoDB: Online DDL : Start building index `index1` (2 / 3), estimated cost : 15.0000
Nov 21 08:39:58 serv.name mysqld: 2016-11-21  8:39:58 140177073531648 [Note] InnoDB: Online DDL : End of building index `index1` (2 / 3)
Nov 21 08:39:58 serv.name mysqld: 2016-11-21  8:39:58 140177073531648 [Note] InnoDB: Online DDL : Completed
Nov 21 08:39:58 serv.name mysqld: 2016-11-21  8:39:58 140177073531648 [Note] InnoDB: Online DDL : Start merge-sorting index `index2` (3 / 3), estimated cost : 10.0000
Nov 21 08:39:58 serv.name mysqld: 2016-11-21  8:39:58 140177073531648 [Note] InnoDB: Online DDL : End of  merge-sorting index `index2` (3 / 3)
Nov 21 08:39:58 serv.name mysqld: 2016-11-21  8:39:58 140177073531648 [Note] InnoDB: Online DDL : Start building index `index2` (3 / 3), estimated cost : 15.0000
Nov 21 08:39:58 serv.name mysqld: 2016-11-21  8:39:58 140177073531648 [Note] InnoDB: Online DDL : End of building index `index2` (3 / 3)

 

  • ?
    투데이 2016.11.21 20:52:32

    문제가 아닙니다.
    리스타트할때 mysql연결이 깨끗하게 종료 안되었다면서 복구하는 과정인데
    손상없이 잘 복구된것으로 보입니다.

  • profile
    기진곰 2016.11.21 21:39:31

    재시작할 때마다 나오는 메시지이므로 신경쓰지 않으셔도 됩니다.

    정말로 오류가 있다면 저 밑에 손상된 테이블 목록이 쫙 나오거나 아예 OK가 안 나옵니다.

  • ?
    투데이 2016.11.21 22:14:12
    이게팩트

서버에 요청 중입니다. 잠시만 기다려 주십시오...