MySQL

Adjust Respawn Limit to auto restart MYSQL when crashed Ubuntu

By June 19, 2017No Comments

This is for Ubuntu 9.10 until 14.10

  1. Check your mysql init configuration file at /etc/init/mysql.conf
  2. Change the respawn limit value according to your need. For my cases, I will use

respawn limit 50 30

Reference From Upstart Documentation

Syntax:

respawn limit COUNT INTERVAL | unlimited

Example:

# respawn the job up to 10 times within a 5 second period.
# If the job exceeds these values, it will be stopped and
# marked as failed.
respawn
respawn limit 10 5

# respawn the job indefinitely
respawn limit unlimited

For more detail about the documentation, kindly visit http://upstart.ubuntu.com/cookbook/#respawn-limit

Leave a Reply