开发者

Select query Locks the table, why does this happen

I have a MyISAM table as I work with MATCH AGAINST and I have a select query which locks the entire table. Why does it happen?

开发者_开发百科

Here is some output:

Select query Locks the table, why does this happen


I believe this question, Any way to select without causing locking in MySQL? may help you out. It appears to be locking because it's a MyISAM table.


MyISAM is "table level locking", meaning that the table can handle only one query at the time. So, as @Drazisil told, you have few options: optimize your query to reduce locking problem - stop using MySQL plain text feature (which is very poor performance) - split your big query into smaller queries - improve your indexes OR switch to innodb which is "row level locking"

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜