Re: Very slow connection times.

[Sinisa Milivojevic <sinisa@xxxxxxxxx>]

Paul Coleman writes:
 > I am running mysql version 3.23.35 on a linux platform.
 > The hardware platform is a PIII 700 with 500Mb of ram and a fast SCSI drive.
 > The server is currently supporting about 200 concurrent connections, with a
 > view to up this to a couple of thousand.
 > 
 > My problem is the time it takes to make a connection to the server from the
 > network. This can be a matter of minutes. Connections on the local machine
 > are not a problem, and once connected query speeds are fine.
 > 
 > The max_connections variable is set to 1000.
 > The load average on the machine is about around 0.5.
 > 
 > Any light anyone could shed on the problem would be greatly appreciated.
 > 


Hi!

Problem that you are describing stems from DNS problems.

Solution to it is described in our manual.


Regards,

Sinisa

      ____  __     _____   _____  ___     ==  MySQL AB
     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sinisa Milivojevic
    /*/ /*/ /*/   \*\_   |*|   |*||*|     mailto:sinisa@xxxxxxxxx
   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Larnaca, Cyprus
  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____
  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
             /*/             \*\                Developers Team

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread68843@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php