Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@cuonghuynh

cuonghuynh/readme.md

Last active October 20, 2018 02:20
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save cuonghuynh/f443325d6ca27755cde79d7b5aef7e87 to your computer and use it in GitHub Desktop.
Save cuonghuynh/f443325d6ca27755cde79d7b5aef7e87 to your computer and use it in GitHub Desktop.
Download ZIP
Study case: "InnoDB: Database was not shutdown normally! "
Raw
readme.md

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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment