Yep - both the Win2k box and Linux box now identify each other by IP (access
control and any host references in code) - but the problem persists.
And yep again, I agree that the presence of windows is the other variable!
However, I don't see why it would be so slow to connect! Perhaps it's a
peculiarity of the MySQL 5 windows build currently available - but then I
was hoping someone else would have seen the same issue!
I'm going to try building MySQL 5 on another linux box at some point (then I
can throw a backup of the database on there and try it), but would really
like to keep it installed on Windows at the moment - because it's more
convenient to debug (and restart)!
Cheers,
Matt
-Original Message-
From: [EMAIL PROTECTED] [mailto:mysql-list-
[EMAIL PROTECTED]
Sent: 15 April 2004 20:29
To: Matt Chatterley
Subject: Re: Slow Connection from PHP to MySQL 5.0
do you have (mysql) access control on the mysql5 box that's based on
hostname, rather than ipnumber? if so, how quickly does the
inverse-map address of the linux box resolve?
from a testing perspective, you have two variables with your setup.
the first is mysql5 (vs. 4) but you also have windoz vs unix. part
of the issue may simply be that windoz is that much slower setting up
the connection.
-- Original Message --
From: Matt Chatterley [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date: Thursday, April 15, 2004 07:58:20 PM +0100
Subject: Slow Connection from PHP to MySQL 5.0
Hi Folks.
I've seen similar questions asked both here, and via a google
search - but I haven't found an answer which has helped yet - so
heres hoping!!
I run a Linux webserver which has PHP 4 installed, and am currently
prototyping a design using MySQL 5.0-alpha on Windows 2K
professional. The two servers are on different subnets of a LAN,
but are able to talk to each other unrestricted (all TCP services I
have tried work perfectly, e.g. SMTP, FTP).
The problem is that connections from PHP to MySQL seem to take 4-5
seconds (after which any queries within the connection go through
in normal lengths of time - only the connection time itself is
long). Although I have a fully functional internal DNS server, I
thought name resolution might be an issue. I amended my PHP pages
(they inherit a global 'data connection' object which is used as a
wrapper) to connect to the Win2k box by IP address - and the
problem persists.
Has anyone else encountered this, and are there any ideas?
Connections from the same Linux box with PHP to another Linux box
on the same subnet as the Win2k box running MySQL 4 work perfectly
- so is it possible this is a MySQL 5 issue? I am using the 'old
connections' flag (but have tried both with it off and on, since I
am not actually using a password for the connection at present).
Any suggestions will be most gratefully received!
Cheers,
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
-- End Original Message --
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]