Mike,
There are a lot of things to consider here. If you have something precise
to focus upon that might help tremendously. But here are a few pointers.
You have 3 subsystems processing work for PHP:
QHTTPSVR - Apache and FastCGI
ZENDSVR - Zend Monitor jobs
QSYSWRK - SQL Server Jobs
Before accusing anything of performance issue you should get some
measurements. As Drucker is often misquoted, "You can't manage what you
can't measure!" See where your pain is and apply treatment. But also
keep in mind that performance issues are rarely resolved by a single
silver bullet.
Assuming you are on the latest PTF's, groups, etc. I'm also hoping you've
eliminated hardware. All the RAM in the world won't make up for a 2 arm
machine. (although these Power 7 machines are damned impressive...)
Are you using persistent connection for DB2 functions and private
connections for toolkit calls?
Here are some places to go for some basic performance tuning assistance.
DB2 Best Practices with PHP:
http://www.zend.com/en/resources/webinars/i5-os#DB2BP
PHP Toolkit tips:
http://www.zend.com/en/resources/webinars/i5-os#PHPTool
Performance tuning PHP on IBM i:
http://www.zend.com/en/resources/webinars/i5-os#IBMIPERF
There are also free features of Zend Server called script (op-code) cache
and data cache. Check out the online documentation for more details.
http://files.zend.com/help/Zend-Server-6-IBMi/zend-server.htm
White paper on the data cache:
http://www.zend.com/topics/Zend-Server-Data-Caching-Whitepaper-0106-T-WP-R
1-EN.pdf
Penton has a recorded seminar on PHP Performance by Alan Seiden in their
eLearning section and here is a free article where he answers some
questions:
http://iprodeveloper.com/php/php-performance-alan-seiden-answers-our-qs
One last shameless plug for Alan is that he will be doing an all day
workshop on PHP Performance Tuning at ZendCon 2013.
http://www.zendcon.com/
Since I gave you a TON of pointers for no charge I hope that David
forgives me for the reference to ZendCon. But it is exactly what you are
asking for.
Regards,
Mike
Office Phone: (708)233-5880 Cell: (408)679-1011
-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On
Behalf Of Michael Ryan
Sent: Tuesday, August 13, 2013 9:04 AM
To: Midrange Systems Technical Discussion; Web Enabling the AS400 /
iSeries
Subject: [WEB400] Subsystem and Apache Setup for Zend Server 6
Hi folks -
Implementing a PHP solution on an E6C system. Lots of memory, lots of
disk, system isn't overworked at this point. V7R1. System value QPFRADJ is
set to
3 (Automatic Adjustment). Default Zend Server 6 installation uses *BASE
memory pool.
Zend Server performance is lousy. Much slower page load and data retrieval
than the same code on the development system. Lots of Toolkit and stored
procedure use.
I'm thinking that the first step would be to establish a fixed memory pool
just for Zend Server, set it to *NOMAX for threads, and see how it runs.
What tuning recommendations, for both Apache and Zend, do you folks
suggest? Any good documentation on this?
Thanks!
--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
list To post a message email: WEB400@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/web400.
midrange.com
