Re: How to get status of locked rows in innodb.

[nrazzaq]

Thank you very much Harrison Fisk. It helped a lot. But time out problem is still there.


I am using mysql in embedded mode. I have not installed the mysql. I did not know how to set innodb_lock_wait_timeout in embedded mode. It does not work as SET innodb_lock_wait_timeout = 0;

If one user has logged in then second user would not able to login with same ID . I was trying to do this by locking. As one user logged in, it will locked that particular row. So second person with same Id will not able to login. But it did not work. As second user still able to read locked row and lock the locked rows. In short, can we make Locked rows NOT READABLE.

Can you help.

Regards.