Identify mysql process? Very high cpu load for a single mysql process

[Azurel]

Hello,

I have one single mysql process that running since 10h with very high load peaks (60-200% CPU). Uptime of the server is 24h. All other mysql processes working in short time with normal load (10-40% CPU).

Is here a way to identify the source of this process?
I use many times processlist in mysql shell, but there is nothing unnatural. How I can find the source of this one process? Can anybody help me here?

 

[SibProgrammer]

If you have some knowledge of Linux internals "strace" command could help you.

 

[InderS]

Hello,

You can check your mysql process list through following command

mysql -uadmin -p`cat /etc/psa/.psa.shadow` -e 'show full processlist'

 

[KristianM]

Hi,

you could also try "mysqltuner" and see if maybe your settings/configuration needs to be modified.

Regards,
Kristian