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

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.

Closed 6 years ago.

Improve this 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 n开发者_JAVA百科ice bonus too.

---

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).

---

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

---

If you care about performance this is a 10/10 stars book: http://oreilly.com/catalog/9780596101718

Depending on the subject it ranges from intermediate to advanced. It's a must have in case you are serious about your database backed projects (and you've got a bit of traffic in order to care).

---

Pick a more generic SQL book. PHP (the client using the database results) does not have to be mentioned in the book since you want to know how to use the query language and the relational database design.

There may be some books talking generically about MySQL, which can be preferable to you because MySQL doesn't implement the entire SQL language, but even a generic book talking about other SQL servers should suit your needs because the differences are small.