In MySql, is it possible to lock tables only with SELECT?

Question

Is it possible that using only queries in my code (and not using select lock), I still get tables locked for some time due to the way MySQL performs processing?

(for example, MySQL may block when ordering a table or something like that)

Is it possible to choose or choose, just not block?

Answer 1

Is it possible that using only queries in my code (and not using select lock), I still get tables locked for some time due to the way MySQL performs processing?

Internal locking is not performed for simultaneous requests SELECT.

SELECTs , , - , (- I/O) ..

, , MySQL.