Re: Slow mysql connections

2008-08-13 Thread Doug Bridgens
Do you have any other services running on the server, such as mail or web? How long does it take to connect to those services ('telnet server 25', or telnet server 80')? What are you using to connect to mysql? how long does 'telnet server 3306' take (assuming you are on the default

Re: Slow mysql connections

2008-08-13 Thread Krishna Chandra Prajapati
On Wed, Aug 13, 2008 at 1:30 PM, Doug Bridgens [EMAIL PROTECTED] wrote: Do you have any other services running on the server, such as mail or web? How long does it take to connect to those services ('telnet server 25', or telnet server 80')? No What are you using to connect to mysql?

Re: Slow mysql connections

2008-08-13 Thread Xuekun Hu
You should run into out of memory scenaria. OS is keeping to free some memory that delay mysql connection. On 8/13/08, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote: On Wed, Aug 13, 2008 at 1:30 PM, Doug Bridgens [EMAIL PROTECTED] wrote: Do you have any other services running on the

Re: Slow mysql connections

2008-08-13 Thread rajlist
In infinite wisdom Krishna Chandra Prajapati [EMAIL PROTECTED] spoke thus: Hi all, Connecting to mysql server (Production) is taking 5 to 6 seconds. Production has 16Gb ram. Previously it was using only 6GB ram. The details are as follows. DNS looks fine. Is it that the database you are

Re: Slow mysql connections

2008-08-13 Thread Ananda Kumar
Hi Raj, In which path the trace file would be created. regards anandkl On 8/13/08, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: In infinite wisdom Krishna Chandra Prajapati [EMAIL PROTECTED] spoke thus: Hi all, Connecting to mysql server (Production) is taking 5 to 6 seconds.

Re: Slow mysql connections

2008-08-13 Thread Ananda Kumar
Thank u very much. regards anandkl On 8/13/08, Raj Shekhar [EMAIL PROTECTED] wrote: in infinite wisdom Ananda Kumar spoke thus On 08/13/2008 04:37 PM: Hi Raj, In which path the trace file would be created. In your current path itself. Or just do strace -o /tmp/mysql.strace

Re: Slow mysql connections

2008-08-13 Thread Raj Shekhar
in infinite wisdom Ananda Kumar spoke thus On 08/13/2008 04:37 PM: Hi Raj, In which path the trace file would be created. In your current path itself. Or just do strace -o /tmp/mysql.strace -T mysql -u root -h host -p The mysql -u root -h host -ppassword is the command which you

Slow mysql connections

2008-08-12 Thread Krishna Chandra Prajapati
Hi all, Connecting to mysql server (Production) is taking 5 to 6 seconds. Production has 16Gb ram. Previously it was using only 6GB ram. The details are as follows. DNS looks fine. free -m total used free sharedbuffers cached Mem: 15899 15877