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:
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"
精彩评论