Portal Home > Knowledgebase > Articles Database > Why are there so many MySQL processes on my server?
Why are there so many MySQL processes on my server?
| Posted by chasebug, 09-15-2010, 12:28 PM |
| Is this normal or something wrong with MySQL not closing the process after finish query?
|
| Posted by vapetrov, 09-15-2010, 12:36 PM |
| It may be "persistent connections".
Please login to mysql console and show result of the query:
show full processlist;
|
| Posted by GOT, 09-15-2010, 12:36 PM |
| Use ps -axf to ensure they are proper mysql processes. Might want to look at what files they have open using lsof. Mysql can spawn many processes back in the 4.x versions. You never see that in teh 5.x versions.
|
| Posted by Syslint, 09-15-2010, 12:44 PM |
| What is the result of " mysqladmin proc stat "
Also how many cpu cores you have ?
|
| Posted by eth00, 09-15-2010, 12:46 PM |
| Along with those you can give "mytop" a shot, it will show the process list in a top style fashion.
|
| Posted by chasebug, 09-15-2010, 12:51 PM |
| I forgot my root MySQL password, I logged into MySQL using the user that is using the most resource (other users have very little traffic), is that ok?
|
| Posted by chasebug, 09-15-2010, 12:54 PM |
| I got user denied error when running mysqladmin proc stat.
Server has 2 CPU.
|
| Posted by inspiron, 09-15-2010, 06:30 PM |
| Login in to your server with root and check the mysql processes using command,
mysqladmin processlist
|
Add to Favourites 
Print this Article
Also Read
Good SSL? (Views: 546)