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
