Question about MySQL Locks

Question

2.00/5 (1 vote)

See more:

Hello,

MySQL documentation says that LOCK command locks tables for a "session". I am confused that what is session??? does it mean user???

I am making a software that uses MySQL for database. I have hard coded the user name and password for MySQL connection in the software i.e. all the instances of the software will be using same user name and password for MySQL connection purposes. for example if one user is running my software on computer A and other person is using software on computer B, user name and password will be same.

My question is, if user with computer A locks table2 in database (lock tables db.table2) then whether user with computer B will be able to access table2 or not (as user name and password are same). Further, if user A closes the connection before unlocking the table2 then whether table2 will remain locked or not???

Thanks

Muhammad Inaam Munir

Posted 14-Jun-13 9:52am

Member 9856173

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ron Beyer · Answer 1 · 2013-06-14T10:06:00

MySQL implements internal locks to guarantee consistency across applications and "sessions". A session isn't well defined in the documentation, but I would guess that a session is analogous to a connection, regardless of the username/password used.

I would evaluate why you need or think you need to implement locks specifically. MySQL is designed to be concurrently used by multiple applications, the only reason to use locks is if you need to synchronize data or updates between applications, otherwise both applications can CRUD a table concurrently and maintain consistency.

Read Pgs 1002 to 1008[^]