List:General Discussion« Previous MessageNext Message »
From:David Florella Date:April 15 2010 8:02am
Subject:RE: Make delete requests without impact on a database
View as plain text  
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



Thread
Make delete requests without impact on a databaseDavid Florella14 Apr
  • Re: Make delete requests without impact on a databaseDan Nelson14 Apr
    • RE: Make delete requests without impact on a databaseDaevid Vincent15 Apr
    • Re: Make delete requests without impact on a databasePerrin Harkins15 Apr
      • RE: Make delete requests without impact on a databaseDavid Florella15 Apr
  • Re: Make delete requests without impact on a databasemos14 Apr
    • Re: Make delete requests without impact on a databaseCarsten Pedersen14 Apr
      • Re: Make delete requests without impact on a databasemos14 Apr
        • Re: Make delete requests without impact on a databaseCarsten Pedersen14 Apr