httpd-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ethan Rosenberg, PhD" <erosenb...@hygeiabiomedical.com>
Subject Re: [users@httpd] Apache is Slow
Date Tue, 31 Mar 2015 06:18:13 GMT
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


Mime
View raw message