Table Row Locking
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 :)
Subject
Written By
Posted
Table Row Locking
January 11, 2012 03:27PM
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.