开发者

Are there any mysql storage engines with row locking, and fulltext?

Im using fulltext for searches on my site, but there are a lo开发者_如何学Pythont 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?


With MySQL 5.6 it's now possible to have fulltext indexes on tables with InnoDB engine.

Read more about it here.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜