 |  |  |  |  |  |  |  |
Cannot connect to server
Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
•
•
Join Date: Feb 2002
Posts: 12,024
Reputation: 
Solved Threads: 127
** CAN A MYSQLD EXPERT PLEASE HELP ME OUT ON THIS ONE **
I am having a problem with my MySQLd on db2.daniweb.com going through periods of 1-2 minutes every couple of hours where it refuses connections from Apache on web.daniweb.com. The error being thrown back is:
mysql_pconnect(): Can't connect to MySQL server on '10.0.0.2'
As you can see, I'm using persistent connections since I understand that they are more efficient when the web and database servers are not on the same machine, to eliminate the constant handshake overhead.
The Aborted_clients variable seems to constantly and continuously increment throughout the day. I am wondering if this is a hacking attempt where someone is constantly trying to connect to the MySQL server with an incorrect username and password. The aborted_connects variable is synonymous with when I encounter downtime, and it represents the number of visitors to my php-driven website who are unable to connect to the MySQL server.
*************************************************************************************
*************************************************************************************
************* IMMEDIATELY AFTER *****************************************************
*************************************************************************************
*************************************************************************************
*************************************************************************************
*************************************************************************************
********** A FEW MINUTES LATER ******************************************************
*************************************************************************************
*************************************************************************************
*************************************************************************************
*************************************************************************************
****************** MORE INFO ********************************************************
*************************************************************************************
*************************************************************************************
Essentially, 99% of the day there is an average of 30 threads connected to the MySQL server. However, for some reason I cannot figure out, once or twice a day, this spikes to a ridiculously high number. When this happens, my Apache server is unable to connect to the database server. Additionally, trying to login via SSH to the database server at this time is futile, as well - apparently the server load average brings everything to a halt. Once I finally am able to login, all 3 server load averages displayed in 'top' are very low showing there was no spike in CPU time. However, I am not sure whether the MySQL connected threads reached its 1000 max during the period of downtime ... it was a couple hundred when I successfully established a connection with the server to check. From what I have been reading, it is a very bad idea to set max_connections to anything higher than 1000. Here are my currently set MySQL variables:
I am having a problem with my MySQLd on db2.daniweb.com going through periods of 1-2 minutes every couple of hours where it refuses connections from Apache on web.daniweb.com. The error being thrown back is:
mysql_pconnect(): Can't connect to MySQL server on '10.0.0.2'
As you can see, I'm using persistent connections since I understand that they are more efficient when the web and database servers are not on the same machine, to eliminate the constant handshake overhead.
The Aborted_clients variable seems to constantly and continuously increment throughout the day. I am wondering if this is a hacking attempt where someone is constantly trying to connect to the MySQL server with an incorrect username and password. The aborted_connects variable is synonymous with when I encounter downtime, and it represents the number of visitors to my php-driven website who are unable to connect to the MySQL server.
*************************************************************************************
*************************************************************************************
************* IMMEDIATELY AFTER *****************************************************
*************************************************************************************
*************************************************************************************
MySQL Syntax (Toggle Plain Text)
*************************************************************************************
*************************************************************************************
********** A FEW MINUTES LATER ******************************************************
*************************************************************************************
*************************************************************************************
MySQL Syntax (Toggle Plain Text)
*************************************************************************************
*************************************************************************************
****************** MORE INFO ********************************************************
*************************************************************************************
*************************************************************************************
Essentially, 99% of the day there is an average of 30 threads connected to the MySQL server. However, for some reason I cannot figure out, once or twice a day, this spikes to a ridiculously high number. When this happens, my Apache server is unable to connect to the database server. Additionally, trying to login via SSH to the database server at this time is futile, as well - apparently the server load average brings everything to a halt. Once I finally am able to login, all 3 server load averages displayed in 'top' are very low showing there was no spike in CPU time. However, I am not sure whether the MySQL connected threads reached its 1000 max during the period of downtime ... it was a couple hundred when I successfully established a connection with the server to check. From what I have been reading, it is a very bad idea to set max_connections to anything higher than 1000. Here are my currently set MySQL variables:
MySQL Syntax (Toggle Plain Text)
•
•
Join Date: Feb 2002
Posts: 12,024
Reputation:
Solved Threads: 127
I think I got to the bottom of this issue 
It turns out, strangely enough, that MySQL has a tendency to leak connections when it is unable to resolve the hostname of who is connecting to it. I added an entry into the /etc/hosts files of both my web and db servers to map the hostname to IP address of the other one, and haven't had problems for almost one full day. So we'll see how it goes ......
It turns out, strangely enough, that MySQL has a tendency to leak connections when it is unable to resolve the hostname of who is connecting to it. I added an entry into the /etc/hosts files of both my web and db servers to map the hostname to IP address of the other one, and haven't had problems for almost one full day. So we'll see how it goes ...... 
•
•
•
•
Originally Posted by PillFORM
Now why do you need an Expert when your the mastermind here
:eek:
Phil
necesito una Data base para mi web xD 
|
Similar Threads
- windows server 2003 can't connect to the internet (Windows NT / 2000 / XP)
- SQL Server 2000 Help (MS SQL)
- Using PHP to connect to remote MSSQL database (PHP)
- Cannot connect with Internet Explorer (Windows NT / 2000 / XP)
- Cisco switches+Router and Win2k server (Networking Hardware Configuration)
- setting up novell 5 server (Novell)
- Cant connect to anything (Windows NT / 2000 / XP)
- Problem starting windows xp.. (Windows NT / 2000 / XP)
- OS X disconnects from NT server, system 9 is OK (OS X)
Other Threads in the MySQL Forum
- Previous Thread: Multiple databases/separate sites in mysql
- Next Thread: mysql < CSV < mydql
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest MySQL Posts
- Today's Posts
- Unanswered Threads
agplv3 amazon api artisticlicense aws bizspark breathalyzer camparingtocolumns changingprices cmg communityjournalism contentmanagement contractors copyright count court crm database design developer development distinct drupal dui ec2 email enterprise eudora facebook form foss gartner gnu government gpl greenit groklaw groupware hiring hyperic images innerjoins insert ip joebrockmeier join journalism keyword keywords kickfire laptop law legal license licensing linux managing mariadb matchingcolumns metron micromanage microsoft microsoftexchange mindtouch montywidenius mozilla multiple music mysql mysqlcolumnupdating mysqlindex mysqlinternalqueries mysqlquery mysqlsearch news open-xchange opendatabasealliance opengovernment opensource oracle penelope php priceupdating query referencedesign reorderingcolumns resultset saas select sharepoint simpledb sourcecode spotify sql sugarcrm syntax techsupport thunderbird transparency virtualization