什么你读过的最好的书或文章优化mysql服务器(linux)?(关闭)Whats the best book or article you have read on optimizing mysql servers (linux)? [closed]

- 此内容更新于:2014-12-30
主题:

我正在寻找一本好书或文章将帮我优化mysql服务器。我使用InnoDB,要确保整个数据库加载到RAM中,但不知道如何。

原文:

I am searching for a good book or article which will help me optimize my mysql servers even more. I am using InnoDB and want to make sure the whole db is loaded into RAM but don't know how.

解决方案:
高性能MySQL第二版是强烈推荐。
原文:

High Peformance MySQL Second Edition is highly recommended.

解决方案:
你可能会给更多的细节类型的应用,模式,连接、索引、等操作systme,什么样的主机/服务器和突袭,具体问题。然而 这些博客是最好的一些详细的见解 http://provenscaling.com/blog/ http://highscalability.com/tags/mysql http://xaprb.com/blog/ http://mysqldba.blogspot.com/ http://mysqldatabaseadministration.blogspot.com/
原文:

You might give more detail on the type of app, schema, joins, indexing, etc. Also your operating systme, what kind of host/server and RAID, specific issues. However

these blogs are some of the best for detailed insights

http://provenscaling.com/blog/

http://highscalability.com/tags/mysql

http://xaprb.com/blog/

http://mysqldba.blogspot.com/

http://mysqldatabaseadministration.blogspot.com/