Not the answer you need?
Register and ask your own question!

pre-commit stage

filaretfilaret EntrantCurrent User Role Beginner
There is a problem concerning large ALTER or for example adding the index - the whole database comes to pre-commit stage and until the request is executed it will remain in this stage. This means that all other databases which are on the same server can not process requests and are waiting for that request to be executed. Is there any parameter that would allow us not to block the database to which the request does not apply?
I.E. In Db1 ALTER is processed while DB2 can normally handle requests and is not waiting in queue.


Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.