MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Jed Reynolds Date:January 6 2009 5:43pm
Subject:Re: long login times?
View as plain text  
Jim Ginn wrote:
> Jed:
>
> Are you using an in-network IP to access the database ie:
>
> 127.0.0.1
> 192.168.98.##
>
> or are you using a public IP or full domain name ie:
>
> DB001.MY-DOMAIN.COM
> ...
>   


A very reasonable question. I'm connecting using IP addresses.

$servers = array( '192.168.44.84','192.168.44.94','192.168.44.104' );
foreach( $servers as $server )
{
    $delta['connect_start'] = microtime( true );
    @$db->real_connect( $server, $user, "secret", $dbname );
    $delta['connect_end'] = microtime( true );
    $d = $delta['connect_end'] - $delta['connect_start'];
    if( $d > 0.5 ) error_log( "Login attempt took $d seconds" );
    if( mysqli_connect_error() ) error_log( "Login Timeout for $server" );
}


Thread
long login times?Jed Reynolds6 Jan
  • Re: long login times?Jim Ginn6 Jan
    • Re: long login times?Jed Reynolds6 Jan
      • Mysql Replication out of syncShain Miley9 Jan
  • Re: Mysql Replication out of syncJose Julian Buda9 Jan
    • Re: Mysql Replication out of syncShain Miley9 Jan