LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (http://www.linuxquestions.org/questions/linux-server-73/)
-   -   PHP performance issues (http://www.linuxquestions.org/questions/linux-server-73/php-performance-issues-4175455087/)

sherinlist 03-22-2013 12:35 AM

PHP performance issues
 
Hi Guys,

I am stuck at an unusual issue.

Basically, this is the situation.

I am working for a hosting company.

We have a server management portal. The portal was coded many years back for php 4. When PHP 4 reached EOL, we checked whether it could be run in PHP 5 and we found that it could run in PHP 5. So it has been running fine in PHP 5 for past couple of months

In last week, we migrated this portal to a new server with SSD(solid state) hard disk.

Since the migration, PHP in this server management portal is taking too much time to complete execution.

I verified following.

1. it is not server load or short of any resources
2. it is not mysql which is creating bottleneck.
3. it is not apache version or php version or php modules or mysql version.
4. all other websites in the same server is working fine.
5. server management portal is working in our test environments with same softwares.

Now, I am going to upgrade kernel to see whether it is affecting.

I am not getting any clue about what could be any done further.

Could anyone provide any inputs or clues about what could be done to find out what is happening.

--
sherin

vishesh 03-22-2013 08:52 AM

Wheather Php is executing as DSO or cgi ?

Delay getting first byte of site ?

Delay in executing full page ?

Did you checked verified process blocking using vmstat command?

Thanks

sherinlist 03-22-2013 10:20 PM

Hi vishesh,

Thanks for looking into this.

>> Did you checked verified process blocking using vmstat command?

I shall check this.

Apart from that,

This is a cpanel server. I tried running PHP as both DSO and suPHP. It is currently running as suPHP. Changing to DSO didn't improve performance.

I managed to catch a PHP process in strace.

This is what I see. I will see that process is stuck with "read(5," for some time. After that, the process will run & I could see page loading in browser.

=========================
root@myserver[~/sherin]# strace -p $(lsof | grep user_name | egrep -v "mysql|log" | grep serverportal | awk '{print $2}')

Process 26398 attached - interrupt to quit
read(5, "\305\352K&Ne\257\230", 8) = 8
close(5) = 0
mlock(0x7e628f0, 24) = 0
mlock(0x7e63fc0, 10624) = 0
poll([{fd=4, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout)
write(4, "\27\0\0\0\3select * from topimage", 27) = 27
read(4, "\1\0\0\1\0039\0\0\2\3def\17user_name_serverportal\10to"..., 16384) = 249
poll([{fd=4, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout)
write(4, "*\0\0\0\3select * from mainlinks whe"..., 46) = 46
read(4, "\1\0\0\1\16?\0\0\2\3def\17user_name_serverportal\tma"..., 16384) = 5338
getcwd("/home/user_name/public_html/serverportal"..., 4096) = 34
lstat("/home", {st_mode=S_IFDIR|0711, st_size=4096, ...}) = 0
lstat("/home/user_name", {st_mode=S_IFDIR|0711, st_size=4096, ...}) = 0
lstat("/home/user_name/public_html", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0
lstat("/home/user_name/public_html/serverportal", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
lstat("/home/user_name/public_html/serverportal/serverlist.php", {st_mode=S_IFREG|0755, st_size=83269, ...}) = 0
open("/home/user_name/public_html/serverportal/serverlist.php", O_RDONLY) = 5

=========================

Any ideas about why the process spends time on "read(5," ?

--
sherin

sherinlist 03-23-2013 12:08 AM

Hi Vishesh,

There is no "Processes waiting for CPU" or no “blocked” processes.

===============================
r b swpd free buff cache si so bi bo in cs us sy id wa st
0 0 792 624488 604168 13266384 0 0 1 8 1 1 0 0 100 0 0
0 0 792 624488 604168 13266384 0 0 0 0 1028 252 0 0 100 0 0
0 0 792 624488 604168 13266384 0 0 0 0 1006 222 0 0 100 0 0
0 0 792 624620 604168 13266384 0 0 0 12 1016 254 0 0 100 0 0
0 0 792 624620 604168 13266384 0 0 0 132 1014 228 0 0 100 0 0
0 0 792 624620 604168 13266384 0 0 0 0 1020 248 0 0 100 0 0
0 0 792 624748 604168 13266384 0 0 0 0 1063 387 0 0 99 0 0
0 0 792 624508 604168 13266384 0 0 0 0 1089 313 0 0 99 0 0
0 0 792 624508 604168 13266384 0 0 0 480 1078 221 0 0 100 0 0
0 0 792 624508 604168 13266384 0 0 0 364 1026 254 0 0 100 0 0
0 0 792 624508 604168 13266384 0 0 0 0 1006 220 0 0 100 0 0
0 0 792 624556 604168 13266384 0 0 0 16 1004 251 0 0 100 0 0
0 0 792 624556 604168 13266384 0 0 0 0 1013 225 0 0 100 0 0
0 0 792 624556 604168 13266384 0 0 0 0 1013 290 0 0 100 0 0
0 0 792 619092 604168 13266384 0 0 0 344 1019 327 0 0 99 0 0
0 0 792 619280 604168 13266384 0 0 0 0 1004 238 0 0 100 0 0
0 0 792 619280 604168 13266384 0 0 0 0 1019 227 0 0 100 0 0
0 0 792 619404 604168 13266388 0 0 0 0 1004 234 0 0 100 0 0
0 0 792 619404 604168 13266388 0 0 0 40 1006 225 0 0 100 0 0
0 0 792 619404 604168 13266388 0 0 0 180 1017 254 0 0 100 0 0
0 0 792 619404 604168 13266388 0 0 0 0 1012 267 0 0 100 0 0
0 0 792 619404 604168 13266388 0 0 0 0 1004 236 0 0 100 0 0
0 0 792 619404 604168 13266388 0 0 0 0 1006 276 0 0 100 0 0
0 0 792 625472 604168 13266388 0 0 0 32 1024 297 0 0 100 0 0
0 0 792 624860 604168 13266388 0 0 0 212 1052 372 1 0 99 0 0
0 0 792 624852 604168 13266392 0 0 0 0 1018 314 0 0 99 0 0
0 0 792 624860 604168 13266392 0 0 0 0 1049 240 0 0 100 0 0
0 0 792 624868 604168 13266392 0 0 0 28 1033 307 0 0 100 0 0
===============================

However, I still see the same thing, the PHP process is waiting for a read to complete.

I could see following when PHP is waiting for completing execution.

=============
root@myserver [~]# strace -p $(lsof | grep user_name | egrep -v "mysql|log" | grep serverportal | awk '{print $2}')

Process 3581 attached - interrupt to quit
read(5,
==============

Then all of a sudden, it completes the process in a fraction of a second and I could see the page in browser.

At that time, I could see that the process is completed as below.

===============
root@myserver [~]# strace -p $(lsof | grep user_name | egrep -v "mysql|log" | grep serverportal | awk '{print $2}')

Process 3581 attached - interrupt to quit
read(5, "\325\t\224\215\315\223\376\334", 8) = 8
close(5) = 0
mlock(0x140d3fb0, 24) = 0
mlock(0x1424c350, 10624) = 0
poll([{fd=4, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout)
write(4, "\27\0\0\0\3select * from topimage", 27) = 27
read(4, "\1\0\0\1\0039\0\0\2\3def\17user_name_serverportal\10to"..., 16384) = 249
poll([{fd=4, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout)
write(4, "*\0\0\0\3select * from mainlinks whe"..., 46) = 46
read(4, "\1\0\0\1\16?\0\0\2\3def\17user_name_serverportal\tma"..., 16384) = 5338
getcwd("/home/user_name/public_html/serverportal"..., 4096) = 34
lstat("/home", {st_mode=S_IFDIR|0711, st_size=4096, ...}) = 0
lstat("/home/user_name", {st_mode=S_IFDIR|0711, st_size=4096, ...}) = 0
lstat("/home/user_name/public_html", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0
lstat("/home/user_name/public_html/serverportal", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
lstat("/home/user_name/public_html/serverportal/special_logins.php", {st_mode=S_IFREG|0600, st_size=9083, ...}) = 0
open("/home/user_name/public_html/serverportal/special_logins.php", O_RDONLY) = 5
fstat(5, {st_mode=S_IFREG|0600, st_size=9083, ...}) = 0
lseek(5, 0, SEEK_SET) = 0
fcntl(5, F_GETFL) = 0x8000 (flags O_RDONLY|O_LARGEFILE)
fstat(5, {st_mode=S_IFREG|0600, st_size=9083, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2b8c5b4d2000
lseek(5, 0, SEEK_CUR) = 0
open("/home/user_name/public_html/serverportal/special_logins.php", O_RDONLY) = 6
fstat(6, {st_mode=S_IFREG|0600, st_size=9083, ...}) = 0
mmap(NULL, 9083, PROT_READ, MAP_SHARED, 6, 0) = 0x2b8c5b4d3000

================


--
Thanks,
Sherin

vishesh 03-23-2013 11:45 AM

It seems that Apache MPM is taking time . Is there worker MPM in place . Also if you could share strace output by using option -c

Thanks

unSpawn 03-23-2013 12:38 PM

...additionally attach your strace right after you restarted the web server and not haphazardly during thread execution, use "-f -ff -v" as well and up the size of the printable string size with "-s". Also see Xdebug (KCacheGrind, FirePHP, XHProf, PHPeclipse, etc) wrt debugging / profiling?

sherinlist 03-23-2013 11:26 PM

Thanks unSpawn & vishesh.

I shall investigate further as per your suggestions.

--
sherin

sherinlist 03-31-2013 10:42 PM

Hi Guys,

I couldn't look into it in the past week.

>>It seems that Apache MPM is taking time . Is there worker MPM in place . Also if you could share strace output by using option -c

I agree with this. It may be Apache MPM that is taking time.

>> Is there worker MPM in plave

No, pefork MPM is used

root@myserver [~]# httpd -V
Server version: Apache/2.2.23 (Unix)
Server built: Feb 12 2013 23:18:28
Cpanel::Easy::Apache v3.18.0 rev9999
Server's Module Magic Number: 20051115:31
Server loaded: APR 1.4.6, APR-Util 1.4.1
Compiled using: APR 1.4.6, APR-Util 1.4.1
Architecture: 64-bit
Server MPM: Prefork
threaded: no
forked: yes (variable process count)

>>also if you could share strace output by using option -c

Please see below.


root@myserver [~]# strace -c -p $(lsof | grep user_name | egrep -v "mysql|log" | grep serverportal | awk '{print $2}')
Process 19003 attached - interrupt to quit
Process 19003 detached
% time seconds usecs/call calls errors syscall
------ ----------- ----------- --------- --------- ----------------
100.00 0.000013 7 2 munlock
0.00 0.000000 0 26 read
0.00 0.000000 0 19 write
0.00 0.000000 0 2 open
0.00 0.000000 0 5 close
0.00 0.000000 0 3 fstat
0.00 0.000000 0 5 lstat
0.00 0.000000 0 5 poll
0.00 0.000000 0 5 lseek
0.00 0.000000 0 3 mmap
0.00 0.000000 0 7 munmap
0.00 0.000000 0 3 brk
0.00 0.000000 0 3 rt_sigaction
0.00 0.000000 0 1 rt_sigprocmask
0.00 0.000000 0 1 1 ioctl
0.00 0.000000 0 3 setitimer
0.00 0.000000 0 1 shutdown
0.00 0.000000 0 1 fcntl
0.00 0.000000 0 1 getcwd
0.00 0.000000 0 2 mlock
------ ----------- ----------- --------- --------- ----------------
100.00 0.000013 98 1 total

root@myserver [~]# strace -c -p $(lsof | grep user_name | egrep -v "mysql|log" | grep serverportal | awk '{print $2}')
\Process 19025 attached - interrupt to quit
Process 19025 detached
% time seconds usecs/call calls errors syscall
------ ----------- ----------- --------- --------- ----------------
nan 0.000000 0 8 read
nan 0.000000 0 18 write
nan 0.000000 0 2 open
nan 0.000000 0 5 close
nan 0.000000 0 3 fstat
nan 0.000000 0 5 lstat
nan 0.000000 0 4 poll
nan 0.000000 0 5 lseek
nan 0.000000 0 2 mmap
nan 0.000000 0 6 munmap
nan 0.000000 0 1 brk
nan 0.000000 0 3 rt_sigaction
nan 0.000000 0 1 rt_sigprocmask
nan 0.000000 0 1 1 ioctl
nan 0.000000 0 3 setitimer
nan 0.000000 0 1 shutdown
nan 0.000000 0 1 fcntl
nan 0.000000 0 1 getcwd
nan 0.000000 0 2 mlock
nan 0.000000 0 2 munlock
------ ----------- ----------- --------- --------- ----------------
100.00 0.000000 74 1 total



root@myserver [~]# strace -c -p $(lsof | grep user_name | egrep -v "mysql|log" | grep serverportal | awk '{print $2}')
Process 19058 attached - interrupt to quit
Process 19058 detached
% time seconds usecs/call calls errors syscall
------ ----------- ----------- --------- --------- ----------------
100.00 0.000019 1 18 write
0.00 0.000000 0 8 read
0.00 0.000000 0 2 open
0.00 0.000000 0 5 close
0.00 0.000000 0 3 fstat
0.00 0.000000 0 5 lstat
0.00 0.000000 0 4 poll
0.00 0.000000 0 5 lseek
0.00 0.000000 0 2 mmap
0.00 0.000000 0 6 munmap
0.00 0.000000 0 1 brk
0.00 0.000000 0 3 rt_sigaction
0.00 0.000000 0 1 rt_sigprocmask
0.00 0.000000 0 1 1 ioctl
0.00 0.000000 0 3 setitimer
0.00 0.000000 0 1 shutdown
0.00 0.000000 0 1 fcntl
0.00 0.000000 0 1 getcwd
0.00 0.000000 0 2 mlock
0.00 0.000000 0 2 munlock
------ ----------- ----------- --------- --------- ----------------
100.00 0.000019 74 1 total


Thanks for all the help so far.

--
sherin

sherinlist 03-31-2013 10:49 PM

>>additionally attach your strace right after you restarted the web server and not haphazardly during thread execution, use "-f -ff -v" as well and up the size of the printable string size with "-s".

@unSpawn
If I am wrong, please excuse me.

Currently, apache is spawning a new PHP process to execute PHP script. So, I could catch a PHP process during run time only.

FYI,
server is using suPHP.

I tried using "-f -ff -v", but the the PHP process still waits at "read"

>> Also see Xdebug (KCacheGrind, FirePHP, XHProf, PHPeclipse, etc) wrt debugging / profiling?

I tried this earlier, but it didn't help with any useful info.

The issue I now experience is at the "read" thing. After that PHP starts executing all of a sudden.

--
sherin

sherinlist 04-04-2013 10:33 PM

Hi Guys,

Could anyone help with any suggestions, directions or insights into what might be happening ?

Any help is much appreciated.

--
sherin

vishesh 04-04-2013 11:55 PM

Hello ,

If MPM is the case then I think server-status using mod_status worth to see. What I can understand that page php page processing taking time putting prefork in waiting state.

Thanks

sherinlist 04-05-2013 09:56 PM

Thanks Vishesh

sherinlist 04-05-2013 10:18 PM

Hi Guys,

This is what I see until page is displayed browser.

Does this mean that HTTPD is taking time to read requests & send reply ?


root@myserver [~]# httpd status

Apache Server Status for localhost

Server Version: Apache/2.2.22 (Unix) mod_ssl/2.2.22
OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4
FrontPage/5.0.2.2635 mod_jk/1.2.35

Server Built: Jun 28 2012 00:56:23
_________________________________________________________________

Current Time: Saturday, 06-Apr-2013 14:11:52 EST
Restart Time: Monday, 18-Mar-2013 06:30:23 EST
Parent Server Generation: 242
Server uptime: 19 days 7 hours 41 minutes 29 seconds
Total accesses: 1516116 - Total Traffic: 20.6 GB
CPU Usage: u3.44 s.81 cu71.08 cs0 - .00451% CPU load
.908 requests/sec - 13.0 kB/second - 14.3 kB/request
4 requests currently being processed, 7 idle workers

W_._____R.K...........W_........................................
................................................................
................................................................
................................................................

Scoreboard Key:
"_" Waiting for Connection, "S" Starting up, "R" Reading Request,
"W" Sending Reply, "K" Keepalive (read), "D" DNS Lookup,
"C" Closing connection, "L" Logging, "G" Gracefully finishing,
"I" Idle cleanup of worker, "." Open slot with no current process
root@myserver [~]# httpd status

Apache Server Status for localhost

Server Version: Apache/2.2.22 (Unix) mod_ssl/2.2.22
OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4
FrontPage/5.0.2.2635 mod_jk/1.2.35

Server Built: Jun 28 2012 00:56:23
_________________________________________________________________

Current Time: Saturday, 06-Apr-2013 14:11:55 EST
Restart Time: Monday, 18-Mar-2013 06:30:23 EST
Parent Server Generation: 242
Server uptime: 19 days 7 hours 41 minutes 32 seconds
Total accesses: 1516118 - Total Traffic: 20.6 GB
CPU Usage: u3.44 s.81 cu71.22 cs0 - .00452% CPU load
.908 requests/sec - 13.0 kB/second - 14.3 kB/request
4 requests currently being processed, 7 idle workers

__._____R.K...........WW........................................
................................................................
................................................................
................................................................

Scoreboard Key:
"_" Waiting for Connection, "S" Starting up, "R" Reading Request,
"W" Sending Reply, "K" Keepalive (read), "D" DNS Lookup,
"C" Closing connection, "L" Logging, "G" Gracefully finishing,
"I" Idle cleanup of worker, "." Open slot with no current process
root@myserver [~]# httpd status

Apache Server Status for localhost

Server Version: Apache/2.2.22 (Unix) mod_ssl/2.2.22
OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4
FrontPage/5.0.2.2635 mod_jk/1.2.35

Server Built: Jun 28 2012 00:56:23
_________________________________________________________________

Current Time: Saturday, 06-Apr-2013 14:11:57 EST
Restart Time: Monday, 18-Mar-2013 06:30:23 EST
Parent Server Generation: 242
Server uptime: 19 days 7 hours 41 minutes 34 seconds
Total accesses: 1516119 - Total Traffic: 20.6 GB
CPU Usage: u3.44 s.81 cu71.38 cs0 - .00453% CPU load
.908 requests/sec - 13.0 kB/second - 14.3 kB/request
4 requests currently being processed, 7 idle workers

__.W____R.K...........W_........................................
................................................................
................................................................
................................................................

Scoreboard Key:
"_" Waiting for Connection, "S" Starting up, "R" Reading Request,
"W" Sending Reply, "K" Keepalive (read), "D" DNS Lookup,
"C" Closing connection, "L" Logging, "G" Gracefully finishing,
"I" Idle cleanup of worker, "." Open slot with no current process
root@myserver [~]# httpd status

Apache Server Status for localhost

Server Version: Apache/2.2.22 (Unix) mod_ssl/2.2.22
OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4
FrontPage/5.0.2.2635 mod_jk/1.2.35

Server Built: Jun 28 2012 00:56:23
_________________________________________________________________

Current Time: Saturday, 06-Apr-2013 14:11:58 EST
Restart Time: Monday, 18-Mar-2013 06:30:23 EST
Parent Server Generation: 242
Server uptime: 19 days 7 hours 41 minutes 35 seconds
Total accesses: 1516120 - Total Traffic: 20.6 GB
CPU Usage: u3.44 s.81 cu71.38 cs0 - .00453% CPU load
.908 requests/sec - 13.0 kB/second - 14.3 kB/request
4 requests currently being processed, 7 idle workers

__._W___W.K...........W_........................................
................................................................
................................................................
................................................................

Scoreboard Key:
"_" Waiting for Connection, "S" Starting up, "R" Reading Request,
"W" Sending Reply, "K" Keepalive (read), "D" DNS Lookup,
"C" Closing connection, "L" Logging, "G" Gracefully finishing,
"I" Idle cleanup of worker, "." Open slot with no current process
root@myserver [~]# httpd status

Apache Server Status for localhost

Server Version: Apache/2.2.22 (Unix) mod_ssl/2.2.22
OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4
FrontPage/5.0.2.2635 mod_jk/1.2.35

Server Built: Jun 28 2012 00:56:23
_________________________________________________________________

Current Time: Saturday, 06-Apr-2013 14:12:00 EST
Restart Time: Monday, 18-Mar-2013 06:30:23 EST
Parent Server Generation: 242
Server uptime: 19 days 7 hours 41 minutes 36 seconds
Total accesses: 1516122 - Total Traffic: 20.6 GB
CPU Usage: u3.44 s.81 cu71.44 cs0 - .00453% CPU load
.908 requests/sec - 13.0 kB/second - 14.3 kB/request
4 requests currently being processed, 7 idle workers

__.__W__W.C...........W_........................................
................................................................
................................................................
................................................................

Scoreboard Key:
"_" Waiting for Connection, "S" Starting up, "R" Reading Request,
"W" Sending Reply, "K" Keepalive (read), "D" DNS Lookup,
"C" Closing connection, "L" Logging, "G" Gracefully finishing,
"I" Idle cleanup of worker, "." Open slot with no current process
root@myserver [~]# httpd status

Apache Server Status for localhost

Server Version: Apache/2.2.22 (Unix) mod_ssl/2.2.22
OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4
FrontPage/5.0.2.2635 mod_jk/1.2.35

Server Built: Jun 28 2012 00:56:23
_________________________________________________________________

Current Time: Saturday, 06-Apr-2013 14:12:03 EST
Restart Time: Monday, 18-Mar-2013 06:30:23 EST
Parent Server Generation: 242
Server uptime: 19 days 7 hours 41 minutes 40 seconds
Total accesses: 1516123 - Total Traffic: 20.6 GB
CPU Usage: u3.44 s.81 cu71.44 cs0 - .00453% CPU load
.908 requests/sec - 13.0 kB/second - 14.3 kB/request
4 requests currently being processed, 7 idle workers

__.___WWW._...........W_........................................
................................................................
................................................................
................................................................

Scoreboard Key:
"_" Waiting for Connection, "S" Starting up, "R" Reading Request,
"W" Sending Reply, "K" Keepalive (read), "D" DNS Lookup,
"C" Closing connection, "L" Logging, "G" Gracefully finishing,
"I" Idle cleanup of worker, "." Open slot with no current process
root@myserver [~]# httpd status

Apache Server Status for localhost

Server Version: Apache/2.2.22 (Unix) mod_ssl/2.2.22
OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4
FrontPage/5.0.2.2635 mod_jk/1.2.35

Server Built: Jun 28 2012 00:56:23
_________________________________________________________________

Current Time: Saturday, 06-Apr-2013 14:12:05 EST
Restart Time: Monday, 18-Mar-2013 06:30:23 EST
Parent Server Generation: 242
Server uptime: 19 days 7 hours 41 minutes 41 seconds
Total accesses: 1516124 - Total Traffic: 20.6 GB
CPU Usage: u3.44 s.81 cu71.86 cs0 - .00456% CPU load
.908 requests/sec - 13.0 kB/second - 14.3 kB/request
4 requests currently being processed, 7 idle workers

_W.___W_W._...........W_........................................
................................................................
................................................................
................................................................

Scoreboard Key:
"_" Waiting for Connection, "S" Starting up, "R" Reading Request,
"W" Sending Reply, "K" Keepalive (read), "D" DNS Lookup,
"C" Closing connection, "L" Logging, "G" Gracefully finishing,
"I" Idle cleanup of worker, "." Open slot with no current process


Thanks
Sherin

sherinlist 04-05-2013 10:31 PM

Hi,

I tried again and I see following while page is loading.

Do you see anything abnormal ?

=================================
root@myserver [~]# httpd status

Apache Server Status for localhost

Server Version: Apache/2.2.22 (Unix) mod_ssl/2.2.22
OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4
FrontPage/5.0.2.2635 mod_jk/1.2.35

Server Built: Jun 28 2012 00:56:23
_________________________________________________________________

Current Time: Saturday, 06-Apr-2013 14:28:00 EST
Restart Time: Monday, 18-Mar-2013 06:30:23 EST
Parent Server Generation: 243
Server uptime: 19 days 7 hours 57 minutes 36 seconds
Total accesses: 1516604 - Total Traffic: 20.6 GB
CPU Usage: u3.32 s.79 cu88.79 cs0 - .00556% CPU load
.908 requests/sec - 13.0 kB/second - 14.3 kB/request
1 requests currently being processed, 9 idle workers

___..__W_.___...................................................
................................................................
................................................................
................................................................

Scoreboard Key:
"_" Waiting for Connection, "S" Starting up, "R" Reading Request,
"W" Sending Reply, "K" Keepalive (read), "D" DNS Lookup,
"C" Closing connection, "L" Logging, "G" Gracefully finishing,
"I" Idle cleanup of worker, "." Open slot with no current process
root@myserver [~]#
root@myserver [~]# httpd status

Apache Server Status for localhost

Server Version: Apache/2.2.22 (Unix) mod_ssl/2.2.22
OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4
FrontPage/5.0.2.2635 mod_jk/1.2.35

Server Built: Jun 28 2012 00:56:23
_________________________________________________________________

Current Time: Saturday, 06-Apr-2013 14:28:04 EST
Restart Time: Monday, 18-Mar-2013 06:30:23 EST
Parent Server Generation: 243
Server uptime: 19 days 7 hours 57 minutes 41 seconds
Total accesses: 1516605 - Total Traffic: 20.6 GB
CPU Usage: u3.32 s.79 cu88.91 cs0 - .00557% CPU load
.908 requests/sec - 13.0 kB/second - 14.3 kB/request
1 requests currently being processed, 9 idle workers

___..___W.___...................................................
................................................................
................................................................
................................................................

Scoreboard Key:
"_" Waiting for Connection, "S" Starting up, "R" Reading Request,
"W" Sending Reply, "K" Keepalive (read), "D" DNS Lookup,
"C" Closing connection, "L" Logging, "G" Gracefully finishing,
"I" Idle cleanup of worker, "." Open slot with no current process
root@myserver [~]#
root@myserver [~]# httpd status

Apache Server Status for localhost

Server Version: Apache/2.2.22 (Unix) mod_ssl/2.2.22
OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4
FrontPage/5.0.2.2635 mod_jk/1.2.35

Server Built: Jun 28 2012 00:56:23
_________________________________________________________________

Current Time: Saturday, 06-Apr-2013 14:28:09 EST
Restart Time: Monday, 18-Mar-2013 06:30:23 EST
Parent Server Generation: 243
Server uptime: 19 days 7 hours 57 minutes 45 seconds
Total accesses: 1516606 - Total Traffic: 20.6 GB
CPU Usage: u3.32 s.79 cu88.91 cs0 - .00557% CPU load
.908 requests/sec - 13.0 kB/second - 14.3 kB/request
1 requests currently being processed, 9 idle workers

___..____.__W...................................................
................................................................
................................................................
................................................................

Scoreboard Key:
"_" Waiting for Connection, "S" Starting up, "R" Reading Request,
"W" Sending Reply, "K" Keepalive (read), "D" DNS Lookup,
"C" Closing connection, "L" Logging, "G" Gracefully finishing,
"I" Idle cleanup of worker, "." Open slot with no current process
root@myserver [~]#
root@myserver [~]# httpd status

Apache Server Status for localhost

Server Version: Apache/2.2.22 (Unix) mod_ssl/2.2.22
OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4
FrontPage/5.0.2.2635 mod_jk/1.2.35

Server Built: Jun 28 2012 00:56:23
_________________________________________________________________

Current Time: Saturday, 06-Apr-2013 14:28:13 EST
Restart Time: Monday, 18-Mar-2013 06:30:23 EST
Parent Server Generation: 243
Server uptime: 19 days 7 hours 57 minutes 49 seconds
Total accesses: 1516608 - Total Traffic: 20.6 GB
CPU Usage: u3.32 s.79 cu89.47 cs0 - .0056% CPU load
.908 requests/sec - 13.0 kB/second - 14.3 kB/request
1 requests currently being processed, 9 idle workers

___.._W__.___...................................................
................................................................
................................................................
................................................................

Scoreboard Key:
"_" Waiting for Connection, "S" Starting up, "R" Reading Request,
"W" Sending Reply, "K" Keepalive (read), "D" DNS Lookup,
"C" Closing connection, "L" Logging, "G" Gracefully finishing,
"I" Idle cleanup of worker, "." Open slot with no current process
=================================


--
Thanks,
Sherin

sherinlist 04-05-2013 10:35 PM

Hi Guys,

>> What I can understand that page php page processing taking time putting prefork in waiting state.

Do you think that issue is with PHP script as this is not happening for other websites hosted in server ?

If the issue is with PHP script, I am puzzled about the fact that this script is working fine other servers ?

So could this be related to server hardware anyway ?

--
Sherin


All times are GMT -5. The time now is 11:40 AM.