[MDEV-30368] Locking behaviour is missing in documentation Created: 2023-01-09 Updated: 2023-12-13 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Data Definition - Create Table, Data Manipulation - Insert, Documentation, Server, Storage Engine - InnoDB |
| Fix Version/s: | None |
| Type: | Task | Priority: | Major |
| Reporter: | Oli Sennhauser | Assignee: | Ian Gilfillan |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | documentation | ||
| Issue Links: |
|
||||||||||||
| Description |
|
Studying various sources point to the fact that: https://dba.stackexchange.com/questions/300543/mysql-mariadb-can-a-select-query-block-an-insert-query it would be good IMHO if this is somehow indicated on the following pages: https://mariadb.com/kb/en/insert-select/ |
| Comments |
| Comment by Marko Mäkelä [ 2023-01-09 ] |
|
To my understanding, there is no way to tell the SELECT part to suppress any locking. Copying a large table in this way could cause InnoDB to run out of the buffer pool until MDEV-24813 has been fixed. |