How to improve MySQL INSERT and UPDATE performance?

innodb, mysql, performance

Solution

- You could change the settings to speed InnoDB inserts up.

- And even more ways to speed up InnoDB

- ...and one more optimization article

Problem

Performance of INSERT and UPDATE statements in our database seems to be degrading and causing poor performance in our web app. Tables are InnoDB and the application uses transactions. Are there any easy tweaks that I can make to speed things up? I think we might be seeing some locking issues, how can I find out?

Original source