oracle 有哪些资源可用于数据库性能调优？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/761204/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
What resources exist for Database performance-tuning?
提问by Gavin Miller
What good resources exist for understanding database tuning on the major engines and advancing your knowledge in that area?
有哪些好的资源可以用来理解主要引擎上的数据库调优并提高您在该领域的知识？
The idea of this question is to collect the shed load of resources that invariably exist, so that people can have a "one stop" knowledge shop of the good, peer approved resources.
这个问题的想法是收集总是存在的资源的卸载，以便人们可以拥有一个良好的、同行认可的资源的“一站式”知识商店。
General SQL
通用 SQL
- Book: SQL Performance Tuning
- Book: SQL Tuning
- Book: The Art of SQL
- Book: Refactoring SQL Applications
- Book: Database tuning: principles, experiments, and troubleshooting techniques
- Use The Index, Luke! - A Guide to database performance for developers
- Performance Optimization
- Quick PostgreSQL Optimization
- Explain Analyze Interpreter
- PostgreSQL Performance Tips
- Book: PostgreSQL 9.0 High Performance
MySQL
MySQL
- Hidden Features of MySQL
- Book: High Performance MySQL/ Blog: High Performance MySQL
- Blog: Xaprb (for MySQL DBAs)
Oracle
甲骨文
- How to ask Oracle tuning questions on StackOverflow
- How do you interpret a query's explain plan?
- Oracle Advanced Tuning Scripts
- Oracle Database Performance Tuning Guide
- Ask Tom
- Oracle Database SQL Reference
- Book: Understanding Oracle Performance
- Book: Optimizing Oracle Performance
- Book: Troubleshooting Oracle Performance
- Book: Cost-Based Oracle Fundamentals
- 如何在 StackOverflow 上询问 Oracle 调优问题
- 您如何解释查询的解释计划？
- Oracle 高级调优脚本
- Oracle 数据库性能调优指南
- 问汤姆
- Oracle 数据库 SQL 参考
- 书籍：了解 Oracle 性能
- 书籍：优化 Oracle 性能
- 书籍：Oracle 性能故障排除
- 书籍：基于成本的 Oracle 基础知识
MS SQL Server
微软 SQL 服务器
- SQL Server Performance
- eBook: High Performance SQL Server
- SO Question: What are the best SQL Server performance optimization techniques?
- Brent Ozar's Perf Tuning Page
- SqlServerPedia's Perf Tuning Page
- Book: Sql Server 2008 Internals
- How to Identify Slow Running Queries with SQL Profiler
- SQL Server 性能
- 电子书：高性能 SQL Server
- SO 问题：最好的 SQL Server 性能优化技术是什么？
- Brent Ozar 的 Perf Tuning 页面
- SqlServerPedia 的性能调优页面
- 书籍：Sql Server 2008 内部结构
- 如何使用 SQL Profiler 识别运行缓慢的查询
Sybase SQL Anywhere
Sybase SQL Anywhere
JDBC
JDBC
回答by Neil Kodner
Oracle's very own Tom Kyte has a fantastic repository on every type of performance problem imaginable on http://asktom.oracle.com. He usually takes the time to recreate specific problems and gives very detailed explanations.
Oracle 自己的 Tom Kyte 在http://asktom.oracle.com上有一个关于各种可以想象的性能问题的出色资料库。他通常会花时间重现具体问题并给出非常详细的解释。
回答by cgp
This guy's answer to a not-the-same-inquiry is probably a good start.
这家伙对不一样的询问的回答可能是一个好的开始。
回答by Milen A. Radev
And something for PostgreSQL: "Performance Optimization"at the official wiki.
回答by Anthony
If you are using an Oracle database, this guide may also help. http://download.oracle.com/docs/cd/B28359_01/server.111/b28274/toc.htm
如果您使用的是 Oracle 数据库，本指南也可能有所帮助。 http://download.oracle.com/docs/cd/B28359_01/server.111/b28274/toc.htm
回答by nathan
For MySQL, the performance tuning 'bible' is High Performance MySQL
对于 MySQL，性能调优“圣经”是高性能 MySQL
回答by Louis
Quick PostgreSQL Optimization(query optimizing)
快速 PostgreSQL 优化（查询优化）
Short read, explains a lot of things well and 'works' a real example which is nice for those of us that learn better that way.
简短的阅读，很好地解释了很多事情并且“有效”了一个真实的例子，这对我们这些以这种方式学习得更好的人来说是很好的。
After seeing the wiki link to PostgreSQL, figured I'd edit this post with links for mysql/oracledocs, not really an optimization guides specifically but both are good resources, especially the mysql one. For optimization and any other tuning features.
在看到 PostgreSQL 的 wiki 链接后，我想我会用mysql/ oracle文档的链接来编辑这篇文章，这并不是专门的优化指南，但两者都是很好的资源，尤其是 mysql 资源。用于优化和任何其他调整功能。
回答by beetstra
A lot of good MySQL specific tips can be found at http://www.mysqlperformanceblog.com/
可以在http://www.mysqlperformanceblog.com/上找到很多很好的 MySQL 特定技巧
回答by Nathan Voxland
I would add that besides having your database theoretically tuned, you should profile your application using a profiler that tracks SQL calls.
我想补充一点，除了理论上调整您的数据库之外，您还应该使用跟踪 SQL 调用的分析器来分析您的应用程序。
Despite your best intentions, a few bad calls will sneak into your application and will often cause 90% of your performance-related problems.
尽管您的意图是最好的，但一些错误的调用还是会潜入您的应用程序中，并且通常会导致 90% 的与性能相关的问题。
回答by Gavin Miller
SO has a good one here: How do you interpret a query's explain plan?
所以这里有一个很好的：你如何解释查询的解释计划？
回答by John Sansom
If you are looking for SQL Server specific Performance tuning references there are an absolute shed load of quality resources available online, ranging from white papers on implementing specific technologies such as partitioning, to excellent Blogs that detail step by step instruction on how to performance tune a sql server platform.
如果您正在寻找 SQL Server 特定的性能调优参考，则可以在线获得大量优质资源，从有关实施特定技术（如分区）的白皮书到详细介绍如何调优性能的分步说明的优秀博客。 sql server 平台。
Shameless plug follows: You can start you research by reviewing the performance tuning area of my personal Blog, or for any specific SQL Server requirements/issues feel free to fire me an email.
无耻插件如下：您可以通过查看我的个人博客的性能调整区域来开始您的研究，或者对于任何特定的 SQL Server 要求/问题，请随时向我发送电子邮件。
