Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
Description
Studying various sources point to the fact that:
INSERT INTO ... SELECT ... and
CREATE TABLE ... AS SELECT
causes lockings on (InnoDB) tables...
https://dba.stackexchange.com/questions/300543/mysql-mariadb-can-a-select-query-block-an-insert-query
https://www.percona.com/blog/2006/07/12/insert-into-select-performance-with-innodb-tables/
http://harrison-fisk.blogspot.com/2009/02/my-favorite-new-feature-of-mysql-51.html
https://mysql.wisborg.dk/2021/07/31/locking-select-with-create-table-insert-into-and-user-variables/
https://dev.mysql.com/doc/refman/8.0/en/innodb-locks-set.html
it would be good IMHO if this is somehow indicated on the following pages:
https://mariadb.com/kb/en/insert-select/
https://mariadb.com/kb/en/create-table/
Attachments
Issue Links
- relates to
-
MDEV-24813 Locking full table scan fails to use table-level locking
- In Review