Re: Slow connections & Select database
- From: "Ian Michael Gumby" <im_gumby@xxxxxxxxxxx>
- Date: Wed, 04 Apr 2007 17:05:18 +0000
Sorry to top post...
rDNS or reverse DNS shouldn't have any impact on this.
If you want to check for network latency, you can do a series of ping(s) from the client to the server and if you want to get fancy, do a traceroute as well. This will not only tell you the network latency but also the path from the client to the server.
Since Rosie indicated that the process is running slow on the server as well as on the client, then we can be sure that its not the network.
Had the speed changed when going from shared memory to tcp/ip, we could have suspected that there was something like a firewall on the server which may be causing some of the problems.
If we're going to focus on the server, then you will want to run top -s1. This will indicate the current system load updated every second. (You could also run an xload too for a graphical comparision.)
Now the next set of questions. SunOs 5.7 is which flavor of Solaris? How backdated it that?
Then look at the IDS config.
The point is to issolate the trouble by ruling out what we know from what we don't know.
Since we've ruled out the network, the client, we need to focus on the server.
How does Rosie handle authentication? LDAP? PAM? NIS/YP? or std Unix authentication?
Is dbaccess slow for everyone or just this specific user?
(Simple test, create an account that's on the server but not in LDAP or NIS, assuming that they are using LDAP or NIS.) This would indicate that there was some sort of delay in authentication.
Did Rosie try a different database?
Since dbaccess comes up fast, then slows down when connecting to a specific database, what happens when she connects to a different database? If it also slows down, then we have to look at the server's configuration vs the system's configuration.
Does that make sense?
-G
From: Clive Eisen <clive@xxxxxxxxxxxxxxx>
Rosie Rhodes wrote:
> Hi,
> we are having problems with slow connections on our informix database.
> It is IDS Version 9.21.UC1, running on SunOS 5.7
> It takes a long time to connect from clients but also when running dbaccess
> on the actual database server.
>
> The usual scenario seems to be -
> Run 'dbaccess' on its own - starts quickly
> Run 'dbaccess dbname' - very slow
> Once in dbaccess, trying to Select Database - very slow
> First connection to any database - very slow
> All subsequent connections to databases - fine
>
> I've tried both shm connections and tcp connections on the db server, and
> the shm are a bit slow (few secs) but tcp are much worse (can be over a
> minute).
> The load averages on the server are small (round about 0.15 at the most)
> and it is not short of memory.
>
> I have tried putting the ip address in the sqlhosts instead of the hostname
> (we already
> did this on the client machines) but it seemed to make no difference.
> My colleague checked dns lookup times and they seem fine.
>
Did s/he check reverse DNS?
--
Clive
_______________________________________________
Informix-list mailing list
Informix-list@xxxxxxxx
http://www.iiug.org/mailman/listinfo/informix-list
_________________________________________________________________
The average US Credit Score is 675. The cost to see yours: $0 by Experian. http://www.freecreditreport.com/pm/default.aspx?sc=660600&bcd=EMAILFOOTERAVERAGE
.
- References:
- Re: Slow connections & Select database
- From: Clive Eisen
- Re: Slow connections & Select database
- Prev by Date: Re: Problem with ER : cdr sync replicate
- Next by Date: Re: Slow connections & Select database
- Previous by thread: Re: Slow connections & Select database
- Next by thread: Re: Slow connections & Select database
- Index(es):
Relevant Pages
|
