I need a book for advanced MySQL in PHP [closed]

Question

So I'm looking for a book for advanced MySQL in PHP. I know all the basics, and I've worked with it a lot. But I'm not real sharp on more advanced topics, like combining queries with JOINs, and avoiding redundant or unnecessary queries.

Any database theory/design thrown in would be a nice bonus too.

Answer 1

Not PHP specific (as others have mentioned, "advanced" MySQL knowledge should be language-independent), but here you go (from this question and 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.

(partial descriptions from Amazon included, see respective product page for more detailed info).

Answer 2

Expert PHP and MySQL (Wrox Programmer to Programmer)

Authors: Andrew Curioso, Ronald Bradford and Patrick Galbraith

• Reviews essential techniques, such as design patterns, complex queries, and advanced regularexpression
• Addresses advanced PHP concepts, such as iterators andclosures
• Demonstrates using Gearman for multitasking in your web applications
• Discusses caching using memcached with MySQL and your PHP webapplications
• Discusses ways to create PHP Extensions and MySQL User DefinedFunctions
• Shows how to use Sphinx for search functionality in your PHP web applications

MySQL High Availability: Tools for Building Robust Data Centers

Charles Bell, Mats Kindahl and Lars Thalmann

• Explore the binary log, a file for replication that helps in disaster recovery and troubleshooting
• Get techniques for improving response time and handling large data sets
• Monitor database activity and performance, as well as major operating system parameters
• Keep track of what masters and slaves are doing, and deal with failures and restarts, corruption, and other incidents
• Automate key tasks with code from an open source library written by the authors
• Learn techniques for using MySQL in virtualized environments, such as Amazon Web Services
• Use MySQL Cluster to achieve high availability