Hi, i have a question regarding mod_perl/apache
mysql memory usage
I have a Linux box running Red Hat 6.1, Apache
1.3.14,
compiled statically with mod_perl 1.24_01, mod_ssl, and Open SSL, mod_dav and mod_gzip running as DSO's, MYSQL is mysql-3.23.28-gamma-pc-linux-gnu-i686 (binary) im using Apache DBI and Apache Session Mysql the linux box has an Intel celeron processor @400mhz, 96 Mb of RAM (graphics video share at 4MB i think) and a hard drive of 4GB this is a development offline server so i running things like X, and, vnc and kde but im very concerned with the usage of memory im connecting via ethernet from a windows box with Internet Explorer and with Netscape, after a few requests httpd memory usage grows to 80MB, and mysqld to over 20MB it still feels fast but im wondering if its normal??? i m not familiar linux memory usage under
linux
, i know that probably this question should be sent to other list any suggestions to where?? anybody please could tell me where to look (my
mason components, handler.pl,
httpd.conf, or somewhere else) i guess that the same mysql database handle isnt being used by the components am i right? im using Mason 0.896
######################################################################## On startup this is the output of top
-b:
3:43pm up 14 min, 1 user,
load average: 0.09, 0.12, 0.09
58 processes: 57 sleeping, 1 running, 0 zombie, 0 stopped CPU states: 2.1% user, 6.7% system, 0.0% nice, 91.1% idle Mem: 87364K av, 85236K used, 2128K free, 77048K shrd, 5944K buff Swap: 128512K av, 3492K used, 125020K free 50264K cached PID USER PRI
NI SIZE RSS SHARE STAT LIB %CPU %MEM TIME
COMMAND
726 root 18 0 4204 4204 2948 S 0 4.9 4.8 0:31 gtop 680 root 9 0 4076 4076 1168 S 0 1.5 4.6 0:24 Xvnc 756 root 5 0 4268 4268 3080 S 0 1.1 4.8 0:04 ktop 770 root 9 0 1032 1032 824 R 0 0.9 1.1 0:00 top 3 root 1 0 0 0 0 SW 0 0.1 0.0 0:00 kupdate 1 root 0 0 460 460 388 S 0 0.0 0.5 0:04 init 2 root 0 0 0 0 0 SW 0 0.0 0.0 0:00 kflushd 4 root 0 0 0 0 0 SW 0 0.0 0.0 0:00 kpiod 5 root 0 0 0 0 0 SW 0 0.0 0.0 0:00 kswapd 6 root -20 -20 0 0 0 SW< 0 0.0 0.0 0:00 mdrecoveryd 291 bin 0 0 308 288 228 S 0 0.0 0.3 0:00 portmap 307 root 0 0 392 380 328 S 0 0.0 0.4 0:00 apmd 360 root 0 0 516 508 420 S 0 0.0 0.5 0:00 syslogd 371 root 0 0 668 656 316 S 0 0.0 0.7 0:00 klogd 387 daemon 0 0 312 296 232 S 0 0.0 0.3 0:00 atd 403 root 0 0 548 540 452 S 0 0.0 0.6 0:00 crond 423 root 0 0 444 436 368 S 0 0.0 0.4 0:00 inetd 439 root 0 0 448 436 368 S 0 0.0 0.4 0:00 lpd 462 root 0 0 868 868 672 S 0 0.0 0.9 0:00 in.telnetd 463 root 0 0 1116 1116 868 S 0 0.0 1.2 0:00 login 464 jaimeren 0 0 956 956 768 S 0 0.0 1.0 0:00 bash 478 root 0 0 1064 1064 704 S 0 0.0 1.2 0:00 su 479 root 5 0 988 988 756 S 0 0.0 1.1 0:00 bash 505 root 0 0 808 664 516 S 0 0.0 0.7 0:00 sendmail 522 root 0 0 340 312 268 S 0 0.0 0.3 0:00 gpm 539 xfs 0 0 1088 1080 584 S 0 0.0 1.2 0:00 xfs 590 root 0 0 392 332 252 S 0 0.0 0.3 0:00 S99local 592 root 0 0 840 840 688 S 0 0.0 0.9 0:00 safe_mysqld 621 root 0 0 1632 1632 988 S 0 0.0 1.8 0:00 mysqld 623 root 0 0 596 512 408 S 0 0.0 0.5 0:00 smbd 634 root 0 0 756 708 572 S 0 0.0 0.8 0:00 nmbd 639 root 0 0 1632 1632 988 S 0 0.0 1.8 0:00 mysqld 640 root 0 0 1632 1632 988 S 0 0.0 1.8 0:00 mysqld 641 root 0 0 1200 656 452 S 0 0.0 0.7 0:00 named 643 root 0 0 384 384 316 S 0 0.0 0.4 0:00 mingetty 644 root 0 0 384 384 316 S 0 0.0 0.4 0:00 mingetty 645 root 0 0 384 384 316 S 0 0.0 0.4 0:00 mingetty 646 root 0 0 384 384 316 S 0 0.0 0.4 0:00 mingetty 647 root 0 0 384 384 316 S 0 0.0 0.4 0:00 mingetty 648 root 0 0 384 384 316 S 0 0.0 0.4 0:00 mingetty 649 root 0 0 1004 1004 944 S 0 0.0 1.1 0:00 gdm 657 root 0 0 11016 10M 1812 S 0 0.0 12.6 0:00 X 658 root 0 0 776 736 668 S 0 0.0 0.8 0:00 gdm 665 gdm 0 0 3156 3156 2400 S 0 0.0 3.6 0:00 gdmlogin 683 root 0 0 4116 4116 3004 S 0 0.0 4.7 0:02 kwm 684 root 0 0 3736 3736 2712 S 0 0.0 4.2 0:00 kbgndwm 685 root 0 0 400 344 264 S 0 0.0 0.3 0:00 startkde 690 root 0 0 656 656 512 S 0 0.0 0.7 0:00 autorun 711 root 0 0 1576 404 324 S 0 0.0 0.4 0:01 kfm 712 root 0 0 3692 3692 2688 S 0 0.0 4.2 0:00 krootwm 713 root 0 0 2228 1212 976 S 0 0.0 1.3 0:01 kpanel 728 root 0 0 436 436 336 S 0 0.0 0.4 0:00 esd 764 root 0 0 7472 7472 7296 S 0 0.0 8.5 0:00 httpd 765 nobody 0 0 7476 7476 7316 S 0 0.0 8.5 0:00 httpd 766 nobody 0 0 7476 7476 7316 S 0 0.0 8.5 0:00 httpd 767 nobody 0 0 7476 7476 7316 S 0 0.0 8.5 0:00 httpd 768 nobody 0 0 7476 7476 7316 S 0 0.0 8.5 0:00 httpd 769 nobody 0 0 7476 7476 7316 S 0 0.0 8.5 0:00 httpd According to gtop memory usage is: there are 6 httpd processes using 44852K there are 3 mysqld processes using 4896k apachectl status says the following Server Version: Apache/1.3.14 (Unix) DAV/1.0.2 mod_perl/1.24_01 mod_ssl/2.7.1 OpenSSL/0.9.6 Server Built: Jan 22 2001 13:50:11 _________________________________________________________________ Current Time: Wednesday, 07-Feb-2001
15:54:29 CST
Restart Time: Wednesday, 07-Feb-2001 15:42:40 CST Parent Server Generation: 0 Server uptime: 11 minutes 49 seconds Total accesses: 0 - Total Traffic: 0 kB CPU Usage: u0 s0 cu0 cs0 0 requests/sec - 0 B/second - 1 requests currently being processed, 4 idle servers ____W........................................................... ................................................................ ................................................................ ................................................................ mysqladmin shows says the following |
Bytes_received |
73 |
| Bytes_sent | 309 | | Connections | 4 | ########################################################################## After a few requests of both browsers i get the
following
mysql extended status:
|
Bytes_received |
47875 |
| Bytes_sent | 56982 | | Connections | 14 | apache status
Current Time: Wednesday, 07-Feb-2001 16:32:28 CST Restart Time: Wednesday, 07-Feb-2001 15:42:40 CST Parent Server Generation: 0 Server uptime: 49 minutes 48 seconds Total accesses: 191 - Total Traffic: 189 kB CPU Usage: u4.12 s.71 cu0 cs0 - .162% CPU load .0639 requests/sec - 64 B/second - 1013 B/request 1 requests currently being processed, 8 idle servers _____W___....................................................... ................................................................ ................................................................ ................................................................ according to gtop memory usage is
there are 10 httpd processes using
83168K
there are 11 mysqld processes using 25828k top -b 4:34pm up 1:05, 1 user, load average: 0.07, 0.03, 0.01 70 processes: 69 sleeping, 1 running, 0 zombie, 0 stopped CPU states: 2.0% user, 4.2% system, 0.0% nice, 93.7% idle Mem: 87364K av, 85236K used, 2128K free, 92484K shrd, 3892K buff Swap: 128512K av, 3340K used, 125172K free 27808K cached PID USER PRI
NI SIZE RSS SHARE STAT LIB %CPU %MEM TIME
COMMAND
726 root 10 0 4208 4208 2948 S 0 3.7 4.8 2:33 gtop 833 root 9 0 1032 1032 816 R 0 3.7 1.1 0:00 top 680 root 6 0 3984 3984 1168 S 0 1.8 4.5 0:46 Xvnc 1 root 0 0 460 460 388 S 0 0.0 0.5 0:04 init 2 root 0 0 0 0 0 SW 0 0.0 0.0 0:00 kflushd 3 root 0 0 0 0 0 SW 0 0.0 0.0 0:00 kupdate 4 root 0 0 0 0 0 SW 0 0.0 0.0 0:00 kpiod 5 root 0 0 0 0 0 SW 0 0.0 0.0 0:00 kswapd 6 root -20 -20 0 0 0 SW< 0 0.0 0.0 0:00 mdrecoveryd 291 bin 0 0 308 288 228 S 0 0.0 0.3 0:00 portmap 307 root 0 0 392 380 328 S 0 0.0 0.4 0:00 apmd 360 root 0 0 516 508 420 S 0 0.0 0.5 0:00 syslogd 371 root 0 0 668 656 316 S 0 0.0 0.7 0:00 klogd 387 daemon 0 0 312 296 232 S 0 0.0 0.3 0:00 atd 403 root 0 0 548 540 452 S 0 0.0 0.6 0:00 crond 423 root 0 0 444 436 368 S 0 0.0 0.4 0:00 inetd 439 root 0 0 448 436 368 S 0 0.0 0.4 0:00 lpd 462 root 0 0 868 868 672 S 0 0.0 0.9 0:00 in.telnetd 463 root 0 0 1116 1116 868 S 0 0.0 1.2 0:00 login 464 jaimeren 0 0 956 956 768 S 0 0.0 1.0 0:00 bash 478 root 0 0 1064 1064 704 S 0 0.0 1.2 0:00 su 479 root 5 0 988 988 756 S 0 0.0 1.1 0:00 bash 505 root 0 0 808 664 516 S 0 0.0 0.7 0:00 sendmail 522 root 0 0 340 312 268 S 0 0.0 0.3 0:00 gpm 539 xfs 0 0 1088 1080 584 S 0 0.0 1.2 0:00 xfs 590 root 0 0 392 332 252 S 0 0.0 0.3 0:00 S99local 592 root 0 0 840 840 688 S 0 0.0 0.9 0:00 safe_mysqld 621 root 0 0 2348 2348 1384 S 0 0.0 2.6 0:00 mysqld 623 root 0 0 600 516 424 S 0 0.0 0.5 0:00 smbd 634 root 0 0 756 708 572 S 0 0.0 0.8 0:00 nmbd 639 root 0 0 2348 2348 1384 S 0 0.0 2.6 0:00 mysqld 640 root 0 0 2348 2348 1384 S 0 0.0 2.6 0:00 mysqld 641 root 0 0 1288 772 564 S 0 0.0 0.8 0:00 named 643 root 0 0 384 384 316 S 0 0.0 0.4 0:00 mingetty 644 root 0 0 384 384 316 S 0 0.0 0.4 0:00 mingetty 645 root 0 0 384 384 316 S 0 0.0 0.4 0:00 mingetty 646 root 0 0 384 384 316 S 0 0.0 0.4 0:00 mingetty 647 root 0 0 384 384 316 S 0 0.0 0.4 0:00 mingetty 648 root 0 0 384 384 316 S 0 0.0 0.4 0:00 mingetty 649 root 0 0 1004 1004 944 S 0 0.0 1.1 0:00 gdm 657 root 0 0 11016 10M 1812 S 0 0.0 12.6 0:00 X 658 root 0 0 776 736 668 S 0 0.0 0.8 0:00 gdm 665 gdm 0 0 3156 3156 2400 S 0 0.0 3.6 0:00 gdmlogin 683 root 0 0 4116 4116 3004 S 0 0.0 4.7 0:02 kwm 684 root 0 0 3736 3736 2712 S 0 0.0 4.2 0:00 kbgndwm 685 root 0 0 400 344 264 S 0 0.0 0.3 0:00 startkde 690 root 0 0 656 656 512 S 0 0.0 0.7 0:01 autorun 711 root 0 0 2116 1068 940 S 0 0.0 1.2 0:01 kfm 712 root 0 0 3692 3692 2688 S 0 0.0 4.2 0:00 krootwm 713 root 0 0 2812 1952 1612 S 0 0.0 2.2 0:01 kpanel 728 root 0 0 436 436 336 S 0 0.0 0.4 0:00 esd 764 root 0 0 7472 7472 7312 S 0 0.0 8.5 0:00 httpd 765 nobody 0 0 8608 8608 5480 S 0 0.0 9.8 0:00 httpd 766 nobody 0 0 8648 8648 5496 S 0 0.0 9.8 0:00 httpd 767 nobody 0 0 8448 8448 5512 S 0 0.0 9.6 0:00 httpd 768 nobody 0 0 8636 8636 5480 S 0 0.0 9.8 0:00 httpd 769 nobody 0 0 8684 8684 5492 S 0 0.0 9.9 0:01 httpd 797 root 0 0 2396 2376 2004 S 0 0.0 2.7 0:00 smbd 798 root 0 0 2348 2348 1384 S 0 0.0 2.6 0:00 mysqld 799 nobody 0 0 8412 8412 5524 S 0 0.0 9.6 0:00 httpd 800 nobody 0 0 8392 8392 5512 S 0 0.0 9.6 0:00 httpd 801 root 0 0 2348 2348 1384 S 0 0.0 2.6 0:00 mysqld 804 root 0 0 2348 2348 1384 S 0 0.0 2.6 0:00 mysqld 805 nobody 0 0 8388 8388 5512 S 0 0.0 9.6 0:00 httpd 806 root 0 0 2348 2348 1384 S 0 0.0 2.6 0:00 mysqld 807 root 0 0 2348 2348 1384 S 0 0.0 2.6 0:00 mysqld 808 root 0 0 2348 2348 1384 S 0 0.0 2.6 0:00 mysqld 809 root 0 0 2348 2348 1384 S 0 0.0 2.6 0:00 mysqld 810 root 0 0 2348 2348 1384 S 0 0.0 2.6 0:00 mysqld 822 nobody 0 0 7480 7480 7320 S 0 0.0 8.5 0:00 httpd |
- Re: mod_perl/apache mysql memory usage rene mendoza
- Re: mod_perl/apache mysql memory usage G.W. Haywood
- Re: mod_perl/apache mysql memory usage Vasily Petrushin