Oracle9i Application Server for UNIX Oracle HTTP Server powered by Apacheパフォーマンス・ガイド, リリース1.0.2

Transcription

1 Oracle9i Application Server for UNIX Oracle HTTP Server powered by Apache : J

2 Oracle9i Application Server for UNIX Oracle HTTP Server powered by Apache, : J Oracle9i Application Server Oracle HTTP Server powered by Apache Performance Guide Release for AIX-Based Systems, Compaq Tru64 UNIX, HP 9000 Series HP-UX, Linux Intel, and Sun Solaris Intel A Pallavi Bhowmik, and Julia Pond Corinne Arne, Rupesh Das, Danielle Higgins, Prashanth Joshi, Rajesh Konanganparambath, Saurabh Pandey, and Sriram V.R. Nagaraja Rao Copyright 2000 Oracle Corporation. All rights reserved. Printed in Japan. * Oracle Corporation Oracle Corporation Restricted Rights Legend Restricted Rights Legend Programs delivered subject to the DOD FAR Supplement are "commercial computer software" and use, duplication and disclosure of the Programs shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, Programs delivered subject to the Federal Acquisition Regulations are "restricted computer software" and use, duplication and disclosure of the Programs shall be subject to the restrictions in FAR , Rights in Data -- General, including Alternate III (June 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA

3 ... v Web sar AIX HP-UX Intel Solaris top Web mod_status i

4 JServ CPU CPU Secure Sockets Layer HTTP HTTP JServ Java OracleJSP JServ HTTP TCP Linux MaxClients SSL HTTP/ Apache Apache JServ JServ OracleJSP OracleJSP ii

5 OracleJSP iii

6 iv

7 Oracle HTTP Server powered by Apache Oracle9i Application Server Web Apache 100Mbps tnsnames.ora runinstaller file1 <filename> v

8 owsctl start wrb [-c string] [on off] 1 {yes no} n,... vi

9 1 Oracle9i Application Server 1-1

10 Oracle9i Application Server for UNIX Oracle HTTP Server powered by Apache

11

12 CPU CPU Oracle9i Application Server for UNIX Oracle HTTP Server powered by Apache

13 CPU I/O

14 1-4 Oracle HTTP Server MaxClients JServ security.maxconnections 1-4 CPU CPU 1-6 Oracle9i Application Server for UNIX Oracle HTTP Server powered by Apache

15 3 I/O I/O 1-7

16 90% Oracle9i Application Server for UNIX Oracle HTTP Server powered by Apache

17 : : 3 : 5 Apache JServ 4 HTTP : 2 Web : 1-9

18 1-6 Oracle9i Application Server Oracle HTTP Server powered by Apache Apache JServ OracleJSP 1-6 Oracle9i Application Server 1-10 Oracle9i Application Server for UNIX Oracle HTTP Server powered by Apache

19 2 Web Web JServ Web 2-1

20 CPU sar System Activity Reporter mpstat sar AIX AIX HP-UX HP-UX Intel Solaris sar CPU sar $ sar -u 5 5 : 5 5 CPU $ sar -u :30:25 %usr %sys %wio %idle 15:30: :30: :30: :30: :30: Average CPU 9% CPU sar sar -u 2-1 sar CPU CPU %usr %sys %wio %idle I/O 2-2 Oracle9i Application Server for UNIX Oracle HTTP Server powered by Apache

21 Web top top man : $ top 4.:16pm up 15 days, 5:39 23 users, load average: 0.51, 0.38, processes: 261 sleeping, 3 running, 1 zombie, 0 stopped CPU states: 7.1% user, 44.3% system, 0.0% nice, 48.4% idle Mem: K av, K used, 54836K free, 75288K shrd, K buff Swap: K av, 10376K used, K free K cached PID USER PRI NI SIZE RSS SHARE STAT LIB %CPU %MEM TIME COMMAND oasport M 5068 R :06 oraweb oasport M 4896 R :05 oraweb rkonanga R :00 top oasport S :02 xterm oasport S :00 oasoorb 1 root S :04 init 2 root SW :10 kflushd 3 root SW kupdate Web Oracle HTTP Server mod_status Web mod_status httpd.conf your_domain.com <Location /server-status> SetHandler server-status Order deny, allow Deny from all Allow from your_domain.com </Location> ExtendedStatus On your_domain.com Web 2-3

22 Web httpd httpd 2-1 ExtendedStatus 2-4 Oracle9i Application Server for UNIX Oracle HTTP Server powered by Apache

23 Web 2-1 ExtendedStatus 6 4 M httpd Req M W Web 2-5

24 Web CPU CPU 90% CPU httpd httpd.conf MaxClients MaxClients 4-9 MaxClients 2-1 URL refresh x 3 refresh=3 URL auto Apache Group Perl logstatus.pl $ORACLE_HOME/Apache/Apache/bin/ 2-6 Oracle9i Application Server for UNIX Oracle HTTP Server powered by Apache

25 JServ cron 2-2 $wherelog $port $server $request : /private/admin/logs/ localhost auto : httpd ps top pmap mod_status JServ Oracle9i Application Server JServ 1. jserv.conf JServ JServ localhost <Location /jserv/> SetHandler jserv-status order deny, allow deny from all allow from oracle.com </Location> Web 2-7

26 JServ 2. port Web httpd.conf URL / "not found" Configured Hosts 3. JServ 2-3 : JServ jserv.conf JServ Up Oracle9i Application Server for UNIX Oracle HTTP Server powered by Apache

27 JServ 2-3 JServ Status shm Web 2-9

28 JServ : Status Up Down + - X / 2-10 Oracle9i Application Server for UNIX Oracle HTTP Server powered by Apache

29 3 I/O CPU 3-1

30 80% CPU 2-2 sar AIX HP-UX Intel Solaris : httpd.conf MaxClients MaxClients 4-9 MaxClients Oracle9i Application Server for UNIX Oracle HTTP Server powered by Apache

31 CPU CPU 5 6 % mod_ status CPU - CPU CPU CPU 3-2 CPU CPU 2 Web 3-2 CPU 20K JDK 1.2 JDK CPU 5ms 20ms 40ms ms ms 3-3

32 CPU Secure Sockets Layer Secure Sockets Layer SSL SSL Web URL http https SSL CPU SSL 0.5 SSL Mbps SSL 336Mhz 1 125ms CPU SSL HTTP SSL 4-9 SSL HTTP HTTP JServ Java OracleJSP JServ HTTP 2 Web 3-4 Oracle9i Application Server for UNIX Oracle HTTP Server powered by Apache

33 HTTP JServ HTTP 400K K JDK 1.2 JServ 12 15MB JDK MB Java JDK MB JDK MB Java java.lang Runtime.getRuntime().totalMemory() Runtime.getRuntime().freeMemory 128MB jserv.properties Java wrapper.bin.parameters=-mx128m JServ JServ JServ : top ps 3-5

34 OracleJSP OracleJSP JavaServer Pages Oracle JDK Oracle JSP OracleJSP 3-3 OracleJSP JDK JDK MB 24MB OracleJSP 10MB 32MB 1 0.5MB OracleJSP <%@ page session= false %> <html><body> HelloWorld </body></html> Java 150K 200K Java 12 15MB OracleJSP Oracle8i JavaServer Pages JServ 1 CPU 2 JServ JServ security.maxconnections= Java JServ JVM httpd mod_jserv JServ JServ 3-6 Oracle9i Application Server for UNIX Oracle HTTP Server powered by Apache

35 5-4 Oracle Application Server

36 3-8 Oracle9i Application Server for UNIX Oracle HTTP Server powered by Apache

37 4 HTTP TCP MaxClients SSL Oracle HTTP Server TCP MaxClients SSL HTTP/1.1 Apache HTTP 4-1

38 TCP TCP TCP TCP TCP 4-1 TCP Intel Solaris tcp_conn_hash_size TCP tcp_close_wait_interval Solaris tcp_time_wait_interval Solaris tcp_conn_req_max_q tcp_conn_req_max_q tcp_slow_start_initial tcp_xmit_hiwat tcp_recv_hiwat Oracle9i Application Server for UNIX Oracle HTTP Server powered by Apache

39 TCP 4-2 HP-UX tcp_time_wait_interval ndd/dev/tcp 60,000 60,000 tcp_conn_req_max ndd/dev/tcp 20 1,024 tcp_ip_abort_interval ndd/dev/tcp 600,000 60,000 tcp_keepalive_interval ndd/dev/tcp 7,20,00, ,000 tcp_rexmit_interval_initial ndd/dev/tcp 1,500 1,500 tcp_rexmit_interval_max ndd/dev/tcp 60,000 60,000 tcp_rexmit_interval_min ndd/dev/tcp tcp_xmit_hiwater_def ndd/dev/tcp 32,768 32,768 tcp_recv_hiwater_def ndd/dev/tcp 32,768 32, Tru64 TCP/IP tcbhashsize sysconfig -r inet ,384 tcbhashnum sysconfig -r inet tcp_keepalive_default sysconfig -r inet 0 1 tcp_sendspace sysconfig -r inet 16,384 65,535 tcp_recvspace sysconfig -r inet 16,384 65,535 somaxconn sysconfig -r socket 1,024 65,535 sominconn sysconfig -r socket 0 65,535 sbcompress_threshold sysconfig -r socket HTTP 4-3

40 TCP 4-4 AIX TCP rfc1323 /etc/rc.net 0 1 sb_max /etc/rc.net 65, ,072 tcp_mssdflt /etc/rc.net 512 1,024 ipqmaxlen /etc/rc.net tcp_sendspace /etc/rc.net 16,384 65,536 tcp_recvspace /etc/rc.net 16,384 65,536 xmt_que_size /etc/rc.net Linux Linux Linux 15 TCP 2 : 4-5 sysctl VI 4-5 Linux TCP /proc/sys/net/core/rmem_default /proc/sys/net/core/rmem_max /proc/sys/net/core/wmem_default /proc/sys/net/core/wmem_max 4-4 Oracle9i Application Server for UNIX Oracle HTTP Server powered by Apache

41 TCP /proc/sys/net/ipv4/ TCP tcp_timestamps tcp_windowscaling tcp_sack /Documentation/networking/ip-sysctl.txt TCP TCP Linux /LINUX-SOURCE-DIR/include/linux/skbuff.h # ifdef CONFIG_SKB_LARGE #define SK_WMEM_MAX #define SK_RMEM_MAX # else #define SK_WMEM_MAX #define SK_RMEM_MAX #endif Linux /LINUX-SOURCE-DIR/include/net/tcp.h MAX_WINDOW #define MAX_WINDOW #define MIN_WINDOW 2048 : MIN_WINDOW TCP 15 40KB rmem_default 40KB 64KB winshift 2 32KB winshift=1 rmem_default 64KB 40KB 15 HTTP 4-5

42 TCP TCP 2Mbit Mbit netperf TCP Intel Solaris /etc/system set tcp:tcp_conn_hash_size=32768 Tru64 tcbhashsize /etc/sysconfigtab TCP tcpset.sh $ORACLE_HOME/Apache/Apache/bin/ TCP TCP Intel Solaris tcp_close_wait_interval TCP Intel Solaris tcp_conn_hash_size /etc/system set tcp:tcp_conn_hash_size=32768 Tru64 tcbhashsize /etc/sysconfigtab TCP TCP 4-6 Oracle9i Application Server for UNIX Oracle HTTP Server powered by Apache

43 TCP TCP tcp_close_wait_interval Solaris 2.7 tcp_time_wait_interval 60,000ms Solaris Solaris 2.6 prompt>/usr/sbin/ndd -set /dev/tcp tcp_close_wait_interval Solaris 2.7 HP-UX prompt>/usr/sbin/ndd -set /dev/tcp tcp_time_wait_interval : TCP tcp_conn_hash_size TCP SYN 2 Intel Solaris tcp_conn_req_max_q tcp_conn_req_max_q 128 Web 1025 netstat -s tcplistendrop tcplistendropq0 tcphalfopendrop 2 HTTP 4-7

44 TCP tcp_conn_req_max_q 1024 Intel Solaris prompt>/usr/sbin/ndd -set /dev/tcp tcp_conn_req_max_q 1024 prompt>/usr/sbin/ndd -set /dev/tcp tcp_conn_req_max_q HP-UX prompt>/usr/sbin/ndd-set /dev/tcp tcp_conn_req_max 1024 TCP 1 2 TCP Microsoft Windows NT Solaris 1 TCP Solaris 2 prompt>/usr/sbin/ndd -set /dev/tcp tcp_slow_start_initial 2 TCP Intel Solaris prompt>/usr/sbin/ndd -set /dev/tcp tcp_xmit_hiwat prompt>/usr/sbin/ndd -set /dev/tcp tcp_recv_hiwat HP-UX prompt>/usr/sbin/ndd -set /dev/tcp tcp_xmit_hiwater_def prompt>/usr/sbin/ndd -set /dev/tcp tcp_recv_hiwater_def Oracle9i Application Server for UNIX Oracle HTTP Server powered by Apache

45 SSL TCP MaxClients MaxClients Web httpd Oracle9i Application Server httpd.conf MaxClients MaxClients httpd TCP/IP : httpd 4-12 httpd MaxClients SSL Oracle HTTP Server SSL SSL SSL SSL httpd.conf SSLSessionCacheTimeout 300 SSLSessionCache $ORACLE_HOME/Apache/Apache/logs/ Oracle HTTP Server SSL HTTP HTTP 4-9

46 2 3% HostNameLookups HostNameLookups IP HostNameLookups IP DNS HostNameLookups 3 DNS DNS IP logresolve $ORACLE_HOME/Apache/Apache/ bin/ IP URL Dale Gaudet Apache Performance Notes ErrorLog LogLevel warn warn info debug LogLevel URL HTTP/1.1 Oracle HTTP Server HTTP/1.1 Netscape Navigator 4.0 HTTP/ Internet Explorer HTTP/ Oracle9i Application Server for UNIX Oracle HTTP Server powered by Apache

47 HTTP/1.1 1 HTTP/1.1 URL HTTP/1.1 Apache KeepAlive HTTP/1.1 Netscape 1 HTTP Web 3 Web HTTP 4-11

48 HTTP/ % TCP 1 Hello World CPU ms 10% httpd Apache httpd 1 KeepAlive KeepAlive httpd KeepAlive KeepAlive on MaxKeepAliveRequests 100 KeepAliveTimeOut 15 KeepAlive 4-12 Oracle9i Application Server for UNIX Oracle HTTP Server powered by Apache

49 Apache FIN_WAIT_2 TCP FIN_WAIT_2 TCP FIN_WAIT_2 FIN_WAIT_2 httpd Web Apache Apache HTTP 4-13

50 Apache 4-14 Oracle9i Application Server for UNIX Oracle HTTP Server powered by Apache

51 5 Apache JServ JServ OracleJSP Oracle JavaServer Pages 1.1 JServ OracleJSP OracleJSP Apache JServ 5-1

52 JServ JServ Apache JServ httpd mod_jserv Apache Java mod_jserv C JServ JVM 5-1 JServ HTTP JServ Apache JServ Protocol Apache JServ 5-2 Oracle9i Application Server for UNIX Oracle HTTP Server powered by Apache

53 JServ JVM 1 Apache JServ JVM servlets.startup init() servlets.startup JServ JSP JSP HttpServlet oracle.jsp.jspservlet servlets.startup JSP 1 init() servlets.startup autoreload.classes True False Apache JServ 5-3

54 autoreload.classes=false autoreload.file=false JServ HTTP Apache JServ 3 HTTP 2 JServ jserv.properties JServ JServ JServ Oracle HTTP Server $ORACLE_HOME/Apache/Apache/bin/ JServ JServ 3-5 Java JServ JServ jserv.properties JServ 1. JServ prompt>cp jserv.properties jserv1.properties prompt>cp jserv.properties jserv2.properties 2. jserv1.properties port=8001 log.file=/usr/local/jserv/logs/jserv1.log 5-4 Oracle9i Application Server for UNIX Oracle HTTP Server powered by Apache

55 3. jserv2.properties port=8002 log.file=/usr/local/jserv/logs/jserv2.log : HTTP JServ HTTP IP jserv.properties security.allowedaddresses JServ CLASSPATH JServ java JServ jserv1.properties java JServ jserv2.properties Web $ORACLE_HOME/Apache/Apache/bin/ startjserv.sh stopjserv.sh jserv.conf 1. ApJServManual on 2. a. ApJServMount ApJServMount /servlets /root ApJServMount /root testservlet b. /root balance://set/root ApJServMount /servlets balance://jserv_set/root ApJServBalance JServ_set JServ1 ApJServBalance JServ_set JServ2 2 ApJServHost JServ1 ajpv12:// :8001 ApJServHost JServ2 ajpv12:// :8002 ApJServRoute JS1 JServ1 ApJServRoute JS2 JServ2 ApJServShmFile /usr/local/apache/logs/jserv_shm Apache JServ 5-5

56 ApJServMount /servlets balance://set/root /servlets JServ1 JServ2 ApJServBalance JServ1 JServ2 JServ2 '2' 2 JServ2 JServ2 2/3 JServ ApJServHost ApJServRoute JServ JServ 1 JServ Cookie ApJServShmFile httpd JServ JServ mod_jserv JServ 1. httpd 2. mod_jserv JServ 1 JServ ApJServBalance set JServ2 2 JServ2 3. httpd mod_jserv 4. mod_jserv JServ a. mod_jserv ApJServRoute JServ b. mod_jserv httpd ID JServ JServ_id to handle the request = httpd_pid % number of JServs in the list JServ 5-6 Oracle9i Application Server for UNIX Oracle HTTP Server powered by Apache

57 SingleThreadModel STM STM 25% STM init() destroy() doget() service() JDBC zone.properties STM 3 JServ DB / JServ = 1 STM JServ singlethreadmodelservlet.initialcapacity = 10 singlethreadmodelservlet.incrementcapacity = 0 singlethreadmodelservlet.maximumcapacity = 10 : singlethreadmodelservlet.maximumcapacity jserv.properties security.maxconnections JServ Apache JServ 5-7

58 OracleJSP OracleJSP OracleJSP JavaServer Pages 1.1 Oracle Oracle JavaBeans SQL Oracle9i Application Server OracleJSP Oracle JSP 0.5MB OracleJSP page session="false" %> 30 session.invalidate() OracleJSP Oracle8i JavaServer Pages 1 True jserv.properties False servlet.oracle.jsp.jspservlet.initargs=developer_mode=false True OracleJSP JDK MB TCP 14% 28% 5-8 Oracle9i Application Server for UNIX Oracle HTTP Server powered by Apache

59 OracleJSP OracleJSP contexttype JSP page buffer= none %> OracleJSP 8KB OracleJSP Oracle8i JavaServer Pages OracleJSP Page OracleJSP JDBC JDBC Apache JServ 5-9

60 OracleJSP include file= /jsp/filename.jsp %> JSP 64K <jsp:include page= /jsp/filename.jsp flush="true" /> JSP 5-10 Oracle9i Application Server for UNIX Oracle HTTP Server powered by Apache

61 A Apache JServ Protocol ApJServBalance 5-5 ApJServManual 5-5 ApJServMount 5-5 ApJServRoute 5-5 ApJServShmFile 5-5 C CPU cron 2-7 D developer_mode 5-8 E ExtendedStatus 2-4 I servlets.startup 5-3 J JDBC 5-7 JServ CPU JServ Protocol jserv.conf 2-8 jserv.properties 5-4 JSP 5-8 M MaxClients mod_jserv mod_status mpstat 2-2 O Oracle9i Application Server 1-10 oracle.jsp.jspservlet 5-3 S sar 2-2 security.allowedaddresses 5-5 security.maxconnections 3-6 SetHandler 2-3 SSL

62 Z zone.properties 5-7 JServ 5-2 Oracle9i Application Server SSL SingleThreadModel JServ 5-6 SSL

63 CPU MaxClients Apache JServ HTTP/ SSL CPU 2-2 httpds JServ sar

64 -4