I have a table where every user can edit JUST ITS rows but it happens that if some of them update one of its rows and another do a select then the table gets locked. I'm working with ver 2.23.49 is and PHP is there a way to solve this?
Will Innodb lock just the row being updated.
I've read the manual entry for innodb but it's not that clear.
Thanks!
