cuonghuynh
10/18/2018 - 1:55 PM

Study case: "InnoDB: Database was not shutdown normally! "

Study case: "InnoDB: Database was not shutdown normally! "

The out-of-memory killer would choose mysql to close down, because it was (usually) the biggest memory user in the system.

The command to sort down processes by memory usage:

ps aux --sort -rss | head -n15

Solution:

  • Try upgrade new version
  • Turn off optimize performance schema, edit /etc/mysql/my/cnf
[mysqld]
performance_schema=0