MySQL Forums :: Newbie :: Table Row Locking


Advanced Search

Table Row Locking
Posted by: Andrew Germishuys ()
Date: January 11, 2012 03:27PM

Good day all

I am currently working on a website project. This is developed in PHP, and using MySQL.

Wanted to check a few points. I've read up on several possibilities, but wanted to also check other's experiences.

Users will be storing large amounts of text into several columns per row.
Now, MyISAM supports fulltext search, and is very fast for a project that mainly reads.

However, those users will be able to edit the text in those fields. Although record editing will be restricted to certain users, a row could have more than one user authorised to edit it.

So, to prevent data corruption, I'd need to lock that row.
MyISAM does not support row locking

However InnoDB does.

losing the fulltext search capability, I can now get row locking.

Would this be the best course?
And, what suggestions would you have for locking a row on retrieving it for editing, and waiting an amount of time until it is either updated, or editing is cancelled?

Any caveats to this?

Thank you in advance, and kind regards :)

Options: ReplyQuote


Subject Written By Posted
Table Row Locking Andrew Germishuys 01/11/2012 03:27PM
Re: Table Row Locking Peter Brawley 01/11/2012 04:44PM
Re: Table Row Locking Andrew Germishuys 01/11/2012 05:08PM
Re: Table Row Locking Rick James 01/13/2012 09:53AM
Re: Table Row Locking [SOLVED] Andrew Germishuys 01/13/2012 11:38AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.