Connection speed

2003-11-06 Thread Daniel Kiss
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

Re: Connection speed

2003-11-06 Thread gerald_clark
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

Re: Connection speed

2003-11-06 Thread Daniel Kiss
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

Re: Connection speed

2003-11-06 Thread Brent Baisley
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

Re: Connection speed

2003-11-06 Thread Jeremy Zawodny
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,

RE: Connection speed

2003-11-06 Thread Nihal
: 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

Re: Connection speed

2003-11-06 Thread Jeremy Zawodny
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