Check whether a row or range of rows is locked in a table for MySql database?

Question

From java using MySql database, how can check whether a row or range of rows is locked in a table ?

You mean a check if table is locked? – drgPP Sep 11 '15 at 07:18 — drgPP, Sep 11 '15 at 07:18

score 2 · Answer 1 · answered Sep 11 '15 at 07:20

If you want to check if a table is locked then you can try like this:

SHOW OPEN TABLES

but you cannot check if a range of rows is locked.

You can also make it specific for a particular table like this:

SHOW OPEN TABLES WHERE `Table` LIKE '[YOURTABLENAME]' 
AND `Database` LIKE '[YOURDATABASENAME]' AND In_use > 0;

As per my opinion when a table is locked then the rows are locked automatically.

score -1 · Answer 2 · answered Sep 11 '15 at 07:20

-1

MySQL uses only table-level locking. If you want row level locking capabilities, switch to InnoDB(A suggestion not a must).

answered Sep 11 '15 at 07:20

diyoda_

1

`InnoDB` is a database engine used by `MySQL`, so your answer isn't exactly correct. – Kayaman Sep 11 '15 at 07:35
@Kayaman You are correct, I should add somewhere to the answer about the MyISAM Storage Engine. But obviously the user seems to be using InnoDB engine. – diyoda_ Sep 11 '15 at 07:39

2 Answers2