Q&A

mysql restart 에러 문의드립니다.

렙흥아
2016.11.21 11:43
722
0
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)

 

 
목록

댓글 3

  • 개인정보삭제
    2016.11.21 11:52 #428593

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

    추천 0
  • 기진곰
    2016.11.21 12:39 #428642

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

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

    추천 0
  • 개인정보삭제
    2016.11.21 13:14 #428688
    이게팩트
    추천 0
1 2 3 4 5