XETOWN

물어보기

조회 수 69 댓글 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
    이게팩트

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