如何提高MySQL的INSERT和UPDATE性能? [英] How to improve MySQL INSERT and UPDATE performance?

问题描述

数据库中INSERT和UPDATE语句的性能似乎正在下降，并导致Web应用程序的性能下降.

Performance of INSERT and UPDATE statements in our database seems to be degrading and causing poor performance in our web app.

表是InnoDB，应用程序使用事务.我可以做些简单的调整来加快速度吗?

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?

推荐答案

• 您可以更改设置加快InnoDB的插入速度.
• 和更多加速方法 InnoDB
• ...以及另一项优化文章
• You could change the settings to speed InnoDB inserts up.
• And even more ways to speed up InnoDB
• ...and one more optimization article

这篇关于如何提高MySQL的INSERT和UPDATE性能?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！