Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> BAUMEISTER Alexandre writes:
>> Bonjour,
>>
>> With 3.22 I used to do some queries like "DELETE FROM TABLE". And
>> this was very rapid as Mysql only deletes and re-create the files.
>>
>> I knew that DELETE w
Alex,
DELETE FROM yourtable
now deletes individually each row when InnoDB is enabled,
also for MyISAM tables. For InnoDB the reason is that a
consistent read may come to read the table: dropping the
table and recreating it is not acceptable if we want a
consistent read to the table. I think Mont
BAUMEISTER Alexandre writes:
> Bonjour,
>
> With 3.22 I used to do some queries like "DELETE FROM TABLE". And
> this was very rapid as Mysql only deletes and re-create the files.
>
> I knew that DELETE was very long with InnoDB because it has to
> clear all the table space used
Bonjour,
With 3.22 I used to do some queries like "DELETE FROM TABLE". And
this was very rapid as Mysql only deletes and re-create the files.
I knew that DELETE was very long with InnoDB because it has to
clear all the table space used by the table from which you DELETE.
But
