List:MySQL on Win32« Previous MessageNext Message »
From:Paul DuBois Date:December 21 1999 4:28pm
Subject:RE: General Implementation Questions
View as plain text  
At 10:14 AM -0600 1999-12-21, Chris Means wrote:
>  > No, in any version of MySQL only one update can happen in one moment
>>  on one table. Almost like Newton ;O)
>
>OK.  One UPDATE (INSERT/DELETE ?) at a time...but can someone else be doing
>a SELECT at the same time?  I thought MySQL would use multiple CPUs if
>available, so that to me implied "more than one operation at the same
>time..."


An UPDATE involves a write lock, which locks out all other writers and
readers.  This includes SELECT operations.  Recent work allows INSERT
operations to be done during SELECT operations, but that does not yet
apply to UPDATE or DELETE.

-- 
Paul DuBois, paul@stripped
Thread
General Implementation QuestionsChris Means21 Dec
  • Re: General Implementation QuestionsSinisa Milivojevic21 Dec
    • RE: General Implementation QuestionsChris Means21 Dec
      • RE: General Implementation Questionssinisa21 Dec
        • RE: General Implementation QuestionsChris Means21 Dec
          • RE: General Implementation Questionssinisa21 Dec
            • RE: General Implementation QuestionsChris Means21 Dec
              • RE: General Implementation QuestionsPaul DuBois21 Dec
                • RE: General Implementation QuestionsChris Means21 Dec
              • RE: General Implementation Questionssinisa21 Dec
          • Re: General Implementation QuestionsSteve Ruby21 Dec
      • RE: General Implementation QuestionsHood Gardner21 Dec
        • RE: General Implementation QuestionsChris Means21 Dec
          • RE: General Implementation QuestionsHood Gardner21 Dec