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]
