Weird issue.

TheNixMaster · #1 (**permalink**) 12-28-06, 03:34 AM

[21-Dec-2006 20:54:01] PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Lost connection to MySQL server during query in /home/scripts/sql.php on line 11

What would cause error to appear randomly on website website error log. The sql machine is a
Dual Opteron (Dual Core) 265 (1.8Ghz)
4Gb's Ram
4x 160Gb 7200RPM sata's in raid 10
Redhat enterprise 4 x64
(The machine is only running mysql 4.1.21-standard & dns (4th NS))

The machine is doing about 300 queries per second (on avg).

The past few days I've been seeing the above error more and more and its starting to bother me. It seems if the mysqld is online for longer then about 2 days, sometimes more it gets worse. Normally a mysqld restart fixed the issue, but I've had to reboot the machine once becuase it was so severe.

Anyone have an idea what is causing this or how I can fix it.

Thanks.

#2 (**permalink**) 12-28-06, 08:03 AM

I have not seen this error before outside of the event logs. I do not think I ever did anything about my errors, but do you have limits set on your server? thats the only think I can think of which could cause it that I can think of...

http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

TheNixMaster · #3 (**permalink**) 12-28-06, 08:39 PM

I do have limits set but they are high enough where this wouldnt be an issue.

I was able to have this happen to me once during an order on the site, when you fill out the order form it lags for about 3 seconds then comes up with the mysql error. At that time the error is also emailed to me.

The machine is locked down to a set of about 100 IP's (for mysql), everything else is rejected so I dont think people could be doing any type of DDoS attack on it.

The system loads are as follows:

Code:

12:00:39 AM       CPU     %user     %nice   %system   %iowait     %idle
12:10:38 AM       all      2.00      0.00      1.59     26.78     69.63
12:20:38 AM       all      1.57      0.00      1.35     17.49     79.59
12:30:38 AM       all      1.25      0.00      1.11     17.63     80.01
12:40:38 AM       all      1.16      0.00      1.04     16.30     81.51
12:50:38 AM       all      1.16      0.00      1.06     17.90     79.88
01:00:38 AM       all      1.11      0.00      1.04     17.50     80.35
01:10:38 AM       all      1.34      0.00      1.19     15.44     82.02
01:20:38 AM       all      1.29      0.00      1.12     17.45     80.15
01:30:38 AM       all      1.25      0.00      1.07     14.44     83.25
01:40:38 AM       all      1.25      0.00      1.07     16.84     80.84
01:50:38 AM       all      1.08      0.00      0.98     17.36     80.58
02:00:38 AM       all      1.16      0.00      1.04     17.81     79.98
02:10:38 AM       all      1.07      0.00      0.96     16.93     81.05
02:20:38 AM       all      1.04      0.00      0.94     16.70     81.31
02:30:38 AM       all      1.17      0.00      1.03     17.27     80.54
02:40:38 AM       all      1.04      0.00      0.96     16.09     81.90
02:50:38 AM       all      1.04      0.00      0.95     15.45     82.55
03:00:38 AM       all      1.05      0.00      0.92     15.18     82.86
03:10:38 AM       all      1.07      0.00      0.91     16.54     81.48
03:20:38 AM       all      1.03      0.00      0.91     17.09     80.97
03:30:38 AM       all      1.07      0.00      0.97     15.87     82.08
03:40:38 AM       all      1.06      0.00      0.90     15.43     82.61
03:50:38 AM       all      0.99      0.00      0.86     15.33     82.81
04:00:38 AM       all      1.22      0.00      0.94     16.87     80.96
04:10:38 AM       all      1.16      0.00      0.91     15.89     82.05
04:20:38 AM       all      0.97      0.00      0.85     17.22     80.96
04:30:38 AM       all      1.13      0.00      0.92     16.63     81.31
04:40:38 AM       all      0.97      0.00      0.87     16.79     81.37
04:50:38 AM       all      1.32      0.00      0.90     16.12     81.66
05:00:38 AM       all      1.03      0.00      0.89     15.84     82.24
05:10:38 AM       all      1.05      0.00      0.89     16.12     81.94
05:20:38 AM       all      1.05      0.00      0.89     14.98     83.07
05:30:38 AM       all      0.98      0.00      0.86     15.54     82.63
05:40:38 AM       all      1.01      0.00      0.87     16.38     81.74
05:50:38 AM       all      0.92      0.00      0.84     15.88     82.36
06:00:38 AM       all      1.11      0.00      0.88     14.95     83.05
06:10:38 AM       all      4.91      0.00      1.78     17.76     75.55
06:20:38 AM       all      4.89      0.00      1.75     18.53     74.82
06:30:38 AM       all      5.17      0.00      1.84     18.64     74.35
06:40:38 AM       all      5.04      0.00      1.79     18.11     75.06
06:50:38 AM       all      5.18      0.00      1.83     18.45     74.54
07:00:38 AM       all      5.29      0.00      1.90     17.99     74.82
07:10:38 AM       all      4.87      0.00      1.74     18.04     75.35
07:20:38 AM       all      4.88      0.00      1.76     19.17     74.19
07:30:38 AM       all      4.84      0.00      1.74     17.80     75.62
07:40:38 AM       all      4.98      0.00      1.79     19.13     74.10
07:50:38 AM       all      4.96      0.00      1.75     16.42     76.87
08:00:38 AM       all      6.71      0.00      2.06     15.74     75.49
08:10:38 AM       all      4.92      0.00      1.73     15.82     77.53
08:20:38 AM       all      4.65      0.00      1.69     17.24     76.42
08:30:38 AM       all      4.89      0.00      1.76     17.14     76.21
08:40:38 AM       all      5.02      0.00      1.80     16.32     76.86
08:50:38 AM       all      5.07      0.00      1.81     16.36     76.76
09:00:38 AM       all      5.68      0.00      1.89     16.47     75.95
09:10:38 AM       all      4.70      0.00      1.71     16.42     77.17
09:20:38 AM       all      4.95      0.00      1.79     17.16     76.10
09:30:38 AM       all      4.99      0.00      1.78     15.75     77.48
09:40:38 AM       all      5.28      0.00      1.89     20.68     72.15
09:50:39 AM       all      5.00      0.00      1.80     16.50     76.70
10:00:38 AM       all      4.93      0.00      1.80     16.81     76.47
10:10:38 AM       all      4.80      0.00      1.76     16.47     76.98
10:20:38 AM       all      4.82      0.00      1.76     16.15     77.27

10:20:38 AM       CPU     %user     %nice   %system   %iowait     %idle
10:30:38 AM       all      5.00      0.00      1.80     15.94     77.26
10:40:38 AM       all      5.17      0.00      1.84     18.18     74.81
10:50:38 AM       all      3.58      0.00      1.49     16.13     78.80
11:00:38 AM       all      1.09      0.00      0.85     13.82     84.23
11:10:38 AM       all      1.00      0.00      0.86     14.47     83.67
11:20:38 AM       all      0.94      0.00      0.85     14.92     83.29
11:30:38 AM       all      1.01      0.00      0.86     15.02     83.11
11:40:38 AM       all      1.00      0.00      0.86     14.82     83.32
11:50:39 AM       all      0.93      0.00      0.84     13.98     84.25
12:00:38 PM       all      1.02      0.00      0.86     14.88     83.24
12:10:41 PM       all      1.51      6.69      1.51     26.75     63.54
12:20:38 PM       all      1.59      4.32      1.45     33.27     59.38
12:30:38 PM       all      1.67      5.31      1.53     30.00     61.50
12:40:39 PM       all      1.48      4.89      1.38     37.25     55.00
12:50:39 PM       all      1.27      5.13      1.15     38.93     53.52
01:00:38 PM       all      0.97      7.66      1.05     28.55     61.78
01:10:38 PM       all      1.04      3.48      1.02     29.72     64.74
01:20:38 PM       all      1.04      3.02      0.99     30.54     64.42
01:30:40 PM       all      3.27      3.72      3.95     44.41     44.65
01:40:40 PM       all      3.56      2.89      5.64     40.87     47.04
01:50:41 PM       all      1.07      7.23      1.33     38.17     52.20
02:00:40 PM       all      1.08      6.68      1.22     37.81     53.21
02:10:38 PM       all      1.03      0.80      1.02     25.94     71.21
02:20:38 PM       all      1.10      0.00      0.94     22.16     75.80
02:30:38 PM       all      1.33      0.00      1.13     20.89     76.65
02:40:38 PM       all      1.09      0.00      0.95     21.49     76.46
02:50:38 PM       all      1.09      0.00      0.94     17.65     80.32
03:00:38 PM       all      1.15      0.00      0.95     21.57     76.34
03:10:38 PM       all      1.12      0.00      0.97     19.57     78.33
03:20:38 PM       all      1.11      0.00      0.93     18.42     79.54
03:30:38 PM       all      1.08      0.00      0.93     18.63     79.36
03:40:38 PM       all      1.37      0.00      1.12     16.50     81.01
03:50:38 PM       all      1.28      0.00      1.11     16.85     80.76
04:00:38 PM       all      1.09      0.00      0.95     16.96     80.99
04:10:38 PM       all      1.10      0.00      0.92     16.59     81.39
04:20:38 PM       all      1.25      0.00      1.00     17.19     80.56
04:30:38 PM       all      1.18      0.00      0.99     18.88     78.96
04:40:38 PM       all      1.11      0.00      0.95     16.36     81.57
04:50:38 PM       all      1.18      0.00      0.99     17.48     80.35
05:00:38 PM       all      1.15      0.00      1.00     16.91     80.94
05:10:38 PM       all      1.09      0.00      0.93     16.92     81.06
05:20:38 PM       all      1.13      0.00      0.98     17.00     80.89
05:30:38 PM       all      1.09      0.00      0.98     16.35     81.58
05:40:38 PM       all      1.07      0.00      0.95     15.86     82.12
05:50:38 PM       all      1.07      0.00      0.96     17.49     80.48
06:00:38 PM       all      1.16      0.00      0.96     16.90     80.98
06:10:38 PM       all      1.24      0.00      1.00     17.26     80.50
06:20:38 PM       all      1.15      0.00      0.98     15.77     82.09
06:30:38 PM       all      1.15      0.00      1.00     16.51     81.34
06:40:38 PM       all      1.29      0.00      1.09     18.54     79.09
06:50:39 PM       all      1.31      0.00      1.12     17.39     80.18
07:00:38 PM       all      1.22      0.00      1.03     16.45     81.30
07:10:38 PM       all      1.29      0.00      1.04     16.80     80.86
07:20:38 PM       all      1.40      0.01      1.17     17.45     79.97
07:30:38 PM       all      1.35      0.00      1.15     17.43     80.07
07:40:38 PM       all      1.55      0.00      1.23     16.96     80.26
07:50:39 PM       all      1.71      0.00      1.39     16.84     80.07
08:00:38 PM       all      1.28      0.00      1.07     15.66     81.99
08:10:38 PM       all      1.17      0.00      0.99     15.52     82.32
08:20:38 PM       all      1.21      0.00      1.04     17.50     80.25
08:30:38 PM       all      1.21      0.00      1.06     15.82     81.90
08:40:38 PM       all      1.46      0.00      1.19     15.22     82.13

08:40:38 PM       CPU     %user     %nice   %system   %iowait     %idle
08:50:38 PM       all      1.22      0.00      1.05     15.69     82.04
09:00:38 PM       all      1.41      0.00      1.13     14.62     82.84
09:10:38 PM       all      1.26      0.00      1.08     17.02     80.64
09:20:39 PM       all      1.27      0.00      1.06     13.10     84.57
09:30:38 PM       all      1.28      0.00      1.09     13.08     84.56
Average:          all      2.07      0.48      1.26     18.61     77.58

Really no reason this should be happening.