How to find out which queries load mysql?

Question

MySQL

My mysql database takes up the processor either by 7 percent, or by 90. And I can’t understand what it is doing, that the values ​​​​are growing like this. I tried to look in show processlist; , but I don’t understand anything and is it really necessary to look there?
I look at the processor load through htop and atop.
Question: how to find out what specifically loads the database at the moment when the processor is loaded more than usual (7-10%)?

Answer 1

I give you two tips:
1. Your question should sound like "suggest literature on database profiling"
2. Link to the start of profiling in MySQL
Further on by yourself, because the further is no longer in the subject of the "question / answer" service