Howdy guys,
I'm having some difficult time resolving an issue with mysql.
What's happening is that when I try to connect to the dedicated mysql server from a remote web server I get the following error:
I don't know where to look, really. Sometimes it works fine, other time it dies with the above error. The machines are connected through a single gige switch. I tried disabling firewall (ipfw) but that didn't help. Ssh to the mysql box work w/o issues.
Anyway the mysql box is constantly pretty loaded, there's quiet a lot of connections to it.
Any idea what I should try to look at?
Thanks!
I'm having some difficult time resolving an issue with mysql.
What's happening is that when I try to connect to the dedicated mysql server from a remote web server I get the following error:
Code:
root@[web1 /home/danger]# mysql --host=db1.opensubtitles.org
ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 54
I don't know where to look, really. Sometimes it works fine, other time it dies with the above error. The machines are connected through a single gige switch. I tried disabling firewall (ipfw) but that didn't help. Ssh to the mysql box work w/o issues.
Anyway the mysql box is constantly pretty loaded, there's quiet a lot of connections to it.
Code:
root@[db1 ~]# sockstat -4 | wc -l
1160
root@[db1 ~]# uptime
12:36PM up 25 days, 18:44, 10 users, load averages: 7.26, 9.63, 10.18
Any idea what I should try to look at?
Thanks!