MNAndrewwmiksoftА зачем вы трогаете TRANSACTION ISOLATION LEVEL ?


Вот в этом треде ( http://stackoverflow.com/questions/917640/any-way-to-select-without-causing-locking-in-mysql ) я прочитал, что это поможет избавиться от лока.

miksoftБез этого пробовали?


Да. Лочит. Вот кусочек отсюда ( http://dev.mysql.com/doc/refman/5.7/en/table-locking.html ) -

A SELECT statement that takes a long time to run prevents other sessions from updating the table in the meantime, making the other sessions appear slow or unresponsive. While a session is waiting to get exclusive access to the table for updates, other sessions that issue SELECT statements will queue up behind it, reducing concurrency even for read-only sessions.

When choosing whether to create a table using InnoDB or a different storage engine, keep in mind the following disadvantages of table locking:

авторWhen choosing whether to create a table using InnoDB or a different storage engine, keep in mind the following disadvantages of table locking:

....................

A SELECT statement that takes a long time to run prevents other sessions from updating the table in the meantime, making the other sessions appear slow or unresponsive. While a session is waiting to get exclusive access to the table for updates, other sessions that issue SELECT statements will queue up behind it, reducing concurrency even for read-only sessions.