Im using fulltext for searches on my site, but there are a lot of updates being done to the table also, which contains 700,000 records. these updates are usually done via cron, by a script that runs every 10 minutes and commits changes from a temporary table where I simply INSERT all the changes for speed purposes, since updating the live table directly is a lot slower.
The table uses MyISAM, so when there are bursts of update queries being done, it overwhelms the server, and it starts lagging, since it locks the entire table for updates.
Are there any storage engines that both have row-level locking, and support FULLTEXT?