I have menus, categories and products tables. I am using mysql 5.5, All tables are innoDB and in all cases id is the primary key (int) with autoincrement.
menus table
id, name, status
categories table
id, menu_id, name
products table
…
Query:
SELECT COUNT(online.account_id) cnt from online;
But online table is also modified by an event, so frequently I can see lock by running show processlist.
Is there any grammar in MySQL that can make select statement not …
Is there a way to detect locked tables in MySQL? I mean tables locked by the LOCK TABLE table WRITE/READ command.
(Note that readers interested in detecting named locks acquired with GET_LOCK should read Show all current locks …