사이트에서 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
문제가 아닙니다.
리스타트할때 mysql연결이 깨끗하게 종료 안되었다면서 복구하는 과정인데
손상없이 잘 복구된것으로 보입니다.
재시작할 때마다 나오는 메시지이므로 신경쓰지 않으셔도 됩니다.
정말로 오류가 있다면 저 밑에 손상된 테이블 목록이 쫙 나오거나 아예 OK가 안 나옵니다.