What are some good books on caching, allocation and optimization in php and mysql?

Question

PHP

What books on caching, distribution and optimization have you met on php and mysql?
Interested in such moments when the server capacity is not enough and several servers are required to distribute the load between them.
Where can I read about it or buy it? Something more advanced than the usual php book junk.

Answer 1

MySQL. Optimization Produces... perhaps the best book for optimizing performance and understanding how MySQL works

Answer 2

Rather, look for articles / video recordings of conferences / reports on highload.
Books I doubt that there are relevant and adequate.

Answer 3

I'll tell you right away... You won't find this in books. Maybe something in the video..
To optimize mysql, read its documentation.. it says how to cache (from frequently asked queries to a specific cell) ... but about php it all depends on your knowledge and cleanliness of the code.
Also use gzip and memcahe. Try not to write too much... And in php try not to repeat the code .. best use oop.
ps queries to the database are best written in mysqli (it's faster and safer) or PDO . It's up to you what you choose.. but mysql won't be supported soon.

Answer 4

Here is a good book on the subject. And here - just a small article about optimization. A bird's-eye view, so to speak.

Answer 5

Here are a couple of links: tyk tyk Well, or look
for yourself ... mysql query caching ... it will suit you better.
Cache the most frequent requests and results. scripts are better not worth it (it harms security) and when using memcache, make sure that the cache is closed from prying eyes) Otherwise, this is a common mistake...