What is some good literature on improving MySQL query performance?

Question

MySQL

Good afternoon.

Please tell me something good to read about how to properly design databases for high-load projects. Interested in describing the performance of indexes, how to build it correctly in practice, simplifying complex queries, and the like. MyISAM vs. InnoDB. Haven't dealt directly with major MySQL database design before. I have been working with MySQL for a long time.

Thank you very much in advance.

Answer 1

High Performance MySQL, 2nd Edition Optimization, Backups
, Replication, and More MySQL. Performance Optimization (2nd edition)