List:General Discussion« Previous MessageNext Message »
From:BAUMEISTER Alexandre Date:December 11 1999 4:14pm
Subject:Re[2]: do an INSERT at the same time as other threads are reading from the table
View as plain text  
Bonjour sinisa,

  Will something equivalent in order to allow a table not to be lock
  while UPDATE and LOAD DATA be implemented in a near version of Mysql
  or MyISAM ?

  Regards,
  Alex.

smc> Benjamin Pflugmann writes:
smc>  > Hi.
smc>  > 
smc>  > On Fri, Dec 10, 1999 at 10:03:00AM +0100, alex@stripped wrote:
smc>  > > Bonjour,
smc>  > > 
smc>  > >   From the documentation, about 3.23.7 :
smc>  > > 
smc>  > >   "In MyISAM one can now do an INSERT at the same time as other
smc>  > >   threads are reading from the table."
smc>  > > 
smc>  > >   Does this mean that we are no far from real "Dirty read" possibility
smc>  > >   with Mysql ?
smc>  > 
smc>  > Depends on what you mean with "dirty read".
smc>  > 
smc>  > >   Dose it work with UPDATE ?
smc>  > 
smc>  > No, AFAIK.
smc>  > 
smc>  > >   Dose it work with LOAD DATA INFILE ?
smc>  > 
smc>  > Depends if LOAD DATA INFILE is internally implemented the same way as
smc>  > INSERT or not.
smc>  > 
smc>  > IIRC, the way concurrent INSERT are implemented is that the SELECTs
smc>  > ignore any records which were appended to the table since the SELECT
smc>  > started. This obviously does not work for UPDATEs (which modify
smc>  > existing records) and shouldn't be expected to work for anything else
smc>  > than INSERTs (DELETE, LOAD, ...).
smc>  > 
smc>  > In short: I think Monty wouldn't have written "INSERT", if it works
smc>  > for "UPDATE" and other stuff, too.
smc>  > 
smc>  > Monty & Co. can give you a more precise answer if you need one.
smc>  > 
smc>  > Bye,
smc>  > 
smc>  >         Benjamin.
smc>  > 
smc>  > 
smc>  > 

smc> Hello Benjamin,

smc> No it does not work with UPDATE nor with LOAD DATA, although LOAD DATA 
smc> is inserting records.

smc> Sinisa


Thread
do an INSERT at the same time as other threads are reading from the tableBAUMEISTER Alexandre10 Dec
  • Re: do an INSERT at the same time as other threads are reading from the tableBenjamin Pflugmann10 Dec
    • Re: do an INSERT at the same time as other threads are reading from the tablesinisa11 Dec
      • Re[2]: do an INSERT at the same time as other threads are reading from the tableBAUMEISTER Alexandre11 Dec
        • Re: Re[2]: do an INSERT at the same time as other threads are reading from the tablesinisa11 Dec
      • Micycle?Esben Maal√łe13 Jan
      • Re: Micycle?Stephen Johnson13 Jan
      • Re: Micycle?Sasha Pachev13 Jan
        • Re: Micycle?Ondrej Sury13 Jan
          • RE: Micycle?Chris Abraham13 Jan
      • Re: Micycle?Stephen Johnson13 Jan
Re: Re[2]: do an INSERT at the same time as other threads arereading from the tableAndy12 Dec
  • Re: Re[2]: do an INSERT at the same time as other threads arereading from the tablesinisa12 Dec