MySQL Optimization

There is a site service on a self-written engine (PHP MySQL). Runs on a dedicated server. There are 200-250 thousand page views per day, in some tables there are more than 10 million records.

Periodically there are problems: high load on the CPU, slow loading of some pages.

Apparently, the problems are caused by interaction with the DB. Ill provide a list of pages that load slowly (more than a few seconds). The task is to make the load time normal - tenths of a second.

Thus, it is necessary:

- View the structure of the DB and make adjustments if necessary
- Get rid of slow database queries
- Partially optimize the code where necessary

In the comments, you can immediately write the estimated cost of the work.