I have problem with MySQL CPU usage

[amir]

I have problem with MySQL CPU usage and i couldnt find witch user has high usage?
where can i find the user that has hi usage?

 

[IgorG]

Have you tried to optimize mysql databases firstly?

 

[amir]

where can i do it?

 

[IgorG]

where can i do it?

In command line, for example.
Read official mysql documentation - https://dev.mysql.com/doc/refman/5.5/en/optimize-overview.html

 

[amir]

I say again, i need to find user thag has high usage, it is difrence with optimize

 

[IgorG]

Maybe this article will help you - https://kb.odin.com/en/124921

 

[amir]

I think you dont know any thing about plesk

 

[IgorG]

I think you dont know any thing about plesk

 

[amir]

I need to find high usage user,in cpanel we can fine on 2 second
but in plesk we can find it

 

[IgorG]

Have you read mentioned KB article? Have you received list of mysql processes and corresponding users as it is described there? It is usual mysql administrative task not related to cPanel or Plesk or something else. As well mysql optimization.