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
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
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
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
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,
: 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
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