CODEWITHSUNDEEP
phpmysqlperformancejoin
Pentium10
Pentium10

Reputation: 207982

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:

enter image description here

Upvotes: 4

Views: 284

Answers (2)

benfromaix
benfromaix

Reputation: 105

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"

Upvotes: 1

Drazisil
Drazisil

Reputation: 3363

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.

Upvotes: 2

Related Questions