Extreme number of open connections between Web and DB server

tarik

New Member
I run 2 servers, 1 web (nginx/php), 1 database (mysql).Nginx has about 1500 active processes per second, and mysql status shows about 15 currently option connections on average.Now today i started running: \[code\]netstat -npt | awk '{print $5}' | grep -v "ffff\|127\.0\.0\.1" | awk -F ':' '{print $1}' | sort -n | uniq -c | sort -n\[/code\]This showed that there were over 7000 active connections from my webserver to my database server IP. This seems kind of extreme. I do not use persistent connections in PHP to connect to Mysql.I tried using mysql_close() also, but that seems to make no difference.On the webserver netstat shows over 7000 connections to the database serverOn the database server netstat shows just 300 connections to the web serverAny idea why there are so many open connections?
 
Top