Peter Brawley Wrote:
-------------------------------------------------------
> > Complete processing of all queries in the
> database is impossible,
> > no one will allocate money for this!
>
> Nobody suggests that.
>
> Turn on the MySQL slow query log for a week, fix
> the quwries that turn up in it. Run the cheatsheet
> described under that heading at
>
https://www.artfulsoftware.com/infotree/mysqltips.php
> and if you need help understanding or following
> the suggestions that script throws up, let's
> discuss here.
I understood your advice, but it is meaningless!
I was hoping that the official mysql product forum would help.
But well, for now I will leave 5,7,33, after that I will simply transfer the base to mariadb!
It's ridiculously simple, you advise to sort out all the requests completely and in the end I'm sure that the load will still not go away in version 5.7.34!
Then the question why the same queries in version 5.7.33 work fine is perfect!
And in version 5.7.34, a 100% load on the processor appears and the web project slows down !?