Re: Failed connectionattempts
Anders Bruun Olsen [EMAIL PROTECTED] wrote: I have a server which has been running for about a year now. It started with kernel 2.4.19 and mysql 3.x it has since been continually upgraded so that it is now kernel 2.4.20 and mysql 4.0.13. The server is a Compaq server with dual Pentium II (Deschutes) 400MHz 512Kb cache CPUs, 320Mb RAM and SCSI drives. The OS is Gentoo Linux. From the beginning it has behaved strangely - connections to mysql (be that with the mysql textclient or from PHP) fails about 2 out of 3 times in periods. Some times there are no problems, other times it's almost impossible to connect. This behavior has been consistent from the start, so it has been a problem when running both mysql 3.x and 4.0.x. I have monitored the servers load and the loads are the same in the periods when it fails as in the periods when it doesn't. I have tried monitoring the mysql logs, but no entries show up upon the failed connection attempts. No other services malfunctions in this way, or indeed at all on the server. I have run out of ideas on how to debug this problem, can anybody here help me? What error did you receive? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Failed connectionattempts
On Fri, Sep 19, 2003 at 11:47:38AM +0300, Egor Egorov wrote: I have a server which has been running for about a year now. It started with kernel 2.4.19 and mysql 3.x it has since been continually upgraded so that it is now kernel 2.4.20 and mysql 4.0.13. The server is a Compaq server with dual Pentium II (Deschutes) 400MHz 512Kb cache CPUs, 320Mb RAM and SCSI drives. The OS is Gentoo Linux. From the beginning it has behaved strangely - connections to mysql (be that with the mysql textclient or from PHP) fails about 2 out of 3 times in periods. Some times there are no problems, other times it's almost impossible to connect. This behavior has been consistent from the start, so it has been a problem when running both mysql 3.x and 4.0.x. I have monitored the servers load and the loads are the same in the periods when it fails as in the periods when it doesn't. I have tried monitoring the mysql logs, but no entries show up upon the failed connection attempts. No other services malfunctions in this way, or indeed at all on the server. I have run out of ideas on how to debug this problem, can anybody here help me? What error did you receive? In PHP it just says connection failed. I can't remember the exact message the textclient gave, and it is in a period of not failing right now (typical!) so I can't get the message right now. I think it gave a message about connection aborted. As soon as it does it again I'll write the correct message to the list. -- Anders -BEGIN GEEK CODE BLOCK- Version: 3.12 GCS/O d--@ s:+ a-- C++ UL+++$ P++ L+++ E- W+ N(+) o K? w O-- M- V PS+ PE@ Y+ PGP+ t 5 X R+ tv+ b++ DI+++ D+ G e- h !r y? --END GEEK CODE BLOCK-- PGPKey: http://pgp.mit.edu:11371/pks/lookup?op=getsearch=0x8BFECB41 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Failed connectionattempts
Hi, I have a server which has been running for about a year now. It started with kernel 2.4.19 and mysql 3.x it has since been continually upgraded so that it is now kernel 2.4.20 and mysql 4.0.13. The server is a Compaq server with dual Pentium II (Deschutes) 400MHz 512Kb cache CPUs, 320Mb RAM and SCSI drives. The OS is Gentoo Linux. From the beginning it has behaved strangely - connections to mysql (be that with the mysql textclient or from PHP) fails about 2 out of 3 times in periods. Some times there are no problems, other times it's almost impossible to connect. This behavior has been consistent from the start, so it has been a problem when running both mysql 3.x and 4.0.x. I have monitored the servers load and the loads are the same in the periods when it fails as in the periods when it doesn't. I have tried monitoring the mysql logs, but no entries show up upon the failed connection attempts. No other services malfunctions in this way, or indeed at all on the server. I have run out of ideas on how to debug this problem, can anybody here help me? -- Anders -BEGIN GEEK CODE BLOCK- Version: 3.12 GCS/O d--@ s:+ a-- C++ UL+++$ P++ L+++ E- W+ N(+) o K? w O-- M- V PS+ PE@ Y+ PGP+ t 5 X R+ tv+ b++ DI+++ D+ G e- h !r y? --END GEEK CODE BLOCK-- PGPKey: http://pgp.mit.edu:11371/pks/lookup?op=getsearch=0x8BFECB41 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]