RE: Make delete requests without impact on a database

[David Florella]

Hi evryone, 

Thank you for the advice. I will analyze the differences between InnoDB and
MyISAM before switching. 

Moreover, there is a lot of indexes on the tables. I was thinking about
tunning the MySQL server. Do you know how can I benchmark the tunning of the
server before doing the tunning?

Regards, 

David. 

-----Message d'origine-----
De : pharkins@stripped [mailto:pharkins@stripped] De la part de Perrin
Harkins
Envoyé : jeudi 15 avril 2010 02:36
À : Dan Nelson
Cc : David Florella; mysql@stripped
Objet : Re: Make delete requests without impact on a database

On Wed, Apr 14, 2010 at 10:22 AM, Dan Nelson <dnelson@stripped>
wrote:
> Switch to InnoDB :)

Seconded.  No need to complicate your life with MyISAM workarounds
when InnoDB solves this problem already.

- Perrin