What books on server-side optimization of mysql + apache on *.nix systems exist?

Question

MySQL

It is necessary to optimize the operation of MySql in conjunction with Apache on the Ubuntu server.
Since my knowledge in this topic is not enough, I would like to replenish it from books, what books will help me along the way?
So far I found this one:
www.spbdk.ru/catalog/765687.html Database
size: TOP
query statistics The fattest table weighs 314.5 MB Here is its structure:

Answer 1

The question is slightly incorrect. There is a separate mysql optimization, a separate apache (which is in conjunction with php, for example), a separate php. There are separate books on this.
But I would recommend tearing down the Indian, installing nginx, installing php-fpm, installing redis. Connect redis to php and php-fpm to nginx. Set up nginx, mysql, php-fpm separately and cache the results of mysql and php work through radish.
Well, look at Java, python and other alternatives, you will suddenly like it :-)

Answer 2

Books? A couple of articles from the Internet are enough, fix the configs and that's it

Answer 3

> mysql
if you want to do it professionally, learn how mysql works. This will do you a huge favor in optimization.
> php, apache
php - by itself is not particularly optimized. There are additional tools - caches (APC, OpCache), there are some options in php.ini - just study "what can be configured in general in php"
In general - in general, web optimization is architecture optimization - replacing apache + php with php5-fpm + nginx.
Disk IO optimization, network optimization, etc...
I.e. The question is too general to be answered in one post.