Which articles to read on improving database performance?

Question

MySQL

Obvious things like indexes have been checked, but the MySQL database still generates terabytes of I / O and eats the processor. We need subtle methods for finding bottlenecks. Please provide links to interesting articles. In Russian or in English. Thanks in advance.

Answer 1

Must read
www.mysqlperformanceblog.com/

Answer 2

EXPLAIN know how to use? Have you set up monitoring and logging of slow queries? Have you allocated enough memory?
I also advise, if you haven’t read it, to start reading the official manual in the part that talks about settings and memory consumption.

Answer 3

I liked the book:
MySQL. Performance optimization. 2nd ed.
Authors: Schwartz B., Zaitsev P., Tkachenko V., Zavodny J., Lenz A., Balling D.