Home / server / Questions / 911258
Accepted
Kirrus
Asked: 2018-05-09 03:54:57 +0800 CST

When MySQL/MariaDB is starting, if it has to repair innoDB tables, what happens to queries sent it's way before it's up?

  • 772

I'm curious. Are they queued, lost, stuck in php connect_timeout till MySQL/MariaDB comes up?

mysql

1 Answers

  1. Best Answer

    Based on this article, if you are using the default InnoDB recovery mode, any crash recovery that is done is performed in the background once connections are accepted. The MySQL manual page explains this in more detail.

    I believe in practice this means that if the server accepts connections, transactions will work normally.

    • 1