Why Do i face the same problem again and again I dont even know why this happens .. please see the pic below Can anyone please tell me what is happening to mysql and httpd here I basically use a forum ( ipb ) and an imagehost with decent traffic The server specs are Intel i7 Quad core Why do i see too many mysql processes
That looks like a DirectAdmin box, and from what I recall, each user will spawn a process when needed, so, if you have many accounts on the server, and each user uses MySQL, you would have a large number of PIDs for it.
Yes its Direct Admin ... Its my dedi server i have turned it into VPS and am using it .. Is there a way to minimize the mysql thing so that the site's dont do down
You could optimize your Apache and MySQL configurations so that they perform better, which will lessen the loads.
There are many things you can do, and its not the same for each server. You can install things like mod_deflate to help reduce the amount of data your server sends out. I use scripts like mysql tuning primer and mysqlreport to fine tune how the mysql server runs. Depending on your Apache installation, you would fine tune parameters such as your start servers, min spare and max spare values. If you are comfortable doing these types of things, then Google is your friend. If not, I would suggest you hire a third party.