mysql insert and buffers, is this possible

Posted by Grumpy on Stack Overflow See other posts from Stack Overflow or by Grumpy
Published on 2010-04-02T09:17:52Z Indexed on 2010/04/02 9:23 UTC
Read the original article Hit count: 232

Filed under:
|
|
|

how is this possible

first i do insert into table2 select * from table1 where table1.id=1 ( 50k records should be moved 6 indexes has to be updated )

second delete from table1 where id=1 ( 50k records are removed )

How is it possible that only 45k of records are moved?

Im scratching my head over this and cant find a right answer Is it possible that the insert is still active and delete already started

© Stack Overflow or respective owner

Related posts about php

Related posts about mysql