Portal Home > Knowledgebase > Articles Database > too many 127.0.0.1 connection
too many 127.0.0.1 connection
| Posted by lifeisjustabout, 01-10-2011, 12:04 AM |
| hi when i check apache status there is too many line like
198-92 - 0/0/4 . 0.00 78719 0 0.0 0.00 0.00 127.0.0.1 noc1.server.com OPTIONS * HTTP/1.0
i think this is related mysql or not
is there anyway to close this pid in 5min or 10min?
|
| Posted by asciiDigital, 01-10-2011, 12:19 AM |
| paste your my.cnf file
|
| Posted by lifeisjustabout, 01-10-2011, 12:28 AM |
| etc/my.cnf
|
| Posted by asciiDigital, 01-10-2011, 12:44 AM |
| I would lower the max_connections to start.
|
| Posted by lifeisjustabout, 01-10-2011, 12:55 AM |
| nothing changed
|
| Posted by lifeisjustabout, 01-10-2011, 01:22 AM |
| is there any way i can set up idle workers time for disconnection
|
| Posted by Bokudan, 01-10-2011, 01:25 PM |
| Yep!!!!
You can put a die connection until x time ...
wait_timeout and interactive_timeout
These 2 parameters limit in seconds the query max time.
Best Regards,
|
| Posted by lifeisjustabout, 01-10-2011, 10:23 PM |
| i added those line in /etc/my.cnf didnt help still many 127.0.0.1 comes up
i need to close or shutdown pid . "Open slot with no current process" for example if connection been idle will be disconnect in 120second
if i find this this problem will be solved
|
| Posted by Hostify Networks, 01-10-2011, 11:08 PM |
| What made you believe that this has anything to do with MySQL? It doesn't. It's normal Apache operation.
|
| Posted by lifeisjustabout, 01-11-2011, 03:57 AM |
| whether caused mysql or not it should close the connection been idle "Open slot with no current process" this sucks cpu many useless pid what makes you to think not caused by another then mysql? its been 2 days these 127.0.0.1 pid comes up (same pid number not new) this is not normal. it should trigger someting to shutdown those connections. or i will have to make a cron to restart httpd every 6 hours interval.
Last edited by lifeisjustabout; 01-11-2011 at 04:05 AM.
|
| Posted by Hostify Networks, 01-11-2011, 01:54 PM |
| Idle processes don't suck up CPU time. ;-) They will go away over time. This is nothing to worry about. But if you don't believe me... http://forums.cpanel.net/f5/127-0-0-...0-a-75174.html
|
| Posted by Bokudan, 01-11-2011, 02:19 PM |
| Hello!
It will sound stupid, but... did you restarted the mysql daemon to apply change?
And maybe you could do a show processlist and see if there are a lot of connection pendding to close.
Best Regards,
|
| Posted by krizag, 01-11-2011, 03:58 PM |
| what is the output of
mysqladmin proc
|
Add to Favourites 
Print this Article
Also Read
Shared Hosting
Shared Hosting
