Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I have a webserver hosting 5 joomla websites, one of these has high traffic and is just freezing our server for example an uptime output looks like this

uptime
 17:40:50 up 15:53,  3 users,  load average: 120.69, 110.24, 100.43

I don't know what to twick since I've tried several suggestions found on the web but, the server just keeps crashing.

I'm running this server with debian

cat /proc/cpuinfo
processor       : 0
vendor_id       : AuthenticAMD
cpu family      : 16
model           : 5
model name      : AMD Athlon(tm) II X4 605e Processor
stepping        : 3
cpu MHz         : 2294.960
cache size      : 512 KB
physical id     : 0
siblings        : 4
core id         : 0
cpu cores       : 4
apicid          : 0
initial apicid  : 0
fpu             : yes
fpu_exception   : yes
cpuid level     : 5
wp              : yes
flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext fxsr_opt pdpe1gb rdtscp lm 3dnowext 3dnow constant_tsc rep_good nonstop_tsc extd_apicid pni monitor cx16 popcnt lahf_lm cmp_legacy svm extapic cr8_legacy abm sse4a misalignsse 3dnowprefetch osvw ibs skinit wdt
bogomips        : 4589.91
TLB size        : 1024 4K pages
clflush size    : 64
cache_alignment : 64
address sizes   : 48 bits physical, 48 bits virtual
power management: ts ttp tm stc 100mhzsteps hwpstate

processor       : 1
vendor_id       : AuthenticAMD
cpu family      : 16
model           : 5
model name      : AMD Athlon(tm) II X4 605e Processor
stepping        : 3
cpu MHz         : 2294.960
cache size      : 512 KB
physical id     : 0
siblings        : 4
core id         : 1
cpu cores       : 4
apicid          : 1
initial apicid  : 1
fpu             : yes
fpu_exception   : yes
cpuid level     : 5
wp              : yes
flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext fxsr_opt pdpe1gb rdtscp lm 3dnowext 3dnow constant_tsc rep_good nonstop_tsc extd_apicid pni monitor cx16 popcnt lahf_lm cmp_legacy svm extapic cr8_legacy abm sse4a misalignsse 3dnowprefetch osvw ibs skinit wdt
bogomips        : 4590.16
TLB size        : 1024 4K pages
clflush size    : 64
cache_alignment : 64
address sizes   : 48 bits physical, 48 bits virtual
power management: ts ttp tm stc 100mhzsteps hwpstate

processor       : 2
vendor_id       : AuthenticAMD
cpu family      : 16
model           : 5
model name      : AMD Athlon(tm) II X4 605e Processor
stepping        : 3
cpu MHz         : 2294.960
cache size      : 512 KB
physical id     : 0
siblings        : 4
core id         : 2
cpu cores       : 4
apicid          : 2
initial apicid  : 2
fpu             : yes
fpu_exception   : yes
cpuid level     : 5
wp              : yes
flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext fxsr_opt pdpe1gb rdtscp lm 3dnowext 3dnow constant_tsc rep_good nonstop_tsc extd_apicid pni monitor cx16 popcnt lahf_lm cmp_legacy svm extapic cr8_legacy abm sse4a misalignsse 3dnowprefetch osvw ibs skinit wdt
bogomips        : 4590.13
TLB size        : 1024 4K pages
clflush size    : 64
cache_alignment : 64
address sizes   : 48 bits physical, 48 bits virtual
power management: ts ttp tm stc 100mhzsteps hwpstate

processor       : 3
vendor_id       : AuthenticAMD
cpu family      : 16
model           : 5
model name      : AMD Athlon(tm) II X4 605e Processor
stepping        : 3
cpu MHz         : 2294.960
cache size      : 512 KB
physical id     : 0
siblings        : 4
core id         : 3
cpu cores       : 4
apicid          : 3
initial apicid  : 3
fpu             : yes
fpu_exception   : yes
cpuid level     : 5
wp              : yes
flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext fxsr_opt pdpe1gb rdtscp lm 3dnowext 3dnow constant_tsc rep_good nonstop_tsc extd_apicid pni monitor cx16 popcnt lahf_lm cmp_legacy svm extapic cr8_legacy abm sse4a misalignsse 3dnowprefetch osvw ibs skinit wdt
bogomips        : 4590.16
TLB size        : 1024 4K pages
clflush size    : 64
cache_alignment : 64
address sizes   : 48 bits physical, 48 bits virtual
power management: ts ttp tm stc 100mhzsteps hwpstate

Have 8GB of RAM

I decided to use back the original my.cnf file to see what happens, and now is running that.

What can I do to determine the cause of this?

share|improve this question
    
I'm letting joomla do it's own caching and have set it to 20 minutes. –  Figureo Sfm Sep 5 '13 at 22:01
    
I have a hard time believing that apache or mysql can simply crash a properly configured server no matter what the load. Is it actually going down, or is it just becoming unresponsive to the point that you are hard-rebooting it? Do you not have a swap partition? Load averages are nice and all, but they're meaningless without any stats on CPU and memory usage. Have you checked the system logs? What do they say? –  Sammitch Sep 5 '13 at 23:43
    
Are you doing PHP object caching ? like APC Cache or Xcache. These are object level cache, unlike joomla caches, these can seeped up load/execution time by big factor. Are you using Threaded model or pre-fork ? What is the Disk IO ? Check if apache is segfaulting? if yes, what is the rate ? Also what is the incoming qps ? What is the average latency per requests ? (based on the experience of managing cluster that handled ~3500 qps) –  user390687 Sep 5 '13 at 23:56
    
The servers become unresponsive and sometimes I get "no connection to database error". I know I don't have the server properly configured, that's where the problem is. I restart mysql apache servers and it works for about 15 to 30 minutes depending on traffic. I'm just becoming frustrated since I have to be paying attention all day to the server so users dont get problems when accessing websites. I don't know what to do. –  Figureo Sfm Sep 6 '13 at 3:10
    
I edited a little because we don't really do recommendations for external tutorials, and there isn't such a thing as a "One True Configuration File" for anything (there is a reason stuff is configurable). However, someone might be able to point you in the right direction regarding the root cause. –  Falcon Momot Sep 6 '13 at 4:53

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.