Knowledgebase
Too many mysql process
| Posted by Tim G, 04-12-2009, 08:52 AM | | Hi,
There is a too many mysql process (because of directadmin) but i don't want to. As i read it is related with compile options.
Is there a way turn off that setting to one mysql process ? OR how can i told to directadmin that i want to one mysql process ?
It is a little bit urgent =) Thanks for your concern.
|
| Posted by eth00, 04-12-2009, 09:01 AM | | You realize if you limit how many processes mysql is using you are going to slow it down? Take a look at the thread-concurrency variable, set it to 1.
|
| Posted by Tim G, 04-12-2009, 10:26 AM | | I tried but unfortunately it isn't working exactly.
I don't get it. I'm seeing just 30-40 connection in netstat output for httpd but mysql using a lot of cpu. Also my.cnf is well configured. The server has core2duo processor and 3 gig ram.
Any idea ?
|
| Posted by eth00, 04-12-2009, 10:38 AM | | What exactly are you trying to do?
The 30-40 connections for the httpd is just saying you have some traffic going to your webserver. Generally people want traffic to the server.
|
| Posted by hexahost, 04-13-2009, 04:58 AM | | Enable mysql log in your startup script. Also try to increase error limit.
|
|
 Add to Favourites
 Print this Article
|
Also Read
