Who uses mysql?

M

mmx38

Member
Apr 28, 2010
8
0
51
Hello!

I noticed that mysql makes high usage of cpu..

Is there any way to know which accounts/users are using the mysql?


Thank you!
 
cPanelTristan

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
44
348
somewhere over the rainbow
cPanel Access Level
Root Administrator
Yes, you can check WHM > Daily Process Logs for MySQL activity by set users.

You can run mysqladmin proc to check the currently running processes (or watch -n 5 "mysqladmin proc" to have a time delay refresh of it).

You could enable the general and slow query logs as well. We don't have the information on what MySQL version you are using to provide more input on that. You can find out your MySQL version by running this command:

Code: 
mysql_config --version
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
O Mysql uses too much cpu Databases 6
C mysqluserstore script causes sql server restart every two hours Databases 3
A What does it mean for buildapache application uses the MySQL libraries and headers on the server its Databases 1
M MariaDB uses more resources than MySQL Databases 1
O MySQL refuses access to everything... Databases 6
Similar threads
Mysql uses too much cpu
mysqluserstore script causes sql server restart every two hours
What does it mean for buildapache application uses the MySQL libraries and headers on the server its
MariaDB uses more resources than MySQL
MySQL refuses access to everything...
Top Bottom