MySQL Blocking/locking operation

Question

I read a lot about locking databases, tables and rows but i want lower lock, like lock only 'operation' i don't know how to call it, lets say i have function in php:

function update_table()
{
    //querys like SELECT, UPDATE INSERT etc.
}

Now, i want to only one person can use this function at the same time, and other will need to wait until the first one finish

But it is possible to lock not table/row but only this function, so others queries with SELECT etc. can be executed with no problem? or maybe better is just lock the table? (problem is that this table is very important and i don't want to lock it because some other users can visit the site for other resons/other pages and if many people will wait in line for this code above, other visitors also will have to wait even that they have no interests in site with code above)

Maxim Krizhanovsky · Accepted Answer · 2013-11-15 13:49:10Z

2

Yes. You can use GET_LOCK and RELEASE_LOCK mysql functions

answered Nov 15, 2013 at 13:49

Maxim Krizhanovsky

26.8k5 gold badges62 silver badges91 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Mr-Auto Over a year ago

But to be clear, GET_LOCK blocks only other GET_LOCK queries with the same name right?

Maxim Krizhanovsky Over a year ago

Sure. But you want to lock whatever happens in your function, not to block any specific query, right :)

Collectives™ on Stack Overflow

MySQL Blocking/locking operation

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related