The Shutdown Process

• The MySQL server performs the following steps as it shuts down.
  • The shutdown process is initiated.
    • It receives a SIGTERM signal.
  • The server creates a shutdown thread if necessary.
    • If shutdown was requested by a client, a shutdown thread is created.
    • If shutdown is the result of receiving a SIGTERM signal, the signal thread might handle shutdown itself, or it might create a separate thread.
  • The server stops accepting new connections.
    • It closes network connections.
  • The server terminates current activity.
    • For each thread that is associated with a client connection, the connection to the client is broken and the thread is marked as killed. Threads die when they notice that they are so marked.
    • For threads that have an open transaction, the transaction is rolled back.
  • Storage engines are shut down or closed.
    • The table cache is flushed and all open tables are closed.
  • The server exits.

Is server-side help installed?

---

---

© 2007 John Michael Pierobon

Notes