$sql = "Select D.*, U.nickname,u.dkday from users as U-OUTER JOIN dklist as D on (u.uid = D.uid) $where ORDER by $or Dername DESC LIMIT ". ($page-1) * $pageSize. ', '. $pageSize;
$result = mysql_query ($sql);
The above page code in the site first page load run, take the first pages of data.
Day PV3500, the total number of connections to the limit, should not be.
What do you think is causing the connection pool to be full?
It will be about 20 minutes, and now the number of concurrent connections in MySQL tune is 1500.
Reply to discussion (solution)
You're using a long connection (mysql_pconnect)
You're using a long connection (mysql_pconnect)
In a language.
Is the System 2003?
Linux Systems
There really is no long link
$_sc[' pconnect '] = 0; Database Persistent Connection 0 = off, 1 = Open
Should be open after connection is not closed
Mysql_close ();
Close, monitoring even after less than a second to go, concurrency is definitely super 100, set of the 1500 did not work is how it happened.
The concurrency setting doesn't work, and another site uses the same database, a lot of sleep processes ....