MySQL InnoDB(插入)性能优化的方法? [英] How-to's for MySQL InnoDB (insert) performance optimization?
问题描述
我仍在努力使用InnoDB引擎来提高MySQL数据库的性能.尤其是数据插入的性能,次要的是运行查询的性能.
I'm still struggling with the performance of my MySQL database using the InnoDB engine. Especially the performance of data insertion, minor the performance of running queries.
我一直在搜寻信息,操作方法等,但是我发现大多数信息都相当重要.我可以在网上找到新手"的一些基本信息,这是性能优化的起点吗?首先,以最简单的方式说明了InnoDB优化的大多数导入步骤.
I've been googling for information, how-to's and so on, but I found most information rather profound matter. Can I find somewhere on the net some basic information for "newbies", a starting point for performance optimization? The first, most import steps for InnoDB optimization, explained in a less complicated way.
我正在使用Windows平台
I'm using the Windows platform
推荐答案
我曾经管理过几个非常大的MySQL数据库(例如1TB +).它们是巨大的,无情的野兽,食欲不竭,使我胃部不适.
I used to manage a couple very large MySQL Databases (like, 1TB+). They were huge, unforgiving beasts with an endless appetite to cause me stomach problems.
我阅读了有关MySQL性能调整和innodb的所有内容.以下是对我有帮助的摘要:
I read everything I could find on MySQL Performance Tuning and innodb. Here's a summary of what helped me:
- 这本书高性能MySQL 很好,但是只能让您走得那么远.
- 博客 MySQL Performance Blog(此链接指向其标记为'innodb'的帖子)是我在网上找到的最有用的整体资源.他们详细介绍了许多innodb调整问题.有时会获得保证",但总的来说很棒.这是 InnoDB性能优化基础上的另一个链接,它是好.
- 我要做的最后一件事是简单地阅读MySQL文档.我阅读了每个最后一个参数的工作原理,在服务器上对其进行了更改,然后进行了一些基本的分析.一段时间后,您可以通过运行大型查询并查看会发生什么来弄清楚什么是可行的.这是一个不错的起点: InnoDB性能调整和故障排除
- The book High Performance MySQL is good, but only gets you so far.
- The blog MySQL Performance Blog (this link is to their posts tagged 'innodb') was the most useful overall resource I found on the net. They go into detail on a lot of innodb tuning issues. It gets 'ranty' at times, but overall it's great. Here's another link there on InnoDB Performance Optimization Basics that's good.
- The last main thing I did to learn it was to simply read the MySQL Docs themselves. I read how every last parameter works, changed them on my server and then did some basic profiling. After a while you figure out what works by running big queries and seeing what happens. Here's a good place to start: InnoDB Performance Tuning and Troubleshooting
最后,它只是在尝试和研究事物,直到您获得足够的知识来知道有效的方法为止.
In the end, it's just experimenting and working through things until you gain enough knowledge to know what works.
这篇关于MySQL InnoDB(插入)性能优化的方法?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!