Geek Answers Handbook

Query selection Lock table why this happens

I have a MyISAM table when I work with MATCH AGAINST, and I have a select query that locks the entire table. Why is this happening?

Here are some results:

enter image description here

+4
source share
2 answers

I believe in this question, Any way to choose without locking in MySQL? can help you. It seems to block because it is a MyISAM table.

+2
source

MyISAM is a “table-level lock”, which means that a table can only process one request at a time. So, as @Drazisil said, you have several options: optimize your query to reduce the lock problem - stop using the plain text function MySQL (which is very poor performance) - split your large query into smaller queries - improve your indexes OR switch to innodb which is "row level locking"

+1
source

More articles:


All Articles