473,320 Members | 2,088 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

MySQL Redhat slow responding to connections

I have installed MySQL 3.53 on two RH7.3 and one RH9.0 boxes.
On one of the 7.3 and the 9.0 box, when I try to connect remotely, it
takes about 45 seconds to connect, whereas the other 7.3 box connects
almost immediately.

The fast box has standard install of 7.3 with tomcat added.
The 9.0 box is straight RH9.0 standard install.

I can't find anything in common between the slow boxes, but not on the
fast one.

Any ideas what could be causing this?

Brian Andrus
batman(at)thundermail.com
Jul 19 '05 #1
6 2570
Your problem is with DNS on the RH9.0 Server. Once you fix that it'll be
lighting

Let me know if you can't work it out

Thanks

Aaron
"Brian Andrus" <ba****@thundermail.com> wrote in message
news:ae**************************@posting.google.c om...
I have installed MySQL 3.53 on two RH7.3 and one RH9.0 boxes.
On one of the 7.3 and the 9.0 box, when I try to connect remotely, it
takes about 45 seconds to connect, whereas the other 7.3 box connects
almost immediately.

The fast box has standard install of 7.3 with tomcat added.
The 9.0 box is straight RH9.0 standard install.

I can't find anything in common between the slow boxes, but not on the
fast one.

Any ideas what could be causing this?

Brian Andrus
batman(at)thundermail.com

Jul 19 '05 #2
Your problem is with DNS on the RH9.0 Server. Once you fix that it'll be
lighting

Let me know if you can't work it out

Thanks

Aaron
"Brian Andrus" <ba****@thundermail.com> wrote in message
news:ae**************************@posting.google.c om...
I have installed MySQL 3.53 on two RH7.3 and one RH9.0 boxes.
On one of the 7.3 and the 9.0 box, when I try to connect remotely, it
takes about 45 seconds to connect, whereas the other 7.3 box connects
almost immediately.

The fast box has standard install of 7.3 with tomcat added.
The 9.0 box is straight RH9.0 standard install.

I can't find anything in common between the slow boxes, but not on the
fast one.

Any ideas what could be causing this?

Brian Andrus
batman(at)thundermail.com

Jul 19 '05 #3
Well, I had DNS set to the internal IP on the boxes on the slow ones.
I changed it to the external IP (which is what the fast one had) and
everything is fast. I don't quite understand why, as I do have reverse
lookup enabled and running for the internal IPs. Maybe because they
were short names instead of fqdn.

Thanks for pointing me in that direction!
Brian Andrus
batman(at)thundermail.com

"Aaron Miles" <aa***@noSpammerPLEASEqbdthebookshop.com> wrote in message news:<1A******************@nasal.pacific.net.au>.. .
Your problem is with DNS on the RH9.0 Server. Once you fix that it'll be
lighting

Let me know if you can't work it out

Thanks

Aaron
"Brian Andrus" <ba****@thundermail.com> wrote in message
news:ae**************************@posting.google.c om...
I have installed MySQL 3.53 on two RH7.3 and one RH9.0 boxes.
On one of the 7.3 and the 9.0 box, when I try to connect remotely, it
takes about 45 seconds to connect, whereas the other 7.3 box connects
almost immediately.

The fast box has standard install of 7.3 with tomcat added.
The 9.0 box is straight RH9.0 standard install.

I can't find anything in common between the slow boxes, but not on the
fast one.

Any ideas what could be causing this?

Brian Andrus
batman(at)thundermail.com

Jul 19 '05 #4
Well, I had DNS set to the internal IP on the boxes on the slow ones.
I changed it to the external IP (which is what the fast one had) and
everything is fast. I don't quite understand why, as I do have reverse
lookup enabled and running for the internal IPs. Maybe because they
were short names instead of fqdn.

Thanks for pointing me in that direction!
Brian Andrus
batman(at)thundermail.com

"Aaron Miles" <aa***@noSpammerPLEASEqbdthebookshop.com> wrote in message news:<1A******************@nasal.pacific.net.au>.. .
Your problem is with DNS on the RH9.0 Server. Once you fix that it'll be
lighting

Let me know if you can't work it out

Thanks

Aaron
"Brian Andrus" <ba****@thundermail.com> wrote in message
news:ae**************************@posting.google.c om...
I have installed MySQL 3.53 on two RH7.3 and one RH9.0 boxes.
On one of the 7.3 and the 9.0 box, when I try to connect remotely, it
takes about 45 seconds to connect, whereas the other 7.3 box connects
almost immediately.

The fast box has standard install of 7.3 with tomcat added.
The 9.0 box is straight RH9.0 standard install.

I can't find anything in common between the slow boxes, but not on the
fast one.

Any ideas what could be causing this?

Brian Andrus
batman(at)thundermail.com

Jul 19 '05 #5
No worries Brian ,, We all need help from time to time and I had this
problem and someone helped me out ..

So it's good carma to help someone with the same problem.

Thanks

Aaron

"Brian Andrus" <ba****@thundermail.com> wrote in message
news:ae**************************@posting.google.c om...
Well, I had DNS set to the internal IP on the boxes on the slow ones.
I changed it to the external IP (which is what the fast one had) and
everything is fast. I don't quite understand why, as I do have reverse
lookup enabled and running for the internal IPs. Maybe because they
were short names instead of fqdn.

Thanks for pointing me in that direction!
Brian Andrus
batman(at)thundermail.com

"Aaron Miles" <aa***@noSpammerPLEASEqbdthebookshop.com> wrote in message

news:<1A******************@nasal.pacific.net.au>.. .
Your problem is with DNS on the RH9.0 Server. Once you fix that it'll be
lighting

Let me know if you can't work it out

Thanks

Aaron
"Brian Andrus" <ba****@thundermail.com> wrote in message
news:ae**************************@posting.google.c om...
I have installed MySQL 3.53 on two RH7.3 and one RH9.0 boxes.
On one of the 7.3 and the 9.0 box, when I try to connect remotely, it
takes about 45 seconds to connect, whereas the other 7.3 box connects
almost immediately.

The fast box has standard install of 7.3 with tomcat added.
The 9.0 box is straight RH9.0 standard install.

I can't find anything in common between the slow boxes, but not on the
fast one.

Any ideas what could be causing this?

Brian Andrus
batman(at)thundermail.com

Jul 19 '05 #6
No worries Brian ,, We all need help from time to time and I had this
problem and someone helped me out ..

So it's good carma to help someone with the same problem.

Thanks

Aaron

"Brian Andrus" <ba****@thundermail.com> wrote in message
news:ae**************************@posting.google.c om...
Well, I had DNS set to the internal IP on the boxes on the slow ones.
I changed it to the external IP (which is what the fast one had) and
everything is fast. I don't quite understand why, as I do have reverse
lookup enabled and running for the internal IPs. Maybe because they
were short names instead of fqdn.

Thanks for pointing me in that direction!
Brian Andrus
batman(at)thundermail.com

"Aaron Miles" <aa***@noSpammerPLEASEqbdthebookshop.com> wrote in message

news:<1A******************@nasal.pacific.net.au>.. .
Your problem is with DNS on the RH9.0 Server. Once you fix that it'll be
lighting

Let me know if you can't work it out

Thanks

Aaron
"Brian Andrus" <ba****@thundermail.com> wrote in message
news:ae**************************@posting.google.c om...
I have installed MySQL 3.53 on two RH7.3 and one RH9.0 boxes.
On one of the 7.3 and the 9.0 box, when I try to connect remotely, it
takes about 45 seconds to connect, whereas the other 7.3 box connects
almost immediately.

The fast box has standard install of 7.3 with tomcat added.
The 9.0 box is straight RH9.0 standard install.

I can't find anything in common between the slow boxes, but not on the
fast one.

Any ideas what could be causing this?

Brian Andrus
batman(at)thundermail.com

Jul 19 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: John Clegg | last post by:
Hi Environment: RedHat 7.2 MySQL: v 3.23.41 Connections: Perl DBI I have a question if there is any features in mysql 3 /4 to support connection priorisation. Currently we are running some...
0
by: Eric Raymond | last post by:
When installing the rpms (or the tar file) onto Red Hat Enteprise Linux AS Beta 1 (Taroon), we get the follwing error: Installing all prepared tables /usr/bin/mysql_install_db: line 1: 7690...
0
by: Chris Moy | last post by:
SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `<' and `>'). SEND-PR: From: moyc To:...
0
by: Brian Andrus | last post by:
I have installed MySQL 3.53 on two RH7.3 and one RH9.0 boxes. On one of the 7.3 and the 9.0 box, when I try to connect remotely, it takes about 45 seconds to connect, whereas the other 7.3 box...
0
by: Plymouth Acclaim | last post by:
Hi guys, We have a problem with Dual AMD64 Opteron/MySQL 4.0.18/Mandrake 10 for a very high volume site. We are evaluating the performance on our new server AMD64 and it seems it's slow compared...
1
by: jlee | last post by:
I'm pretty much a newbie on mysql, and I need some help. I am running mysql Ver 12.22 Distrib 4.0.24, for portbld-freebsd5.4 (i386) on a server hosting an active website. The site's developer...
1
by: marcfischman | last post by:
Please help. I have a website running on a linux/apache/mysql/php server. I receive about 8,000-10,000 visitors a day with about 200,000 to 300,000 page views. The server is a RedHat Linux...
1
by: Ike | last post by:
Recently, I began using a different MySQL verver (i.e. different machine as well as different version#, going from 4.12a to 4.1.9 max). The following query used to work: select firstname,...
2
by: mezise | last post by:
Posted by Pratchaya: ------------------------------------------------------ MySQL Slow Log ERROR In my.cnf i add these lines ####### log-bin log-slow-queries = /var/log/mysqld-slow.log
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.