sql update - How to get number of locks acquired by my `MySQL` Query? -


how number of locks acquired mysql update query?

example query : update employees set store_id = 0 store_id = 1;

finally, able number of locks acquired following set of mysql statements.

begin; update employees set store_id = 0 store_id = 1; show engine innodb status\g commit; 

edit :

we can lock details using following query current transaction.

select * information_schema.innodb_locks; 

Comments

Popular posts from this blog

c++ - Difference between pre and post decrement in recursive function argument -

php - Nothing but 'run(); ' when browsing to my local project, how do I fix this? -

php - How can I echo out this array? -