By Baron Schwartz
Excessive functionality MySQL is the definitive advisor to development quick, trustworthy structures with MySQL. Written via famous specialists with years of real-world adventure construction very huge platforms, this e-book covers each point of MySQL functionality intimately, and makes a speciality of robustness, safeguard, and information integrity.
High functionality MySQL teaches you complicated thoughts extensive so that you can deliver out MySQL's complete strength. methods to layout schemas, indexes, queries and complex MySQL positive aspects for optimum functionality, and get precise counsel for tuning your MySQL server, working approach, and to their fullest capability. you are going to additionally research functional, secure, high-performance how one can scale your functions with replication, load balancing, excessive availability, and failover.
This moment variation is totally revised and enormously accelerated, with deeper insurance in all parts. significant additions include:
• Emphasis all through on either functionality and reliability
• Thorough assurance of garage engines, together with in-depth tuning and optimizations for the InnoDB garage engine
• results of recent gains in MySQL 5.0 and 5.1, together with kept techniques, partitioned databases, triggers, and views
• a close dialogue on easy methods to construct very huge, hugely scalable platforms with MySQL
• New concepts for backups and replication
• Optimization of complex querying beneficial properties, resembling full-text searches
• 4 new appendices
The booklet additionally contains chapters on benchmarking, profiling, backups, protection, and instruments and methods that will help you degree, video display, and deal with your MySQL installations.