How to overcome high CPU usage 100%, CPU load 100% in MySQL 8.
Previously using MySQL 5.7 and MariaDB, CPU usage was around 30%, CPU load was less than 10%.
CPU cores: 8
RAM: 40 GB
nginx
All configurations are the same, nothing has changed, so this is clearly a problem with MySQL 8.
How can it be resolved?
