사이트에서 too many connections 에러가 떠서 my.cnf 에서
1024까지 늘리고 mysql을 재시작 명령을 내렸고
Checking for corrupt, not cleanly closed and upgrade needing tables.
이런 얘기가 나왔고 로그는 아래와 같습니다.
별 신경 안 써도 되는 로그인지요???
[email protected]:~$ 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. [email protected]:~$ ^C [email protected]:~$ 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)
문제가 아닙니다.
리스타트할때 mysql연결이 깨끗하게 종료 안되었다면서 복구하는 과정인데
손상없이 잘 복구된것으로 보입니다.