所以我正在寻找一本关于
PHP高级MySQL的书.我知道所有的基础知识,而且我已经和它一起工作了很多.但我对更高级的主题并不是很敏锐,比如将查询与JOIN结合起来,避免冗余或不必要的查询.
任何数据库理论/设计都会是一个很好的奖励.
解决方法
不是PHP特定的(正如其他人所提到的,“高级”MySQL知识应该是与语言无关的),但是你去(从
this question和
this question):
Understanding MySQL Internals:
Learn how data structures and convenience functions operate,how to add new storage engines and configuration options,and much more
High Performance MySQL:
Learn how to design schemas,indexes,queries and advanced MySQL features for maximum performance,and get detailed guidance for tuning your MySQL server,operating system,and hardware to their fullest potential. You’ll also learn practical,safe,high-performance ways to scale your applications with replication,load balancing,high availability,and failover.
Pro MySQL:
Topics include transaction processing and indexing theory,benchmarking and profiling,and advanced coverage of storage engines,data types,subqueries,derived tables,and joins. Also covers MySQL 5’s new enterprise features like stored procedures,triggers,and views.
(包括亚马逊的部分描述,请参阅相应的产品页面以获取更多详细信息).
(编辑:李大同)
【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!
|