Periodically, the load on the processor is 100% from mysql, how to reduce it?

Question

MySQL

When there is a peak of traffic on the site (prnt.sc/1eb9vec - the server crash is highlighted in red), the load on the server (for all 4 cores) = 100% from mysql (prnt.sc/1eba5va). Tech support said that the server has a large number of Mysql search queries (prnt.sc/1ebah7h), from which the server is heavily loaded.

Server specifications: 4 cores-8ram-40ssd. The question is how to reduce the mysql load or optimize queries (although it is believed that queries are optimized in dle). All basic optimizations are done.

Answer 1

although they believe that in dle queries are optimized

on the screen and so it is clear that this is a lie

or optimize queries

Answer 2

Set a limit of 1000 HTTP requests - this is more than enough for DLE. The only thing that SQL can load for you is a quick search.
Everything is really optimized in DLE. I personally use DLE on sites where there are 100k uniques per day and everything is fine with me. The load from MySQL has never seen higher than 5%. And my sites are hosted for $5 by Inferno.