Does Myisam put a table lock on the table even when dealing with a "select" query?

I read a book High Performance MySQL, she mentions:

performing one query per table uses table locks more efficiently: the queries 
will lock the tables invididually and relatively briefly, instead of locking 
them all for a longer time.

MyISAM puts a table lock, even when selectingsomething? can someone explain a little?

+3
source share
2 answers

MyISAM . SELECT READ LOCK . , WRITE LOCKS. , , . INSERT, UPDATE, DELETE ALTER TABLE WRITE LOCK . , ; , MyISAM , , .

, , ( ) , .

, :

  • ( )
  • ( )

. http://dev.mysql.com/doc/refman/5.5/en/internal-locking.html

+11

reko_t , :

.

  • .
  • , . , , , ().
    • :
    • " " - ""
    • ( , )
  • MyISAM. , . , , ( ).

, MyISAM concurrency. , , . MySQL/Oracle ( , - ).

"" SELECT, - , , . .

+1

All Articles