MySQL Forums
Forum List  »  Newbie

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

Written By
Table Row Locking
January 11, 2012 03:27PM
January 11, 2012 04:44PM
January 11, 2012 05:08PM
January 13, 2012 09:53AM

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.