Connection speed
Hi all, I have a MySQL 4.1 installed on a RedHat 9 machine with two interfaces. One of them connects to my local network and the other connects to the internet. My problem is that it takes very long time (5-10 seconds or more) to connect to the MySQL from the local network. It takes long time to connect from the internet as well, but it is still faster then from the local network. (Weird, isn't it?) Is there any chance to speed up the connection, because this is a critical issue to me. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connection speed
Sounds like a DNS problem to me. Daniel Kiss wrote: Hi all, I have a MySQL 4.1 installed on a RedHat 9 machine with two interfaces. One of them connects to my local network and the other connects to the internet. My problem is that it takes very long time (5-10 seconds or more) to connect to the MySQL from the local network. It takes long time to connect from the internet as well, but it is still faster then from the local network. (Weird, isn't it?) Is there any chance to speed up the connection, because this is a critical issue to me. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connection speed
It is definitely not a DNS problem. I use IP addresses. Any other idea? Thanks Sounds like a DNS problem to me. Daniel Kiss wrote: Hi all, I have a MySQL 4.1 installed on a RedHat 9 machine with two interfaces. One of them connects to my local network and the other connects to the internet. My problem is that it takes very long time (5-10 seconds or more) to connect to the MySQL from the local network. It takes long time to connect from the internet as well, but it is still faster then from the local network. (Weird, isn't it?) Is there any chance to speed up the connection, because this is a critical issue to me. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connection speed
Try traceroute to make sure it's not a routing problem. Try netstat, or your platform's equivalent, to see if you are getting errors. You should do that on both the client and the server. Check how busy your server is, maybe there is something going on there. On Thursday, November 6, 2003, at 09:37 AM, Daniel Kiss wrote: It is definitely not a DNS problem. I use IP addresses. Any other idea? Thanks -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connection speed
On Thu, Nov 06, 2003 at 02:37:05PM +, Daniel Kiss wrote: It is definitely not a DNS problem. I use IP addresses. Any other idea? Reverse DNS. The server is lookup up the client's name unless you've used skip-name-resolve. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 53 days, processed 2,000,684,535 queries (431/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Connection speed
I think my mysql is resolving host names, and I would prefer it to not, where do I set skip-name-resolve to prevent it? Thanks. -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: Thursday, November 06, 2003 8:43 AM To: Daniel Kiss Cc: [EMAIL PROTECTED] Subject: Re: Connection speed On Thu, Nov 06, 2003 at 02:37:05PM +, Daniel Kiss wrote: It is definitely not a DNS problem. I use IP addresses. Any other idea? Reverse DNS. The server is lookup up the client's name unless you've used skip-name-resolve. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 53 days, processed 2,000,684,535 queries (431/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connection speed
On Thu, Nov 06, 2003 at 09:23:50AM -0700, Nihal wrote: I think my mysql is resolving host names, and I would prefer it to not, where do I set skip-name-resolve to prevent it? In the [mysqld] section of my.cnf. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 53 days, processed 2,004,096,100 queries (431/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
