my server uses a lot of cpu because of mysql, is there any way for me to know which code is pulling so much cpu?
check each and every one of your sql queries, usually it can be from making too many queries at the same time, for example updating the database with a for every 1 minute?
PS: it is an example.
PD2: I don't speak English, I use google translator.