List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:August 18 2003 6:01pm
Subject:Re: Table locking...
View as plain text  
In the last episode (Aug 18), jkelty@stripped said:
> I just have a question about the table locking in 3.23.56. If I am
> inserting a row into a table that is MyISAM type, is the entire table
> locked? And, if so, what does this mean for concurrent selects?

Inserting a row into a full table does not lock the table.  Inserting a
row into a table that has had rows deleted from it will lock the table
if MySQL decides to use one of the free spaces.

	Dan Nelson
Table locking...jkelty18 Aug
  • RE: Table locking...Dathan Vance Pattishall18 Aug
  • Re: Table locking...Dan Nelson18 Aug
  • Re: Table locking...Jeremy Zawodny18 Aug
    • Re: Table locking...jkelty18 Aug
      • Re: Table locking...Jeremy Zawodny18 Aug