Return-Path: 
 <users-return-111150-apmail-httpd-users-archive=httpd.apache.org@httpd.apache.org>
X-Original-To: apmail-httpd-users-archive@www.apache.org
Delivered-To: apmail-httpd-users-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id D6EC917436
	for <apmail-httpd-users-archive@www.apache.org>;
 Tue, 31 Mar 2015 06:18:47 +0000 (UTC)
Received: (qmail 71154 invoked by uid 500); 31 Mar 2015 06:18:41 -0000
Delivered-To: apmail-httpd-users-archive@httpd.apache.org
Received: (qmail 71124 invoked by uid 500); 31 Mar 2015 06:18:41 -0000
Mailing-List: contact users-help@httpd.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@httpd.apache.org
list-help: <mailto:users-help@httpd.apache.org>
list-unsubscribe: <mailto:users-unsubscribe@httpd.apache.org>
List-Post: <mailto:users@httpd.apache.org>
List-Id: <users.httpd.apache.org>
Delivered-To: mailing list users@httpd.apache.org
Received: (qmail 71109 invoked by uid 99); 31 Mar 2015 06:18:41 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 Mar 2015 06:18:41 +0000
X-ASF-Spam-Status: No, hits=-0.0 required=5.0
	tests=RCVD_IN_DNSWL_NONE,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: local policy)
Received: from [64.26.60.147] (HELO smtpauth05.mfg.siteprotect.com)
 (64.26.60.147)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 Mar 2015 06:18:35 +0000
Received: from [192.168.1.111] (unknown [24.189.128.53])
	(Authenticated sender: ethanr@hygeiabiomedical.com)
	by smtpauth05.mfg.siteprotect.com (Postfix) with ESMTPA id 6B2461047378F
	for <users@httpd.apache.org>; Tue, 31 Mar 2015 01:18:13 -0500 (CDT)
Message-ID: <551A3C25.50004@hygeiabiomedical.com>
Date: Tue, 31 Mar 2015 02:18:13 -0400
From: "Ethan Rosenberg, PhD" <erosenberg@hygeiabiomedical.com>
Reply-To: erosenberg@hygeiabiomedical.com, users@httpd.apache.org
Organization: Hygeia Biomedical Research, Inc.
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:31.0) Gecko/20100101 Thunderbird/31.4.0
MIME-Version: 1.0
To: users@httpd.apache.org
References: <5518C838.9000608@hygeiabiomedical.com>
 <CACL4V1b4zd6V2f6wnwvyL8En5GH5Y=qV4q0fnQ=2PiSqEecbtw@mail.gmail.com>
In-Reply-To: 
 <CACL4V1b4zd6V2f6wnwvyL8En5GH5Y=qV4q0fnQ=2PiSqEecbtw@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
X-CTCH-Spam: Unknown
X-CTCH-RefID: 
 str=0001.0A020204.551A3C26.00D7,ss=1,re=0.001,recu=0.000,reip=0.000,cl=1,cld=1,fgs=0
X-Virus-Checked: Checked by ClamAV on apache.org
Subject: Re: [users@httpd] Apache is Slow

On 03/30/2015 03:26 AM, Marcos Almeida Azevedo wrote:
>
>
> On Mon, Mar 30, 2015 at 11:51 AM, Ethan Rosenberg <erosenberg@hygeiabiomedical.com
> <mailto:erosenberg@hygeiabiomedical.com>> wrote:
>
>     Dear List -
>
>     When I call another page in PHP, Apache can take 5 to 10 minutes to open the page.
>
>     Example:
>
>              <script type="text/javascript">
>              <!--
>                      window.location.assign("http:/__/localhost/HandleWeight.php
>     <http://localhost/HandleWeight.php>");
>              //-->\
>             </script>
>
>     can take 5 - 10 min.
>
>
> Would it be possible that the PHP script is the one slow? Could you measure the execution time of
> the script?
>
>
>      > root@meow:/var/www# /usr/sbin/apache2 -V
>      > Config variable ${APACHE_LOCK_DIR} is not defined
>      > --> Mutex file:${APACHE_LOCK_DIR} default
>      >
>      > Config variable ${APACHE_PID_FILE} is not defined
>      > --> # PidFile: The file in which the server should record its
>      > process
>      > # identification number when it starts.
>      > # This needs to be set in /etc/apache2/envvars
>      > #
>      > PidFile ${APACHE_PID_FILE}
>      > /etc/apache2/envvars
>      > --> export APACHE_PID_FILE=/var/run/__apache2/apache2$SUFFIX.pid
>      >
>      >
>      > Config variable ${APACHE_RUN_USER} is not defined
>      > Config variable ${APACHE_RUN_GROUP} is not defined
>      > --> # These need to be set in /etc/apache2/envvars
>      > User ${APACHE_RUN_USER}
>      > Group ${APACHE_RUN_GROUP}
>      > /etc/apache2/envvars
>      > --> export APACHE_RUN_USER=www-data
>      > export APACHE_RUN_GROUP=www-data
>      >
>      >
>      > Config variable ${APACHE_LOG_DIR} is not defined  >> this error
>      > message appears 5 times??
>      > --> ErrorLog ${APACHE_LOG_DIR}/error.log
>      >
>      >
>      > AH00526: Syntax error on line 74 of /etc/apache2/apache2.conf
>      > --> I tried to strip out the comments, and came up with less than
>      > 74 lines.
>      >
>      >
>      > Invalid Mutex directory in argument file:${APACHE_LOCK_DIR}
>      > --> See above.
>      >
>     root@meow:/home/ethan/BluBev# ps -A |grep apache2
>     11972 ?        00:00:30 apache2
>     22196 ?        00:00:00 apache2
>     22197 ?        00:00:00 apache2
>     22198 ?        00:00:00 apache2
>     22199 ?        00:00:00 apache2
>     22200 ?        00:00:00 apache2
>
>     Totally confused.
>
>     TIA
>
>     Ethan
>
---
Marcos -

Thanks.

  Would it be possible that the PHP script is the one slow? Could you measure the execution time of 
the script?

Great idea.  How??

TIA

Ethan

Some more info....

Changed the host in the connect

$cxn = mysqli_connect($host,$user,$password);

$host="127.0.1.1";

Now get an error...

Warning: mysqli_connect(): (HY000/2003): Can't connect to MySQL server on '127.0.1.1' (111) in 
/var/www/HandleWeight.php on line 56
Connect Error (2003) Can't connect to MySQL server on '127.0.1.1' (111)

Also ...

root@meow:/home/ethan/BluBev# netstat -ln | grep mysql
unix  2      [ ACC ]     STREAM     LISTENING     10347    /var/run/mysqld/mysqld.sock


I hope this clears the waters and does not muddy them more.

Again

TIA

Ethan



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



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