MariaDB: can a SELECT query block other queries?

All we need is an easy explanation of the problem, so here it is.

If I used a stored procedure having only Select queries in mariadb (NO Update OR Insert). Does this Select locks other queries (Select, Update or Insert) using the same tables?

How to solve :

I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.

Method 1

What storage engine is used ?

InnoDB

If I used a stored procedure having only Select queries in mariadb (NO
Update OR Insert). Does this Select locks other queries (Select,
Update or Insert) using the same tables?

Simple answer, No.

The SELECT query which doesn’t affect data changes will not lock the table.

With data change I mean INSERT INTO SELECT which is not your case.

Method 2

ALTER and other DDL statements may block anything, including SELECT.

Ordinary DML statements never "lock the table" in InnoDB, but may lock rows in such a way as to make you think the table is locked.

Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply