What happens to a or update command on a mysql locked table?
up vote
-1
down vote
favorite
I pretty much have my code, what I want to do is make sure is that I can rely on the results to be universal.
Script A
lock tables mytable write;
...do some reading....
...do some writing....
unlock tables;
Script B
lock tables mytable write;
...do some writing....
unlock tables;
The above works, and whichever table does not have the lock simply hangs until the other releases the lock.
I am totally fine with this outcome/behavior. I just want to make sure that I'll always get a hang, and not some sort of error, or even a time-out error.
Hope this question makes sense.
thanks
mysql
asked Nov 21 at 18:35
Sergio D. Caplan
176110
add a comment |
up vote
-1
down vote
favorite
I pretty much have my code, what I want to do is make sure is that I can rely on the results to be universal.
Script A
lock tables mytable write;
...do some reading....
...do some writing....
unlock tables;
Script B
lock tables mytable write;
...do some writing....
unlock tables;
The above works, and whichever table does not have the lock simply hangs until the other releases the lock.
I am totally fine with this outcome/behavior. I just want to make sure that I'll always get a hang, and not some sort of error, or even a time-out error.
Hope this question makes sense.
thanks
mysql
asked Nov 21 at 18:35
Sergio D. Caplan
176110
to avoid timeout error, you can increase the value ofwait_timeoutvariable. Refer: dev.mysql.com/doc/refman/8.0/en/…
– Madhur Bhaiya
Nov 21 at 18:37
Also, it is always good to enable mysqli_error_reporting (if using php/mysqli), and usetry .. catchblock to catch any sort of error, and eventually tune the system variables to handle them in future. Personally, it is hard to predict what all errors might appear. You will handle them as you encounter them, as long as you have proper error reporting/logging mechanism
– Madhur Bhaiya
Nov 21 at 18:40
add a comment |
up vote
-1
down vote
favorite
up vote
-1
down vote
favorite
I pretty much have my code, what I want to do is make sure is that I can rely on the results to be universal.
Script A
lock tables mytable write;
...do some reading....
...do some writing....
unlock tables;
Script B
lock tables mytable write;
...do some writing....
unlock tables;
The above works, and whichever table does not have the lock simply hangs until the other releases the lock.
I am totally fine with this outcome/behavior. I just want to make sure that I'll always get a hang, and not some sort of error, or even a time-out error.
Hope this question makes sense.
thanks
mysql
asked Nov 21 at 18:35
Sergio D. Caplan
176110
I pretty much have my code, what I want to do is make sure is that I can rely on the results to be universal.
Script A
lock tables mytable write;
...do some reading....
...do some writing....
unlock tables;
Script B
lock tables mytable write;
...do some writing....
unlock tables;
The above works, and whichever table does not have the lock simply hangs until the other releases the lock.
I am totally fine with this outcome/behavior. I just want to make sure that I'll always get a hang, and not some sort of error, or even a time-out error.
Hope this question makes sense.
thanks
mysql
mysql
asked Nov 21 at 18:35
Sergio D. Caplan
176110
asked Nov 21 at 18:35
Sergio D. Caplan
176110
asked Nov 21 at 18:35
Sergio D. Caplan
176110
asked Nov 21 at 18:35
Sergio D. Caplan
176110
asked Nov 21 at 18:35
Sergio D. Caplan
176110
176110
to avoid timeout error, you can increase the value ofwait_timeoutvariable. Refer: dev.mysql.com/doc/refman/8.0/en/…
– Madhur Bhaiya
Nov 21 at 18:37
Also, it is always good to enable mysqli_error_reporting (if using php/mysqli), and usetry .. catchblock to catch any sort of error, and eventually tune the system variables to handle them in future. Personally, it is hard to predict what all errors might appear. You will handle them as you encounter them, as long as you have proper error reporting/logging mechanism
– Madhur Bhaiya
Nov 21 at 18:40
add a comment |
to avoid timeout error, you can increase the value ofwait_timeoutvariable. Refer: dev.mysql.com/doc/refman/8.0/en/…
– Madhur Bhaiya
Nov 21 at 18:37
Also, it is always good to enable mysqli_error_reporting (if using php/mysqli), and usetry .. catchblock to catch any sort of error, and eventually tune the system variables to handle them in future. Personally, it is hard to predict what all errors might appear. You will handle them as you encounter them, as long as you have proper error reporting/logging mechanism
– Madhur Bhaiya
Nov 21 at 18:40
to avoid timeout error, you can increase the value of
wait_timeout variable. Refer: dev.mysql.com/doc/refman/8.0/en/…– Madhur Bhaiya
Nov 21 at 18:37
to avoid timeout error, you can increase the value of
wait_timeout variable. Refer: dev.mysql.com/doc/refman/8.0/en/…– Madhur Bhaiya
Nov 21 at 18:37
Also, it is always good to enable mysqli_error_reporting (if using php/mysqli), and use
try .. catch block to catch any sort of error, and eventually tune the system variables to handle them in future. Personally, it is hard to predict what all errors might appear. You will handle them as you encounter them, as long as you have proper error reporting/logging mechanism– Madhur Bhaiya
Nov 21 at 18:40
Also, it is always good to enable mysqli_error_reporting (if using php/mysqli), and use
try .. catch block to catch any sort of error, and eventually tune the system variables to handle them in future. Personally, it is hard to predict what all errors might appear. You will handle them as you encounter them, as long as you have proper error reporting/logging mechanism– Madhur Bhaiya
Nov 21 at 18:40
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53418541%2fwhat-happens-to-a-or-update-command-on-a-mysql-locked-table%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
to avoid timeout error, you can increase the value of
wait_timeoutvariable. Refer: dev.mysql.com/doc/refman/8.0/en/…– Madhur Bhaiya
Nov 21 at 18:37
Also, it is always good to enable mysqli_error_reporting (if using php/mysqli), and use
try .. catchblock to catch any sort of error, and eventually tune the system variables to handle them in future. Personally, it is hard to predict what all errors might appear. You will handle them as you encounter them, as long as you have proper error reporting/logging mechanism– Madhur Bhaiya
Nov 21 at 18:40