LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
Search this Thread
Old 11-15-2012, 02:36 AM   #1
Tarikc
Member
 
Registered: May 2009
Distribution: CentOS
Posts: 50

Rep: Reputation: 2
Ubuntu: apache2 + mysql REAAALLLY SLOW even SSH access


Hello Gentlemen,

Problem is that:

I have a VM with Ubuntu 12.04, RAM 4GB, processor shares are higher than the other VMs.

I use this VM for only one website, "Based on Joomla"

When I issue the "top" command I see that CPU are 100% all the time, apache2 and mysql are consuming it.

Sometimes, and all of a sudden, the access to the website gets REALLY slow, but pinging to the server is normal.
Browsing to the hosted website is dead, even SSH to the server is very slow, While the CPU Consumption is nothing.

I checked the logs for the mysql and the apache but nothing shows there.

So what I do is that I restart the services and the website is fired up again, and CPU gets 100% again.

RAM is not using more than 2GB.

Can you please give me a clue on what is really going on here?

How can I improve the performance of this server?

Thank you in advance guys.
 
Old 11-15-2012, 04:03 AM   #2
surya7
LQ Newbie
 
Registered: Oct 2010
Posts: 5

Rep: Reputation: 0
Ubuntu: apache2 + mysql REAAALLLY SLOW even SSH access

Quote:
Originally Posted by Tarikc View Post
Hello Gentlemen,

Problem is that:

I have a VM with Ubuntu 12.04, RAM 4GB, processor shares are higher than the other VMs.

I use this VM for only one website, "Based on Joomla"

When I issue the "top" command I see that CPU are 100% all the time, apache2 and mysql are consuming it.

Sometimes, and all of a sudden, the access to the website gets REALLY slow, but pinging to the server is normal.
Browsing to the hosted website is dead, even SSH to the server is very slow, While the CPU Consumption is nothing.

I checked the logs for the mysql and the apache but nothing shows there.

So what I do is that I restart the services and the website is fired up again, and CPU gets 100% again.

RAM is not using more than 2GB.

Can you please give me a clue on what is really going on here?

How can I improve the performance of this server?

Thank you in advance guys.

Hi Tarikc

Please check your Mysql and httpd configuration.

use mysqltuner to analyse mysql configuration.
 
Old 11-15-2012, 08:21 AM   #3
Tarikc
Member
 
Registered: May 2009
Distribution: CentOS
Posts: 50

Original Poster
Rep: Reputation: 2
Dear surya7,

Thank you very much for your reply.

Here is the output from mysqltuner:

Quote:
-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.5.24-0ubuntu0.12.04.1-log
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 40M (Tables: 115)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[--] Data in MEMORY tables: 0B (Tables: 3)
[!!] InnoDB is enabled but isn't being used
[!!] Total fragmented tables: 2

-------- Performance Metrics -------------------------------------------------
[--] Up for: 12s (962 q [80.167 qps], 160 conn, TX: 6M, RX: 196K)
[--] Reads / Writes: 56% / 44%
[--] Total buffers: 576.0M global + 2.7M per thread (600 max threads)
[OK] Maximum possible memory usage: 2.1G (55% of installed RAM)
[!!] Slow queries: 8% (79/962)
[OK] Highest usage of available connections: 0% (3/600)
[OK] Key buffer size / total MyISAM indexes: 384.0M/47.1M
[OK] Key buffer hit rate: 97.4% (77K cached / 2K reads)
[!!] Query cache efficiency: 3.2% (14 cached / 431 selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 96 sorts)
[!!] Joins performed without indexes: 54
[OK] Temporary tables created on disk: 21% (87 on disk / 412 total)
[OK] Thread cache hit rate: 98% (3 created / 160 connections)
[OK] Table cache hit rate: 24% (164 open / 663 opened)
[OK] Open file limit used: 9% (289/3K)
[OK] Table locks acquired immediately: 100% (861 immediate / 861 locks)

-------- Recommendations -----------------------------------------------------
General recommendations:
Add skip-innodb to MySQL configuration to disable InnoDB
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Adjust your join queries to always utilize indexes
Variables to adjust:
query_cache_limit (> 1M, or use smaller result sets)
join_buffer_size (> 128.0K, or always use indexes with joins)
 
Old 11-19-2012, 06:34 AM   #4
Tarikc
Member
 
Registered: May 2009
Distribution: CentOS
Posts: 50

Original Poster
Rep: Reputation: 2
Dear All,

I'm still facing the same problem yet again.

I've managed to get the attached image from the console.

41BB5E03-B48D-4D60-8861-8B06A0CECB9C.png

Guys please I need your help with this.

Looking forward for any kind of help.

Best regards,
 
Old 11-19-2012, 06:40 AM   #5
Tarikc
Member
 
Registered: May 2009
Distribution: CentOS
Posts: 50

Original Poster
Rep: Reputation: 2
This is my syslog:

Quote:
Nov 19 14:49:05 almasalah kernel: [354160.545663] active_anon:683153 inactive_anon:250727 isolated_anon:2956
Nov 19 14:49:05 almasalah kernel: [354160.545664] active_file:111 inactive_file:226 isolated_file:47
Nov 19 14:49:05 almasalah kernel: [354160.545664] unevictable:0 dirty:0 writeback:216 unstable:0
Nov 19 14:49:05 almasalah kernel: [354160.545665] free:21807 slab_reclaimable:3345 slab_unreclaimable:9077
Nov 19 14:49:05 almasalah kernel: [354160.545666] mapped:140 shmem:13 pagetables:25683 bounce:0
Nov 19 14:49:05 almasalah kernel: [354160.545668] Node 0 DMA free:15908kB min:256kB low:320kB high:384kB active_anon:0kB inactive_anon:0kB active_file:0kB inactive_file:0kB unevictable:0kB isolated(anon):0kB isolated(file):0kB present:15656kB mlocked:0kB dirty:0kB writeback:0kB mapped:0kB shmem:0kB slab_reclaimable:0kB slab_unreclaimable:4kB kernel_stack:0kB pagetables:0kB unstable:0kB bounce:0kB writeback_tmp:0kB pages_scanned:0 all_unreclaimable? yes
Nov 19 14:49:05 almasalah kernel: [354160.545675] lowmem_reserve[]: 0 2992 4000 4000
Nov 19 14:49:05 almasalah kernel: [354160.545678] Node 0 DMA32 free:54400kB min:50360kB low:62948kB high:75540kB active_anon:2306468kB inactive_anon:576644kB active_file:136kB inactive_file:380kB unevictable:0kB isolated(anon):2992kB isolated(file):0kB present:3064000kB mlocked:0kB dirty:0kB writeback:460kB mapped:136kB shmem:16kB slab_reclaimable:4148kB slab_unreclaimable:22512kB kernel_stack:1000kB pagetables:80192kB unstable:0kB bounce:0kB writeback_tmp:0kB pages_scanned:1851 all_unreclaimable? yes
Nov 19 14:49:05 almasalah kernel: [354160.545686] lowmem_reserve[]: 0 0 1008 1008
Nov 19 14:49:05 almasalah kernel: [354160.545688] Node 0 Normal free:16920kB min:16964kB low:21204kB high:25444kB active_anon:426144kB inactive_anon:426264kB active_file:308kB inactive_file:524kB unevictable:0kB isolated(anon):8832kB isolated(file):188kB present:1032192kB mlocked:0kB dirty:0kB writeback:404kB mapped:424kB shmem:36kB slab_reclaimable:9232kB slab_unreclaimable:13792kB kernel_stack:736kB pagetables:22540kB unstable:0kB bounce:0kB writeback_tmp:0kB pages_scanned:1257 all_unreclaimable? yes
Nov 19 14:49:05 almasalah kernel: [354160.545696] lowmem_reserve[]: 0 0 0 0
Nov 19 14:49:05 almasalah kernel: [354160.545698] Node 0 DMA: 1*4kB 0*8kB 0*16kB 1*32kB 2*64kB 1*128kB 1*256kB 0*512kB 1*1024kB 1*2048kB 3*4096kB = 15908kB
Nov 19 14:49:05 almasalah kernel: [354160.545705] Node 0 DMA32: 32*4kB 584*8kB 472*16kB 192*32kB 131*64kB 77*128kB 47*256kB 3*512kB 0*1024kB 0*2048kB 1*4096kB = 54400kB
Nov 19 14:49:05 almasalah kernel: [354160.545711] Node 0 Normal: 212*4kB 509*8kB 168*16kB 79*32kB 38*64kB 4*128kB 1*256kB 1*512kB 1*1024kB 1*2048kB 0*4096kB = 16920kB
Nov 19 14:49:05 almasalah kernel: [354160.545718] 125310 total pagecache pages
Nov 19 14:49:05 almasalah kernel: [354160.545719] 124906 pages in swap cache
Nov 19 14:49:05 almasalah kernel: [354160.545720] Swap cache stats: add 4599424, delete 4474518, find 12865944/13200448
Nov 19 14:49:05 almasalah kernel: [354160.545722] Free swap = 0kB
Nov 19 14:49:05 almasalah kernel: [354160.545723] Total swap = 4191228kB
Nov 19 14:49:05 almasalah kernel: [354160.556332] 1048560 pages RAM
Nov 19 14:49:05 almasalah kernel: [354160.556334] 36119 pages reserved
Nov 19 14:49:05 almasalah kernel: [354160.556335] 39339 pages shared
Nov 19 14:49:05 almasalah kernel: [354160.556336] 986442 pages non-shared
Nov 19 14:49:05 almasalah kernel: [354160.556338] [ pid ] uid tgid total_vm rss cpu oom_adj oom_score_adj name
Nov 19 14:49:05 almasalah kernel: [354160.556346] [ 658] 0 658 3795 28 0 0 0 upstart-socket-
Nov 19 14:49:05 almasalah kernel: [354160.556349] [ 721] 102 721 5985 37 0 0 0 dbus-daemon
Nov 19 14:49:05 almasalah kernel: [354160.556352] [ 738] 0 738 12487 1 0 -17 -1000 sshd
Nov 19 14:49:05 almasalah kernel: [354160.556355] [ 748] 101 748 62365 92 0 0 0 rsyslogd
Nov 19 14:49:05 almasalah kernel: [354160.556357] [ 809] 0 809 3944 1 0 0 0 getty
Nov 19 14:49:05 almasalah kernel: [354160.556360] [ 816] 0 816 3944 1 0 0 0 getty
Nov 19 14:49:05 almasalah kernel: [354160.556363] [ 825] 0 825 3944 1 0 0 0 getty
Nov 19 14:49:05 almasalah kernel: [354160.556365] [ 829] 0 829 3944 1 0 0 0 getty
Nov 19 14:49:05 almasalah kernel: [354160.556368] [ 834] 0 834 3944 1 0 0 0 getty
Nov 19 14:49:05 almasalah kernel: [354160.556370] [ 853] 0 853 1080 0 0 0 0 acpid
Nov 19 14:49:05 almasalah kernel: [354160.556373] [ 856] 0 856 4776 23 0 0 0 cron
Nov 19 14:49:05 almasalah kernel: [354160.556375] [ 857] 0 857 4225 0 0 0 0 atd
Nov 19 14:49:05 almasalah kernel: [354160.556377] [ 860] 103 860 46892 0 0 0 0 whoopsie
Nov 19 14:49:05 almasalah kernel: [354160.556380] [ 926] 0 926 3944 1 0 0 0 getty
Nov 19 14:49:05 almasalah kernel: [354160.556383] [ 7896] 0 7896 4308 21 0 0 0 upstart-udev-br
Nov 19 14:49:05 almasalah kernel: [354160.556385] [ 7898] 0 7898 5334 0 0 -17 -1000 udevd
Nov 19 14:49:05 almasalah kernel: [354160.556388] [ 8202] 0 8202 101021 136 0 0 0 apache2
Nov 19 14:49:05 almasalah kernel: [354160.556391] [25624] 33 25624 114948 3053 0 0 0 apache2
Nov 19 14:49:05 almasalah kernel: [354160.556393] [25625] 33 25625 114938 3487 0 0 0 apache2
Nov 19 14:49:05 almasalah kernel: [354160.556396] [25626] 33 25626 114938 2918 0 0 0 apache2
Nov 19 14:49:05 almasalah kernel: [354160.556398] [25631] 33 25631 114938 2878 0 0 0 apache2
Nov 19 14:49:05 almasalah kernel: [354160.556401] [25632] 33 25632 114938 2769 0 0 0 apache2
Nov 19 14:49:05 almasalah kernel: [354160.556403] [25633] 33 25633 114944 3324 0 0 0 apache2
Nov 19 14:49:05 almasalah kernel: [354160.556405] [25634] 33 25634 114938 4325 0 0 0 apache2
Nov 19 14:49:05 almasalah kernel: [354160.556408] [25635] 33 25635 114939 2927 0 0 0 apache2
Nov 19 14:49:05 almasalah kernel: [354160.556410] [25636] 33 25636 114938 3273 0 0 0 apache2
Nov 19 14:49:05 almasalah kernel: [354160.556413] [25637] 33 25637 114940 3198 0 0 0 apache2
Nov 19 14:49:05 almasalah kernel: [354160.556415] [25638] 33 25638 114938 3995 0 0 0 apache2
Nov 19 14:49:05 almasalah kernel: [354160.556418] [25647] 33 25647 114938 4259 0 0 0 apache2
Nov 19 14:49:05 almasalah kernel: [354160.556420] [25648] 33 25648 107254 5004 0 0 0 apache2
Nov 19 14:49:05 almasalah kernel: [354160.556423] [25649] 33 25649 107254 5447 0 0 0 apache2
Nov 19 14:49:05 almasalah kernel: [354160.556426] [25650] 33 25650 114809 8622 0 0 0 apache2
Nov 19 14:49:05 almasalah kernel: [354160.556428] [25651] 33 25651 114809 8417 0 0 0 apache2
Hope to get some reply from you guys.
 
Old 11-19-2012, 09:03 AM   #6
unSpawn
Moderator
 
Registered: May 2001
Posts: 27,304
Blog Entries: 54

Rep: Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856
What to say? The VM ran out of memory and then out of swap at which point it started killing processes. 4 GB RAM "should be enough" to run Joomla so the question is what system and service configuration modifications you made (for example some people think that when Apache complains about memory they should multiply all configuration values w/o diagnosis as if that should help), what "one website, Based on Joomla" means (is it brand new, does it contain a gazillion badly written homebrewn scripts, is it a migration meaning, did it previously run on its own physical hardware, is it well-developed, etc, etc?), if system and daemon logs show errors / clues and what metrics you're going to watch using which tools (Apachetop, mtop aka MySQL top, Atop, Dstat, collectl, etc, etc)...
 
Old 11-19-2012, 09:42 AM   #7
Tarikc
Member
 
Registered: May 2009
Distribution: CentOS
Posts: 50

Original Poster
Rep: Reputation: 2
Hello unSpawn,
That is exactly what happened, the server just went into the same thing again, and I managed to check the free -m:

Quote:
total used free shared buffers cached
Mem: 3955 3869 85 0 0 43
-/+ buffers/cache: 3840 115
Swap: 4092 3727 365
It is not a brand new website, it was hosted on another location and I backed it up there and migrate it here.

This is what I get from apachetop:
Quote:
last hit: 15:21:14 atop runtime: 0 days, 00:01:00 15:21:16
All: 485 reqs ( 8.4/sec) 4276.7K ( 73.7K/sec) 9029.6B/req
2xx: 260 (53.6%) 3xx: 191 (39.4%) 4xx: 15 ( 3.1%) 5xx: 19 ( 3.9%)
R ( 30s): 343 reqs ( 11.4/sec) 2550.8K ( 85.0K/sec) 7615.1B/req
2xx: 166 (48.4%) 3xx: 160 (46.6%) 4xx: 8 ( 2.3%) 5xx: 9 ( 2.6%)
Can you please let me know what config I can do on apache to improve it?

Thank you a million in advance.
 
Old 11-19-2012, 10:23 AM   #8
unSpawn
Moderator
 
Registered: May 2001
Posts: 27,304
Blog Entries: 54

Rep: Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856
Do read me saying "the question is" as an invitation to be methodical about it and be verbose sharing information:
- Which system and service configuration modifications have you made?
- What were the HW specs of the old location?
- Did the web site exhibit problems there too?
- What is the Apache version? Is it up to date?
- Did you increase any values in your Apache configuration?
- What worker type is Apache running?
- What is the PHP version? Is it up to date?
- How do you use PHP? As FastCGI or mod_php?
- Did you increase any resource settings in your PHP configuration?
- What is the Joomla version? Is it up to date?
- Does the web site run any outdated / risky / unnecessary mambots / agents / extensions / components?
- Have you looked at system and daemon logs for errors and clues?
- Do you know what the standard requirements for Joomla are? In which way do the configuration files deviate from those standards?
- Which documentation do you use to troubleshoot the problem?
- What system counters are you going to watch over time to start diagnosing the problem?
- Which tools are you going to use?
 
Old 11-19-2012, 11:05 AM   #9
Tarikc
Member
 
Registered: May 2009
Distribution: CentOS
Posts: 50

Original Poster
Rep: Reputation: 2
Dear unSpawn,

I know you are going to hate me for this,
But I'm kinda newbie with this, I generally do not alter any config in apache, i only set virtual hosts on it.

- i made no system modification, i only changed my.cnf as suggested my the mysqltuner suggestions.
- I honestly don't know what was the older config, i got the backup files from the old host.
- The old website was rumning very slow on the old host, but i haven't heard of a problem on that old host.
- Apache version is 2.2.22, I only updated it yesterday.
- The worker is prefork
- php version 5.3.10
- I haven't made any modification to the php conf.
- I can't really tell if the website running any outdated version/risky components.
- Joomla is 2.5.6
- I tried to search for any clues and logs on the system, but couldn't find anything on neither apache, mysql, or syslog.

Just let me know if it is an apache configuration so i can dig in and try to find a solution and make some changes,

I'm sorry if I'm waisting your time, but I might make use of any kind of any kind of hints and clues.
 
Old 11-19-2012, 09:01 PM   #10
unSpawn
Moderator
 
Registered: May 2001
Posts: 27,304
Blog Entries: 54

Rep: Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856
Performance tuning is more than tweaking just one setting in each configuration file: there is no "magical" key to turn to make everything right and you will have to work hard to understand all the aspects involved. For example if you made no alterations then Apache will be running with all modules enabled and with default settings, PHP may be wasting memory on Innodb while it's not being used and the site may be rife with mambots or SEF rewrites that bug everything down. I'm going to ask you put in some effort and do your own research first: search the 'net and check the Apache, PHP, MySQL and Joomla web sites for performance-related recoomendations. Post what URI's you judge relevant here, along with the contents of your Apache, PHP and MySQL configuration files (strip out comments by running grep -v ^# /path/application.conf|grep .) and the sites settings you find in the Joomla administrator menu. With respect to the latter you should of course obfuscate any identifying information. Meanwhile run Logwatch on the available system and daemon logs, let ApacheTop and MySQLTop run as long as possible, run FPA (easier overview of Joomla administrator settings) and save all information for posting (text preferred over screen shots).
 
Old 11-21-2012, 12:59 AM   #11
Tarikc
Member
 
Registered: May 2009
Distribution: CentOS
Posts: 50

Original Poster
Rep: Reputation: 2
Dear unSpawn,

Again thank you very much for bearing with me, and thank you for your patience.

As instructed, I googled for tuning apache configuration, I have found as you said, that the apache is running all three modules, while it was compiled only with prefork module, so I have disabled the worker and the event modules, thinking of course that they might consume some memory.

This is the tutorial I followed for the apache tuning:

http://cloudinservice.com/tune-apach...refork-module/

As for the MySQL, I disabled InnoDB from the my.cnf, but the server did not start syslog says:
Quote:
type=1400 audit(1353479417.923:13): apparmor="STATUS" operation="profile_replace" name="/usr/sbin/mysqld" pid=12216 comm="apparmor_parser"
init: mysql main process (12220) terminated with status 1
init: mysql respawning too fast, stopped
So I have re-enabled the InnoDB Engine.

This is the Forum I followed for the MySQL tuning:

http://forums.cpanel.net/f189/mysql-...lp-174272.html

As for the contents of the configuration files:

Apache2 configuration file:

Quote:
LockFile ${APACHE_LOCK_DIR}/accept.lock

PidFile ${APACHE_PID_FILE}

Timeout 300

KeepAlive On

MaxKeepAliveRequests 100

KeepAliveTimeout 5


<IfModule mpm_prefork_module>
StartServers 5
MinSpareServers 5
MaxSpareServers 10
MaxClients 150
MaxRequestsPerChild 100
</IfModule>

User ${APACHE_RUN_USER}
Group ${APACHE_RUN_GROUP}


AccessFileName .htaccess

<Files ~ "^\.ht">
Order allow,deny
Deny from all
Satisfy all
</Files>

DefaultType None


HostnameLookups Off

ErrorLog ${APACHE_LOG_DIR}/error.log

LogLevel warn

Include mods-enabled/*.load
Include mods-enabled/*.conf

Include httpd.conf

Include ports.conf

LogFormat "%v:%p %h %l %u %t \"%r\" %>s %O \"%{Referer}i\" \"%{User-Agent}i\"" vhost_combined
LogFormat "%h %l %u %t \"%r\" %>s %O \"%{Referer}i\" \"%{User-Agent}i\"" combined
LogFormat "%h %l %u %t \"%r\" %>s %O" common
LogFormat "%{Referer}i -> %U" referer
LogFormat "%{User-agent}i" agent


Include conf.d/

Include sites-enabled/
php.ini <located in /etc/php5/apache2/>

Quote:
[PHP]
engine = On
short_open_tag = On
asp_tags = Off
precision = 14
y2k_compliance = On
output_buffering = 4096
zlib.output_compression = Off
implicit_flush = Off
unserialize_callback_func =
serialize_precision = 17
allow_call_time_pass_reference = Off
safe_mode = Off
safe_mode_gid = Off
safe_mode_include_dir =
safe_mode_exec_dir =
safe_mode_allowed_env_vars = PHP_
safe_mode_protected_env_vars = LD_LIBRARY_PATH
disable_functions = pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,p cntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_err or,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriorit y,pcntl_setpriority,
disable_classes =
zend.enable_gc = On
expose_php = On
max_execution_time = 30
max_input_time = 60
memory_limit = 128M
error_reporting = E_ALL & ~E_DEPRECATED
display_errors = Off
display_startup_errors = Off
log_errors = On
log_errors_max_len = 1024
ignore_repeated_errors = Off
ignore_repeated_source = Off
report_memleaks = On
track_errors = Off
html_errors = Off
variables_order = "GPCS"
request_order = "GP"
register_globals = Off
register_long_arrays = Off
register_argc_argv = Off
auto_globals_jit = On
post_max_size = 8M
magic_quotes_gpc = Off
magic_quotes_runtime = Off
magic_quotes_sybase = Off
auto_prepend_file =
auto_append_file =
default_mimetype = "text/html"
doc_root =
user_dir =
enable_dl = Off
file_uploads = On
upload_max_filesize = 2M
max_file_uploads = 20
allow_url_fopen = On
allow_url_include = Off
default_socket_timeout = 60
[Date]
[filter]
[iconv]
[intl]
[sqlite]
[sqlite3]
[Pcre]
[Pdo]
[Pdo_mysql]
pdo_mysql.cache_size = 2000
pdo_mysql.default_socket=
[Phar]
[Syslog]
define_syslog_variables = Off
[mail function]
SMTP = localhost
smtp_port = 25
mail.add_x_header = On
[SQL]
sql.safe_mode = Off
[ODBC]
odbc.allow_persistent = On
odbc.check_persistent = On
odbc.max_persistent = -1
odbc.max_links = -1
odbc.defaultlrl = 4096
odbc.defaultbinmode = 1
[Interbase]
ibase.allow_persistent = 1
ibase.max_persistent = -1
ibase.max_links = -1
ibase.timestampformat = "%Y-%m-%d %H:%M:%S"
ibase.dateformat = "%Y-%m-%d"
ibase.timeformat = "%H:%M:%S"
[MySQL]
mysql.allow_local_infile = On
mysql.allow_persistent = On
mysql.cache_size = 2000
mysql.max_persistent = -1
mysql.max_links = -1
mysql.default_port =
mysql.default_socket =
mysql.default_host =
mysql.default_user =
mysql.default_password =
mysql.connect_timeout = 60
mysql.trace_mode = Off
[MySQLi]
mysqli.max_persistent = -1
mysqli.allow_persistent = On
mysqli.max_links = -1
mysqli.cache_size = 2000
mysqli.default_port = 3306
mysqli.default_socket =
mysqli.default_host =
mysqli.default_user =
mysqli.default_pw =
mysqli.reconnect = Off
[mysqlnd]
mysqlnd.collect_statistics = On
mysqlnd.collect_memory_statistics = Off
[OCI8]
[PostgreSQL]
pgsql.allow_persistent = On
pgsql.auto_reset_persistent = Off
pgsql.max_persistent = -1
pgsql.max_links = -1
pgsql.ignore_notice = 0
pgsql.log_notice = 0
[Sybase-CT]
sybct.allow_persistent = On
sybct.max_persistent = -1
sybct.max_links = -1
sybct.min_server_severity = 10
sybct.min_client_severity = 10
[bcmath]
bcmath.scale = 0
[browscap]
[Session]
session.save_handler = files
session.use_cookies = 1
session.use_only_cookies = 1
session.name = PHPSESSID
session.auto_start = 0
session.cookie_lifetime = 0
session.cookie_path = /
session.cookie_domain =
session.cookie_httponly =
session.serialize_handler = php
session.gc_probability = 0
session.gc_divisor = 1000
session.gc_maxlifetime = 1440
session.bug_compat_42 = Off
session.bug_compat_warn = Off
session.referer_check =
session.entropy_length = 0
session.cache_limiter = nocache
session.cache_expire = 180
session.use_trans_sid = 0
session.hash_function = 0
session.hash_bits_per_character = 5
url_rewriter.tags = "a=href,area=href,frame=src,input=src,form=fakeentry"
[MSSQL]
mssql.allow_persistent = On
mssql.max_persistent = -1
mssql.max_links = -1
mssql.min_error_severity = 10
mssql.min_message_severity = 10
mssql.compatability_mode = Off
mssql.secure_connection = Off
[Assertion]
[COM]
[mbstring]
[gd]
[exif]
[Tidy]
tidy.clean_output = Off
[soap]
soap.wsdl_cache_enabled=1
soap.wsdl_cache_dir="/tmp"
soap.wsdl_cache_ttl=86400
soap.wsdl_cache_limit = 5
[sysvshm]
[ldap]
ldap.max_links = -1
[mcrypt]
[dba]
[xsl]
my.cnf configuration file:

Quote:
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock


[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0

[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
bind-address = 127.0.0.1
key_buffer = 384M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 8
myisam-recover = BACKUP
max_connections = 600
table_cache = 512
query_cache_limit = 1M
query_cache_size = 64M
general_log_file = /var/log/mysql/mysql.log
general_log = 1
log_slow_queries = /var/log/mysql/mysql-slow.log
long_query_time = 2
log-queries-not-using-indexes
expire_logs_days = 10
max_binlog_size = 100M



[mysqldump]
quick
quote-names
max_allowed_packet = 16M

[mysql]
no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
key_buffer = 128M
sort_buffer_size=128M
read_buffer=2M
write_buffer=2M

!includedir /etc/mysql/conf.d/
FPA Report file:

Quote:
Originally Posted by Forum Post Assistant (v1.2.3) : 21st November 2012
Quote:
Originally Posted by Basic Environment ::
Joomla! Instance :: Joomla! 2.5.6-Stable (Ember) 19-June-2012
Joomla! Platform :: Joomla Platform 11.4.0-Stable (Brian Kernighan) 03-Jan-2012
Joomla! Configured :: Yes | Writable (644) | Owner: www-data (uid: 1/gid: 1) | Group: www-data (gid: 1) | Valid For: 1.5
Configuration Options :: Offline: 0 | SEF: 1 | SEF Suffix: 1 | SEF ReWrite: 0 | .htaccess/web.config: Yes | GZip: 0 | Cache: 0 | FTP Layer: 0 | SSL: 0 | Error Reporting: default | Site Debug: 0 | Language Debug: 0 | Default Access: N/A | Unicode Slugs: N/A | Database Credentials Present: Yes

Host Configuration :: OS: Linux | OS Version: 3.2.0-29-generic | Technology: x86_64 | Web Server: Apache/2.2.22 (Ubuntu) | Encoding: gzip, deflate | Doc Root: /var/www | System TMP Writable: Yes

PHP Configuration :: Version: 5.3.10-1ubuntu3.4 | PHP API: apache2handler | Session Path Writable: Unknown | Display Errors: | Error Reporting: 22527 | Log Errors To: | Last Known Error: | Register Globals: | Magic Quotes: | Safe Mode: | Open Base: | Uploads: 1 | Max. Upload Size: 2M | Max. POST Size: 8M | Max. Input Time: 60 | Max. Execution Time: 30 | Memory Limit: 128M

MySQL Configuration :: Version: 5.5.28-0ubuntu0.12.04.2-log (Client:5.5.28) | Host: --protected-- (--protected--) | Collation: latin1_swedish_ci (Character Set: latin1) | Database Size: 118.02 MiB | #of*Tables:* 108
Quote:
Originally Posted by Detailed Environment ::
PHP Extensions :: Core (5.3.10-1ubuntu3.4) | date (5.3.10-1ubuntu3.4) | ereg () | libxml () | openssl () | pcre () | zlib (1.1) | bcmath () | bz2 () | calendar () | ctype () | dba () | dom (20031129) | hash (1.0) | fileinfo (1.0.5-dev) | filter (0.11.0) | ftp () | gettext () | SPL (0.2) | iconv () | json (1.2.1) | mbstring () | session () | posix () | Reflection ($Revision: 321634 $) | standard (5.3.10-1ubuntu3.4) | shmop () | SimpleXML (0.1) | soap () | sockets () | Phar (2.0.1) | exif (1.4 $Id: exif.c 321634 2012-01-01 13:15:04Z felipe $) | sysvmsg () | sysvsem () | sysvshm () | tokenizer (0.1) | wddx () | xml () | xmlreader (0.1) | xmlwriter (0.1) | zip (1.9.1) | apache2handler () | curl () | gd () | imagick (3.1.0RC1) | imap () | intl (1.1.0) | mcrypt () | memcache (3.0.6) | ming () | mysql (1.0) | mysqli (0.1) | PDO (1.0.4dev) | pdo_mysql (1.0.2) | pdo_sqlite (1.0.1) | ps () | pspell () | recode () | snmp () | sqlite3 (0.7-dev) | tidy (2.0) | xmlrpc (0.51) | xsl (0.1) | mhash () | Zend Engine (2.3.0) |
Potential Missing Extensions :: suhosin |

Switch User Environment (Experimental) :: PHP CGI: No | Server SU: No | PHP SU: No | Custom SU (LiteSpeed/Cloud/Grid): Yes
Potential Ownership Issues: No

Apache Modules :: core | mod_log_config | mod_logio | prefork | http_core | mod_so | mod_alias | mod_auth_basic | mod_authn_file | mod_authz_default | mod_authz_groupfile | mod_authz_host | mod_authz_user | mod_autoindex | mod_cgi | mod_deflate | mod_dir | mod_env | mod_mime | mod_negotiation | mod_php5 | mod_reqtimeout | mod_setenvif | mod_status | Apache/2.2.22 (Ubuntu) |
Potential Missing Modules :: mod_rewrite | mod_expires | mod_security | mod_evasive | mod_dosevasive | mod_ssl | mod_qos | mod_userdir |
Quote:
Originally Posted by Folder Permissions ::
Core Folders :: images/ (755) | components/ (755) | modules/ (755) | plugins/ (755) | language/ (755) | templates/ (755) | cache/ (755) | logs/ (755) | tmp/ (755) | administrator/components/ (755) | administrator/modules/ (755) | administrator/language/ (755) | administrator/templates/ (755) |

Elevated Permissions (First 10) :: plugins/acepolls/ (777) | plugins/content/jw_sigpro/jw_sigpro/includes/js/jquery_prettyphoto/images/prettyPhoto/ (777) | plugins/content/jw_sigpro/jw_sigpro/tmpl/ (777) | plugins/content/multithumb/language/ (777) | plugins/content/multithumb/prettyPhoto/ (777) | plugins/content/multithumb/prettyPhoto/images/ (777) | plugins/content/multithumb/prettyPhoto/images/prettyPhoto/ (777) | plugins/content/multithumb/slimbox/ (777) | plugins/jmonitoring/ (777) | plugins/n3ttemplate/ (777) |
Quote:
Originally Posted by Extensions Discovered ::
Components :: SITE :: com_mailto (2.5.0) | com_wrapper (2.5.0) | WF_FILESYSTEM_JOOMLA_TITLE (2.2.4) | K2 Links for Advanced Link (2.1) | WF_LINKS_JOOMLALINKS_TITLE (2.2.4) | WF_MEDIAPLAYER_JCEPLAYER_TITLE (2.2.4) | WF_POPUPS_JCEMEDIABOX_TITLE (2.2.4) | WF_POPUPS_ROKBOX_TITLE (2.0.0) | WF_POPUPS_WINDOW_TITLE (2.2.4) | WF_LINK_SEARCH_TITLE (2.2.4) | WF_AGGREGATOR_VIMEO_TITLE (2.2.4) | WF_AGGREGATOR_YOUTUBE_TITLE (2.2.4) | WF_LINK_TITLE (2.2.4) | WF_TEXTCASE_TITLE (2.2.4) | WF_BROWSER_TITLE (2.2.4) | WF_ARTICLE_TITLE (2.2.4) | WF_PASTE_TITLE (2.2.4) | WF_IFRAME_TITLE (2.0.1) | WF_FULLPAGE_TITLE (2.0.1) | WF_AUTOSAVE_TITLE (2.2.4) | WF_MEDIAMANAGER_TITLE (2.0.7) | WF_NONBREAKING_TITLE (2.2.4) | WF_SPELLCHECKER_TITLE (2.2.4) | WF_FILEMANAGER_TITLE (2.0.11) | WF_IMGMANAGER_EXT_TITLE (2.0.9) | WF_CAPTION_TITLE (2.0.3) | WF_TABLE_TITLE (2.2.4) | WF_PREVIEW_TITLE (2.2.4) | WF_CLEANUP_TITLE (2.2.4) | WF_TEMPLATEMANAGER_TITLE (2.0.3) | WF_DIRECTIONALITY_TITLE (2.2.4) | WF_IMGMANAGER_TITLE (2.2.4) | WF_FULLSCREEN_TITLE (2.2.4) | WF_PRINT_TITLE (2.2.4) | WF_VISUALCHARS_TITLE (2.2.4) | WF_XHTMLXTRAS_TITLE (2.2.4) | WF_STYLE_TITLE (2.2.4) | WF_SEARCHREPLACE_TITLE (2.2.4) | WF_LAYER_TITLE (2.2.4) | WF_VISUALBLOCKS_TITLE (2.2.4) | WF_ANCHOR_TITLE (2.2.4) | WF_KITCHENSINK_TITLE (2.2.4) | WF_CONTEXTMENU_TITLE (2.2.4) | WF_INLINEPOPUPS_TITLE (2.2.4) | WF_SOURCE_TITLE (2.2.4) | WF_MEDIA_TITLE (2.2.4) | JCE_JBTYPE_TITLE (2.0.4) | WF_EMOTIONS_TITLE (2.0.1) |
Components :: ADMIN :: com_media (2.5.0) | com_languages (2.5.0) | com_finder (2.5.0) | RokModule (1.3) | com_admin (2.5.0) | AcePolls (1.0.8) | com_messages (2.5.0) | com_newsfeeds (2.5.0) | com_content (2.5.0) | com_categories (2.5.0) | com_plugins (2.5.0) | com_modules (2.5.0) | com_checkin (2.5.0) | com_config (2.5.0) | Unknown (-) | Editor - JCE (2.2.4) | JCE File Browser (2.0.0) | plg_quickicon_jcefilebrowser (2.5.0) | JCE (2.2.4) | com_cpanel (2.5.0) | com_menus (2.5.0) | com_redirect (2.5.0) | Akeeba (3.6.5) | com_weblinks (2.5.0) | JComments (2.3.0) | jsecure (2.1.10) | RSForm (1.4.0 R43) | com_installer (2.5.0) | com_search (2.5.0) | com_cache (2.5.0) | com_login (2.5.0) | com_banners (2.5.0) | com_joomlaupdate (2.5.0) | com_users (2.5.0) | com_templates (2.5.0) |

Modules :: SITE :: mod_wrapper (2.5.0) | IceMegaMenu Module (1.6.0) | Klixo Articles Slider (1.0.1) | mod_menu (2.5.0) | mod_articles_news (2.5.0) | mod_feed (2.5.0) | YouBricks Engine (1.0) | mod_footer (2.5.0) | VTEM NewsRoll (1.1) | MOD_NEWSCALENDAR (1.1.0) | mod_articles_popular (2.5.0) | SP Tab (1.7.0) | mod_related_items (2.5.0) | VTEM News Boxs (1.1) | mod_banners (2.5.0) | Flexi Custom Code (1.3) | JComments Latest Commented (1.0) | JA Bulletin (2.5.0) | mod_weather_gk4 (GK4 1.6.3) | mod_articles_categories (2.5.0) | mod_fj_related_plus (1.03) | mod_articles_category (2.5.0) | JA News Featured (2.5.0) | IceScroller Module (2.5.0) | Featured YouTube Slider (2.1) | mod_random_image (2.5.0) | IceCarousel Module (2.5.3) | mod_finder (2.5.0) | Date2 (2.2.34b) | Visitors Counter (2.0.2) | mod_stats (2.5.0) | mod_users_latest (2.5.0) | Vinaora Visitors Counter (2.5.1) | mod_weblinks (2.5.0) | MOD_SCONTENT_NAME (1.1.1) | mod_search (2.5.0) | Youretro Slider (1.0) | mod_custom (2.5.0) | MOD_QUICKNAVIGATION (1.5.5) | RokAjaxSearch (1.1) | mod_articles_archive (2.5.0) | mod_breadcrumbs (2.5.0) | Global News (2.5.0) | JomLand NewsSlider (1.6.0) | mod_syndicate (2.5.0) | AcePolls (1.0.0) | VTEM Skitter (1.0) | mod_login (2.5.0) | VTEM News Show (1.1) | Slideshow Pro SP2 (2.0.0) | News Show SP2 (1.8.0) | mod_articles_latest (2.5.0) | mod_whosonline (2.5.0) | mod_highlighter_gk4 (GK4 1.9) | News Show SP1 (1.6.0) | mod_languages (2.5.0) |
Modules :: ADMIN :: mod_status (2.5.0) | mod_menu (2.5.0) | mod_feed (2.5.0) | mod_latest (2.5.0) | mod_logged (2.5.0) | mod_submenu (2.5.0) | mod_quickicon (2.5.0) | mod_title (2.5.0) | mod_toolbar (2.5.0) | mod_version (2.5.0) | mod_custom (2.5.0) | mod_multilangstatus (2.5.0) | Kenda QuickIcons (2.1.1 Beta) | mod_popular (2.5.0) | mod_login (2.5.0) |

Plugins :: SITE :: plg_content_pagenavigation (2.5.0) | plg_content_jcomments (1.0) | Multithumb (3.1.0) | plg_content_emailcloak (2.5.0) | PLG_CONTENT_EXTRAVOTE (1.6.0) | plg_content_joomla (2.5.0) | Simple Image Gallery Pro (by J (2.5.7) | plg_content_geshi (2.5.0) | Content - Load AcePolls (1.0.0) | Content - RokBox (1.2) | PLG_CONTENT_SCONTENT (1.1.1) | plg_content_loadmodule (2.5.0) | plg_content_finder (2.5.0) | ShareThis (4.1.0) | plg_content_vote (2.5.0) | plg_content_pagebreak (2.5.0) | PLG_JMONITORING_AKEEBABACKUP_T (1.0) | plg_editors-xtd_article (2.5.0) | plg_editors-xtd_jcommentsoff (1.0) | plg_editors-xtd_image (2.5.0) | plg_editors-xtd_readmore (2.5.0) | plg_editors-xtd_pagebreak (2.5.0) | plg_editors-xtd_jcommentson (1.0) | plg_captcha_recaptcha (2.5.0) | AcePolls - AlphaUserPoints (1.0.0) | AcePolls - Mighty Touch (1.0.0) | AcePolls - JomSocial (1.0.0) | plg_finder_weblinks (2.5.0) | plg_finder_content (2.5.0) | plg_finder_newsfeeds (2.5.0) | plg_finder_categories (2.5.0) | plg_finder_contacts (2.5.0) | plg_search_weblinks (2.5.0) | plg_search_jcomments (1.0) | plg_search_content (2.5.0) | plg_search_newsfeeds (2.5.0) | plg_search_categories (2.5.0) | plg_search_contacts (2.5.0) | Search - AcePolls (1.0.0) | plg_authentication_ldap (2.5.0) | plg_authentication_joomla (2.5.0) | plg_authentication_gmail (2.5.0) | plg_editors_tinymce (3.5.2) | Editor - JCE (2.2.4) | plg_editors_codemirror (1.0) | Shadowbox Media Viewer (4.0) | plg_system_logout (2.5.0) | IceMegaMenu Plugin (1.6.0) | plg_system_redirect (2.5.0) | plg_system_debug (2.5.0) | plg_system_highlight (2.5.0) | plg_system_jcomments (1.0) | plg_system_sef (2.5.0) | plg_system_log (2.5.0) | plg_sys_topofthepage (1.16) | System - Ice Speed (1.7.0) | System - RokExtender (1.0) | System - RokBox (1.2) | System - AntiCopy (1.5) | System - jSecure Authenticatio (2.1.10) | plg_system_languagecode (2.5.0) | System - JA Tabs (2.5.4) | plg_system_remember (2.5.0) | System - JCE MediaBox (1.1.4) | plg_system_languagefilter (2.5.0) | plg_system_p3p (2.5.0) | System - JB Type (1.5.10) | System - Admin Forever (0.9.2) | plg_system_cache (2.5.0) | plg_extension_joomla (2.5.0) | plg_quickicon_joomlaupdate (2.5.0) | plg_quickicon_extensionupdate (2.5.0) | plg_quickicon_jcefilebrowser (2.5.0) | plg_user_profile (2.5.0) | plg_user_jcomments (1.0) | plg_user_joomla (2.5.0) | plg_user_contactcreator (2.5.0) |
Quote:
Originally Posted by Templates Discovered ::
Templates :: SITE :: omnix (1.0) |
Templates :: ADMIN :: bluestork (2.5.0) | VTEM Admin (1.1) | hathor (2.5.0) |
I hope I did not miss anything.

Again, thank you very much for your time.

Best Regards,
 
Old 11-21-2012, 10:06 AM   #12
unSpawn
Moderator
 
Registered: May 2001
Posts: 27,304
Blog Entries: 54

Rep: Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856
Quote:
Originally Posted by Tarikc View Post
I have found as you said, that the apache is running all three modules, while it was compiled only with prefork module, so I have disabled the worker and the event modules, thinking of course that they might consume some memory. This is the tutorial I followed for the apache tuning: http://cloudinservice.com/tune-apache-performance-using-mpm-prefork-module/
OK. Let's start with the web server first. The link you point to is good because that it explains the method behind deriving values based on your actual situation. However it doesn't explain all values (see for instance this or this) and the effect it has (or should have) on how you configure your my.cnf next. Also I don't know if you logged process and memory data before and after the changes or if you actually derived your posted values from it and if you looked at changes in resource usage. The thing is that adjusting (in small increments) by making changes and comparing data is the kind of process you need to go through: take the "original" httpd.conf and log process and memory usage and consider that your baseline data. Create a backup of httpd.conf, make changes, restart the web server, hit the server with traffic (there's tools for that), log process and memory usage. Then compare both process and memory usage sets. Rinse, repeat.

Also note your httpd.conf lists several includes. While they may not hold surprises it's good to actually inspect them and ensure they don't. In the meanwhile I do hope you still collect data with at least ApacheTop and MySQLTop because the longer the period the better averages you have to base decisions on. Also please check your FPA extensions output (well done for posting) against http://docs.joomla.org/Vulnerable_Extensions_List please and correct the listed access rights (777 is too much), see http://docs.joomla.org/Security_Chec...le_permissions for an explanation (do read the whole page though).


Do persevere! This may seem like small steps now but once you notice the effect it has you know the effort wasn't wasted.
 
Old 11-21-2012, 12:00 PM   #13
Tarikc
Member
 
Registered: May 2009
Distribution: CentOS
Posts: 50

Original Poster
Rep: Reputation: 2
Dear unSpawn,

I don't know how to thank you for your replies, and I can't say how much it makes me happy to know that I might be somehow on the right track to solve my problems,

I have changed more on the apache config, the site is a little bit getting improved, stalling a little but not freezing, memory consumption is much better, I might increase the limits on the prefork module a little bit until I get a satisfied results.

As for the apachetop, I am running it till now, but wanted to share this results with you, as honestly I searched for the tool to have something useful to learn about it, but didn't hit anything:

Quote:
last hit: 17:53:02 atop runtime: 0 days, 01:18:47 17:53:03
All: 64097 reqs ( 13.6/sec) 604.1M ( 130.9K/sec) 9882.7B/req
2xx: 46532 (72.6%) 3xx: 14302 (22.3%) 4xx: 1335 ( 2.1%) 5xx: 1928 ( 3.0%)
R ( 30s): 115 reqs ( 3.8/sec) 1544.0K ( 51.5K/sec) 13.4K/req
2xx: 48 (41.7%) 3xx: 59 (51.3%) 4xx: 4 ( 3.5%) 5xx: 4 ( 3.5%)
I will post the mytop results soon.

I really wish I will have to mark this problem as solved .

Thank you a million times for your extraordinary help.

Best Regards,
 
Old 11-21-2012, 01:11 PM   #14
Tarikc
Member
 
Registered: May 2009
Distribution: CentOS
Posts: 50

Original Poster
Rep: Reputation: 2
This the continued apache top monitoring statistics:

Quote:
last hit: 19:04:12 atop runtime: 0 days, 02:29:57 19:04:13
All: 107636 reqs ( 12.0/sec) 1031.0M ( 117.3K/sec) 10044.0B/req
2xx: 78941 (73.3%) 3xx: 23135 (21.5%) 4xx: 2269 ( 2.1%) 5xx: 3291 ( 3.1%)
R ( 30s): 276 reqs ( 9.2/sec) 3562.7K ( 118.8K/sec) 12.9K/req
2xx: 191 (69.2%) 3xx: 74 (26.8%) 4xx: 6 ( 2.2%) 5xx: 5 ( 1.8%)
I'm stopping it now coz I've read it consumes some memory.

But As I understand from what I see, it is http requests, 2xx OK, 4xx contains 404 not found.
And All: number of requests?

but what should I make use of it?

And what is R on the third row stands for?

Do you think that I may reduce the timeout to less time and increase MaxClients directive?
Coz I see from the top command, that apache processes are staying alive and dies after some time, at which time the website is a little bit stales.

But this is just me , or you suggest to try it myself and check?

Best Regards,
 
Old 11-21-2012, 07:54 PM   #15
unSpawn
Moderator
 
Registered: May 2001
Posts: 27,304
Blog Entries: 54

Rep: Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856Reputation: 2856
Quote:
Originally Posted by Tarikc View Post
I have changed more on the apache config, the site is a little bit getting improved, stalling a little but not freezing, memory consumption is much better, I might increase the limits on the prefork module a little bit until I get a satisfied results.
Usually you'll want to measure, lower values, put the pressure on, measure again. Also consider the other processes you still need to look at before enthusiastically tuning things for "performance". Because what if new insights mean the values in php.ini and my.cnf actually need to be increased? Doing that and increasing httpd.conf values simultaneously may be actually bad for performance. That's why you need to log data.


Quote:
Originally Posted by Tarikc View Post
I really wish I will have to mark this problem as solved
What's the rush? And think of it as gaining knowledge instead.


Quote:
Originally Posted by Tarikc View Post
This the continued apache top monitoring statistics:
I'm stopping it now coz I've read it consumes some memory.
No, you're running with default settings, should be OK.


Quote:
Originally Posted by Tarikc View Post
But As I understand from what I see, it is http requests, 2xx OK, 4xx contains 404 not found.
And All: number of requests?
but what should I make use of it?
And what is R on the third row stands for?
The README for ApacheTop is pretty clear about things: how long it's been running, two lines accumulated data and two lines of stats in the last 30 seconds. Note nearly 25 per cent of your traffic isn't 2xx with over 20 per cent of redirects (usually 301: Moved Permanently / 302: Moved Temporarily). This may be due to .htaccess rewrites (or in httpd conf's we didn't see) or some SEO plug-in: best look at the 3xx messages in access_log.


Quote:
Originally Posted by Tarikc View Post
Do you think that I may reduce the timeout to less time and increase MaxClients directive?
Lower timeouts seems a good thing and I let the link I gave you before argue against increasing MaxClients.


Quote:
Originally Posted by Tarikc View Post
Coz I see from the top command, that apache processes are staying alive and dies after some time,
That is the effect of the MPM you chose. Having children start costs resources too but OTOH having children die also cleans up memory, keepalives, etc, etc. Have a go at the official Apache MPM docs.


Quote:
Originally Posted by Tarikc View Post
at which time the website is a little bit stales.
Observed how?


Quote:
Originally Posted by Tarikc View Post
But this is just me , or you suggest to try it myself and check?
Heh. You catch on pretty quickly.

BTW one way to look at process details is to use 'top' (or atop, htop or mpstat) but if you need a quick way to isolate the current memory usage of say a process called "apache2" then you could also use 'ps':
Code:
/bin/ps -C apache2 -oppid,pid,pcpu,pmem,sess,rss,vsz,nice,pri,args
In the long run it's better to run any capable SAR like Atop, Dstat or collectl.
 
  


Reply

Tags
apache, mysql, ubuntu


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: How To Set Up WebDAV With MySQL Authentication On Apache2 (Ubuntu 9.10) LXer Syndicated Linux News 0 06-02-2010 07:50 AM
[SOLVED] website not doing anything Using Ubuntu, mysql, apache2, php and firefox as browser drk2009 Linux - Newbie 4 07-30-2009 06:01 AM
LXer: Installing Apache2 With PHP5 And MySQL Support On Ubuntu 9.04 (LAMP) LXer Syndicated Linux News 0 07-28-2009 02:40 PM
Slow ssh connection over lan with Ubuntu Desktop and Ubuntu Server Recursion Linux - Networking 1 05-23-2009 02:17 AM
Problems upgrading MySQL on Ubuntu, with Apache2/PHP4 peruvianllama Linux - Software 0 08-16-2005 09:27 AM


All times are GMT -5. The time now is 03:19 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration