I am having issues with MySQL 5.7 using a lot of memory and a lot of threads on my prod server, and having some issues getting much results out of any changes I have made.
- Is there a reason so many threads are in use?
- How can I reduce the memory consumption down as its slowing the server a lot.
This is MySQL install on a fresh copy of ubuntu20. Nothing else was installed except mysql.
After adding performance_schema = 0
to /etc/nginx/my.cnf
SHOW PROCESSLIST
on the mysql prompt would be a more useful indicator as to what it is doing.