CODEWITHSUNDEEP
mysql
AlfaTeK
AlfaTeK

Reputation: 7765

In MySql is it possible to have tables locked with only SELECTs?

Is it possible that, using only query statements in my code (and not using select lock) I still get tables locked for some time because of the way MySQL does the processing?

(for example, MySQL can lock while ordering the table, or something like that)

Is this possible or selects just don't lock?

Upvotes: 3

Views: 109

Answers (1)

Quassnoi
Quassnoi

Reputation: 425251

Is it possible that, using only query statements in my code (and not using select lock) I still get tables locked for some time because of the way MySQL does the processing?

No internal locking is performed for concurrent SELECT queries.

With lots of concurrent SELECTs, you, however, may observe natural performance degradation due to more frequent cache misses, increased disk response time (because of queued I/O requests) etc.

This, however, has nothing to do with MySQL locking mechanisms.

Upvotes: 1

Related Questions