You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@httpd.apache.org by Oscar Ithier <it...@gmail.com> on 2016/06/02 16:37:21 UTC

[users@httpd] Apache response time slow

I am using Apache 2.2.22(Unix), Server port 80, Protocol HTTP/1.0 and
Sybase as database.
The Http response time is above 40 seconds, this is to slow for my users.

I don't know when the problem start, but it was fine for the last 5 years.

What can I do to fix the problem.

Re: [users@httpd] RE: [Non-DoD Source] Re: [users@httpd] Apache response time slow

Posted by Mike Rumph <mi...@oracle.com>.
On 6/6/2016 4:13 AM, ithier.ctr@jdi.socom.mil wrote:
> Mike
>
> I ran the Perl program from the shell and took the same time of 40 seconds
>
> Oscar
>
Hello Oscar,

Okay.  So the high response time seems to be independent of the Apache 
HTTP Server.
You may want to continue your inquiry to Perl:
- https://www.perl.org/community.html

Or to Sybase (SAP):
- https://websmp110.sap-ag.de/sybase/support

Thanks,

Mike

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org


[users@httpd] RE: [Non-DoD Source] Re: [users@httpd] Apache response time slow

Posted by it...@jdi.socom.mil.
Mike

I ran the Perl program from the shell and took the same time of 40 seconds

Oscar
-----Original Message-----
From: Mike Rumph [mailto:mike.rumph@oracle.com] 
Sent: Thursday, June 02, 2016 9:09 PM
To: users@httpd.apache.org
Subject: [Non-DoD Source] Re: [users@httpd] Apache response time slow


On 6/2/2016 11:25 AM, Oscar Ithier wrote:
> The typical response was very fast (on miliseconds).
>
> The access to the database is is part of the connection string on the 
> program.
>
> Apache authenticate the user access to the directories that containts 
> the perl programs, using the httpd.conf and the htgroup and htpasswd 
> file.
> ex.
> <Directory /usr/local/apache2/cgi-bin/indocadmin>
> AllowOverride None
> AuthName "INDOC"
> AuthType Basic
> AuthUserFile /usr/local/apache2/conf/.htpasswd AuthGroupFile 
> /usr/local/apache2/conf/.htgroup <LIMIT GET POST PUT> require group 
> INDOCSEC order deny,allow deny from all satisfy any </limit> 
> </directory>
>
> initialy i get the log message:
>     POST HTTP/1.1 401
>
> then is enter user id and password and click enter.
>
> then i get a delay of 40 seconds or more and the log message:
>   POST HTTP/1.1 200
> indicating OK
>
> No one has changed the Sybase database, i have the only unix 
> workstation, that can telnet to the Database Server.  We are using an 
> intranet classified network.  The Apache, Sybase and the programs are 
> all in the same server.
>
Hello Oscar,

I don't have much idea why you are seeing such a big difference in response time.
But I do have some further questions that may be useful to you or to someone else on the mailing list that may have a clue what is happening.

First of all, logic would seem to indicate that if we are seeing this big of change in the result, then something must have changed in the scenario.
A suggested task would be to try to figure out what is different.
Could there be any new programs running on your system that might be causing contention of some sort?

If you are using an intranet classified network, does this mean that you are using network protocols other than TCP/IP?

Since you are using perl scripts, are you also using mod_perl?

We would like to discern which part of the request/response round trip is using up the extra time.
Is the time lost in the Apache httpd server, mod_perl, the perl script or in the access to the database?
Would it be possible to run your perl scripts directly from a shell and compare the response time to the overall response time through the httpd server?

Thanks,

Mike

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org


Re: [users@httpd] Apache response time slow

Posted by Mike Rumph <mi...@oracle.com>.
On 6/2/2016 11:25 AM, Oscar Ithier wrote:
> The typical response was very fast (on miliseconds).
>
> The access to the database is is part of the connection string on the 
> program.
>
> Apache authenticate the user access to the directories that containts 
> the perl programs, using the httpd.conf and the htgroup and 
> htpasswd file.
> ex.
> <Directory /usr/local/apache2/cgi-bin/indocadmin>
> AllowOverride None
> AuthName "INDOC"
> AuthType Basic
> AuthUserFile /usr/local/apache2/conf/.htpasswd
> AuthGroupFile /usr/local/apache2/conf/.htgroup
> <LIMIT GET POST PUT>
> require group INDOCSEC
> order deny,allow
> deny from all
> satisfy any
> </limit>
> </directory>
>
> initialy i get the log message:
>     POST HTTP/1.1 401
>
> then is enter user id and password and click enter.
>
> then i get a delay of 40 seconds or more and the log message:
>   POST HTTP/1.1 200
> indicating OK
>
> No one has changed the Sybase database, i have the only unix 
> workstation, that can telnet to the Database Server.  We are using an 
> intranet classified network.  The Apache, Sybase and the programs are 
> all in the same server.
>
Hello Oscar,

I don't have much idea why you are seeing such a big difference in 
response time.
But I do have some further questions that may be useful to you or to 
someone else on the mailing list that may have a clue what is happening.

First of all, logic would seem to indicate that if we are seeing this 
big of change in the result, then something must have changed in the 
scenario.
A suggested task would be to try to figure out what is different.
Could there be any new programs running on your system that might be 
causing contention of some sort?

If you are using an intranet classified network, does this mean that you 
are using network protocols other than TCP/IP?

Since you are using perl scripts, are you also using mod_perl?

We would like to discern which part of the request/response round trip 
is using up the extra time.
Is the time lost in the Apache httpd server, mod_perl, the perl script 
or in the access to the database?
Would it be possible to run your perl scripts directly from a shell and 
compare the response time to the overall response time through the httpd 
server?

Thanks,

Mike

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org


Re: [users@httpd] Apache response time slow

Posted by Oscar Ithier <it...@gmail.com>.
The typical response was very fast (on miliseconds).

The access to the database is is part of the connection string on the
program.

Apache authenticate the user access to the directories that containts the
perl programs, using the httpd.conf and the htgroup and htpasswd file.
ex.
<Directory /usr/local/apache2/cgi-bin/indocadmin>
AllowOverride None
AuthName "INDOC"
AuthType Basic
AuthUserFile /usr/local/apache2/conf/.htpasswd
AuthGroupFile /usr/local/apache2/conf/.htgroup
<LIMIT GET POST PUT>
require group INDOCSEC
order deny,allow
deny from all
satisfy any
</limit>
</directory>

initialy i get the log message:
    POST HTTP/1.1 401

then is enter user id and password and click enter.

then i get a delay of 40 seconds or more and the log message:
  POST HTTP/1.1 200
indicating OK

No one has changed the Sybase database, i have the only unix workstation,
that can telnet to the Database Server.  We are using an intranet
classified network.  The Apache, Sybase and the programs are all in the
same server.



On Thu, Jun 2, 2016 at 12:51 PM, Mike Rumph <mi...@oracle.com> wrote:

> On 6/2/2016 9:37 AM, Oscar Ithier wrote:
>
>> I am using Apache 2.2.22(Unix), Server port 80, Protocol HTTP/1.0 and
>> Sybase as database.
>> The Http response time is above 40 seconds, this is to slow for my users.
>>
>> I don't know when the problem start, but it was fine for the last 5 years.
>>
>> What can I do to fix the problem.
>>
> Hello Oscar,
>
> You can begin by providing more details.
> What was the typical response time for the last 5 years?
> How is the server configured?
>    - Configuration file contents would be helpful here.
>    - What MPM is being used?
>     - Is Apache httpd being used as a proxy to a Sybase server?
> What do you see in the access log?
>     - This may help to determine if the delay is in Apache httpd or in the
> Sybase server?
> Has something changed in the Sybase database or in how it is accessed?
>
> Thanks,
>
> Mike
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
> For additional commands, e-mail: users-help@httpd.apache.org
>
>

Re: [users@httpd] Apache response time slow

Posted by Mike Rumph <mi...@oracle.com>.
On 6/2/2016 9:37 AM, Oscar Ithier wrote:
> I am using Apache 2.2.22(Unix), Server port 80, Protocol HTTP/1.0 and 
> Sybase as database.
> The Http response time is above 40 seconds, this is to slow for my users.
>
> I don't know when the problem start, but it was fine for the last 5 
> years.
>
> What can I do to fix the problem.
Hello Oscar,

You can begin by providing more details.
What was the typical response time for the last 5 years?
How is the server configured?
    - Configuration file contents would be helpful here.
    - What MPM is being used?
     - Is Apache httpd being used as a proxy to a Sybase server?
What do you see in the access log?
     - This may help to determine if the delay is in Apache httpd or in 
the Sybase server?
Has something changed in the Sybase database or in how it is accessed?

Thanks,

Mike


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org


Re: [users@httpd] Apache response time slow

Posted by "D'Arcy J.M. Cain" <da...@Vex.Net>.
On Thu, 2 Jun 2016 12:37:21 -0400
Oscar Ithier <it...@gmail.com> wrote:
> I am using Apache 2.2.22(Unix), Server port 80, Protocol HTTP/1.0 and
> Sybase as database.
> The Http response time is above 40 seconds, this is to slow for my
> users.
> 
> I don't know when the problem start, but it was fine for the last 5
> years.
> 
> What can I do to fix the problem.

Give us more detail.

One possibility, are you running PHP (e.g. Wordpress) sites?  I often
find that I have to clean up some nasty hacked sites.  You may have to
hire someone to clean up your system if you can't do it yourself but
google around for some hints.

-- 
D'Arcy J.M. Cain
System Administrator, Vex.Net
http://www.Vex.Net/ IM:darcy@Vex.Net
VoIP: sip:darcy@Vex.Net

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org