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 was very long with
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
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 by the
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