Number om mysql processes - is this unusuall?

I have a user on a server who continually is having 5-10 mysql processes running. Also, checking the reseller center root access were enabled to this reseller. I have no idea how something like that could happen. I know that these two things may not be related to one another but is he abusing the server? The server load has been to high on this server lately.

+-------+-----------------+-----------+-------------------+---------+-------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-------+-----------------+-----------+-------------------+---------+-------+-------+------------------+
| 73624 | usern_user | localhost | usern_user | Sleep | 9788 | | |
| 73782 | usern_user | localhost | usern_user | Sleep | 10716 | | |
| 73793 | usern_user | localhost | usern_user | Sleep | 9914 | | |
| 73824 | usern_user | localhost | usern_user | Sleep | 11484 | | |
| 73990 | usern_user | localhost | usern_user | Sleep | 9358 | | |
| 74051 | usern_user | localhost | usern_user | Sleep | 9036 | | |
| 74088 | usern_user | localhost | usern_user | Sleep | 11851 | | |
| 74096 | usern_user | localhost | usern_user | Sleep | 11753 | | |
| 74149 | usern_user | localhost | usern_user | Sleep | 10962 | | |
| 74160 | usern_user | localhost | usern_user | Sleep | 11299 | | |
| 74541 | usern_user | localhost | usern_user | Sleep | 3718 | | |


Also, I have a script that can set a maximum limit on the number of mysql processes allowed per user. Would 3 processes be reasonable? Hoping for some input.

Thanks
John

 

 

 

 

Top