Carico CPU troppo elevato, sito lento!

[Final_Alpha]

Ciao,
ho un problema con il Webserver, su cui è hostato un forum (IP Board).
ho due Server, uno solo per Mysql e l'altro per tutto il resto.

Caratteristiche Servers:

Spoiler

Web Server:
Intel(R) Xeon(R) CPU X3320 @ 2.50GHz
8 GB RAM

MySql Server:
Intel(R) Xeon(R) CPU X3323 @ 2.50GHz
6GB RAM

Collegati fra loro con IP privato.

Il problema è il Webserver come potete vedere dai Process Monitor:

Spoiler

WebServer:
top - 1200 up 5:04, 0 users, load average: 355.21, 325.15, 319.60
Tasks: 585 total, 228 running, 355 sleeping, 0 stopped, 2 zombie
Cpu(s): 84.2%us, 13.3%sy, 0.0%ni, 1.3%id, 0.3%wa, 0.1%hi, 0.8%si, 0.0%st
Mem: 8311792k total, 5721992k used, 2589800k free, 168916k buffers
Swap: 2096472k total, 0k used, 2096472k free, 612672k cached

MysqlServer:
top - 13:10:01 up 34 days, 8:23, 2 users, load average: 0.33, 0.27, 0.30
Tasks: 309 total, 1 running, 308 sleeping, 0 stopped, 0 zombie
Cpu(s): 1.6%us, 1.1%sy, 0.1%ni, 96.6%id, 0.4%wa, 0.0%hi, 0.2%si, 0.0%st
Mem: 6225312k total, 3683916k used, 2541396k free, 629324k buffers
Swap: 2096472k total, 0k used, 2096472k free, 2315164k cached

Invece sotto i Service Monitor:

Spoiler

WebServer:
ServiceStatus directadmindirectadmin (pid 3192 23950 23956 5554 5593 10348 ) dovecotdovecot (pid 3196 ) eximexim (pid 3206 18351 1700 16447 31263 11258 10973 11136 11492 11505 11506 11536 11552 11601 11602 11606 ) httpdhttpd (pid 3262 4045 16065 16222 18173 22112 7069 10334 12468 14903 15463 17575 18936 20218 20219 24837 810 1688 1833 1838 2499 2504 5092 5323 6972 7029 7383 7384 8232 11944 21702 30952 30955 31319 1568 4232 18918 18919 18927 19523 19701 25778 27225 28838 29332 3843 4145 5937 5942 7695 8747 8753 9967 9968 10437 11773 16205 16214 18093 19999 22196 22722 23038 23901 25128 27639 27713 27714 28914 29184 29852 30415 30748 30796 31195 31216 31256 31371 3894 4129 4395 4424 4761 4967 5072 5825 17469 17903 17935 18550 20160 20530 21256 22019 22020 22182 22709 22720 22961 22971 23372 23430 23580 23603 23895 23996 24070 24314 24346 24853 25396 25541 25543 25551 25642 25779 25780 25788 25792 25797 25803 25804 25811 26181 26185 26543 27044 27066 27172 27174 27193 27210 27212 27310 27549 29645 29717 29719 29723 30969 31124 31149 31444 31445 31446 31653 31654 31655 31978 32000 32036 32040 32082 32114 32134 32135 32150 32226 32254 32255 32308 32346 32349 32394 32436 32456 32501 32502 32724 353 564 573 592 604 614 617 623 695 698 707 708 746 747 769 771 885 951 1027 1126 1131 1134 1154 1595 1596 1623 2011 2016 2017 2050 2051 2070 2169 2171 2233 2267 2955 3097 4291 6172 6737 6906 6933 6934 6968 6969 6970 6971 6973 6975 6976 6977 6980 6981 6983 6984 6985 7010 7011 7012 7013 7014 7056 7057 7059 7107 7108 7114 7115 7118 7119 7120 7121 7528 7529 7530 7531 7532 7637 7638 7640 7677 7678 7679 7680 7818 7819 7820 7841 7844 7852 7856 8032 8035 8036 8044 8045 8046 8175 8177 8199 8307 8308 8313 8314 8324 8326 8344 8345 8347 8348 8350 8352 8353 8356 8357 8358 8431 8581 8583 8589 8590 8591 8592 8593 8594 8664 8665 8666 8667 8668 8675 8676 8677 8680 8681 8683 8684 8749 8750 8751 8752 8754 8758 8759 8761 8762 8824 8825 8826 8828 8910 8911 8913 8914 8917 8918 8919 8920 9003 9004 9005 9006 9017 9018 9019 9020 9021 9123 9124 9125 9126 9421 9424 9425 9492 9494 9495 9502 9503 9504 9505 9506 9507 9508 9509 9510 9511 9562 9563 9572 9573 9574 9591 9592 9593 9594 9595 9624 9625 9626 9627 9628 9631 9632 9686 9762 9763 9764 9765 9766 9834 9835 9836 9837 9 lfdProcess is stopped mysqldProcess is stopped namednamed (pid 3086 ) proftpdproftpd (pid 3347 ) sshdsshd (pid 3369 )
MysqlServer

ServiceStatus directadmindirectadmin (pid 15154 16381 16382 16383 16384 16638 ) dovecotdovecot (pid 2425 ) eximexim (pid 2680 ) httpdhttpd (pid 25235 25236 25238 25239 25240 25241 29745 29748 29749 29750 29751 ) mysqldmysqld (pid 16392 16473 16490 16500 16511 16533 16537 16542 16557 16558 16559 16576 16631 18562 18563 18564 18565 18566 18567 18569 18570 18571 18572 ) namednamed (pid 3089 ) proftpdproftpd (pid 15189 ) sshdsshd (pid 2462 18726 30783 )

Nel Webserver uso Apache+Nginx+Xcache, invece nel Mysqlserver solo Apache.

Come posso sapere da dove proviene questo carico, ricordo che il sito è lentissimo,
e risolverlo?


Grazie,
Saluti

[Rebel]

Ci sono varie discussioni che trattano problemi simili. Hai fatto una ricerca?

[Final_Alpha]

Ci sono varie discussioni che trattano problemi simili. Hai fatto una ricerca?

Si, ho letto varie discussioni, ma non sono riuscito a risolvere allora ho deciso di scrivere.

[CoolNetwork]

ma è perennemente preso così con le bombe o lo fa a momenti?

[Final_Alpha]

ma è perennemente preso così con le bombe o lo fa a momenti?

Al mattino è veloce:

Spoiler

top*-*03:32:27*up*20:22,**0*users,**load*average:*9.35, *5.68,*4.68
Tasks:*128*total,**17*running,*111*sleeping,***0*s topped,***0*zombie
Cpu(s):*58.5%us,**9.5%sy,**0.0%ni,*31.4%id,**0.1%w a,**0.1%hi,**0.5%si,**0.0%st
Mem:***8311792k*total,**1060360k*used,**7251432k*f ree,***143032k*buffers
Swap:**2096472k*total,****16872k*used,**2079600k*f ree,***522816k*cached

**PID*USER******PR**NI**VIRT**RES**SHR*S*%CPU*%MEM ****TIME+**COMMAND************
*6773*apache****16***0**560m**25m**16m*S***41**0.3 ***1:18.31*httpd**************
*6761*apache****25***0**574m**37m**15m*R***39**0.5 ***1:54.31*httpd**************
*8088*apache****25***0**582m**42m**13m*R***37**0.5 ***0:54.70*httpd**************
**941*apache****25***0**574m**34m**12m*R***37**0.4 ***0:12.99*httpd**************
*1001*apache****15***0**559m**21m**13m*S***37**0.3 ***0:03.27*httpd**************
*7990*apache****25***0**575m**36m**13m*R***33**0.4 ***0:34.37*httpd**************
17536*apache****25***0**579m**45m**18m*R***29**0.6 ***5:40.69*httpd**************
*6778*apache****15***0**559m**26m**17m*S***29**0.3 ***1:41.54*httpd**************
*7553*apache****25***0**575m**37m**14m*R***25**0.5 ***0:36.72*httpd**************
*6765*apache****25***0**575m**39m**17m*R***19**0.5 ***1:41.50*httpd**************
*1002*apache****15***0**564m**25m**12m*R***17**0.3 ***0:02.47*httpd**************
*7785*apache****15***0**563m**27m**15m*R***15**0.3 ***0:21.09*httpd**************
12688*apache****25***0**584m**47m**16m*R***10**0.6 ***4:22.50*httpd**************
*7992*apache****15***0**559m**22m**13m*S***10**0.3 ***1:20.99*httpd**************
*8091*apache****15***0**564m**27m**14m*R***10**0.3 ***0:27.81*httpd**************
**939*apache****25***0**576m**35m**12m*R***10**0.4 ***0:15.66*httpd**************
*7874*apache****25***0**575m**37m**14m*R****4**0.5 ***0:33.62*httpd**************
*3311*nobody****15***0**4012*2392**740*R****2**0.0 ***1:59.11*nginx**************
**958*apache****15***0**561m**23m**12m*R****2**0.3 ***0:05.46*httpd**************
****1*root******15***0**1944**636**544*S****0**0.0 ***0:02.83*init***************
****2*root******RT***0*****0****0****0*S****0**0.0 ***0:00.02*migration/0********
****3*root******34**19*****0****0****0*R****0**0.0 ***0:00.00*ksoftirqd/0********
****4*root******RT***0*****0****0****0*S****0**0.0 ***0:00.01*migration/1********
****5*root******34**19*****0****0****0*S****0**0.0 ***0:00.00*ksoftirqd/1********
****6*root******RT***0*****0****0****0*S****0**0.0 ***0:00.01*migration/2********
****7*root******34**19*****0****0****0*S****0**0.0 ***0:00.00*ksoftirqd/2********
****8*root******RT***0*****0****0****0*S****0**0.0 ***0:00.00*migration/3********
****9*root******34**19*****0****0****0*S****0**0.0 ***0:00.00*ksoftirqd/3********
***10*root******10**-5*****0****0****0*S****0**0.0***0:00.01*events/0***********
***11*root******10**-5*****0****0****0*S****0**0.0***0:00.01*events/1***********
***12*root******10**-5*****0****0****0*S****0**0.0***0:00.00*events/2***********
***13*root******10**-5*****0****0****0*S****0**0.0***0:00.00*events/3***********
***14*root******10**-5*****0****0****0*S****0**0.0***0:00.00*khelper*** *********
***15*root******10**-5*****0****0****0*S****0**0.0***0:00.00*kthread*** *********
***21*root******10**-5*****0****0****0*S****0**0.0***0:00.23*kblockd/0**********
***22*root******10**-5*****0****0****0*S****0**0.0***0:00.16*kblockd/1**********
***23*root******10**-5*****0****0****0*S****0**0.0***0:00.21*kblockd/2**********
***24*root******10**-5*****0****0****0*S****0**0.0***0:00.12*kblockd/3**********
***25*root******14**-5*****0****0****0*S****0**0.0***0:00.00*kacpid**** *********
***97*root******10**-5*****0****0****0*S****0**0.0***0:00.00*kseriod*** *********
**148*root******15***0*****0****0****0*S****0**0.0 ***0:00.01*pdflush************
**149*root******15***0*****0****0****0*S****0**0.0 ***0:00.31*pdflush************
**150*root******10**-5*****0****0****0*S****0**0.0***0:01.84*kswapd0*** *********
**151*root******14**-5*****0****0****0*S****0**0.0***0:00.00*aio/0**************
**152*root******14**-5*****0****0****0*S****0**0.0***0:00.00*aio/1**************
**153*root******14**-5*****0****0****0*S****0**0.0***0:00.00*aio/2**************
**154*root******14**-5*****0****0****0*S****0**0.0***0:00.00*aio/3**************
**311*root******15***0*****0****0****0*S****0**0.0 ***0:00.30*kirqd**************
**697*root******10**-5*****0****0****0*S****0**0.0***0:00.00*khubd***** *********
**727*root******10**-5*****0****0****0*S****0**0.0***0:00.00*ata/0**************
**728*root******14**-5*****0****0****0*S****0**0.0***0:00.00*ata/1**************
**729*root******10**-5*****0****0****0*S****0**0.0***0:00.00*ata/2**************
**730*root******12**-5*****0****0****0*S****0**0.0***0:00.00*ata/3**************
**731*root******11**-5*****0****0****0*S****0**0.0***0:00.00*ata_aux*** *********
**738*root******12**-5*****0****0****0*S****0**0.0***0:00.00*scsi_eh_0* *********
**739*root******10**-5*****0****0****0*S****0**0.0***0:00.00*scsi_eh_1* *********
*1003*root******10**-5*****0****0****0*S****0**0.0***0:08.77*kjournald* *********
*1187*root******21**-4**2180**604**340*S****0**0.0***0:00.02*udevd***** *********
*1559*root******16**-5*****0****0****0*S****0**0.0***0:00.00*kpsmoused* *********
*1839*root******13**-5*****0****0****0*S****0**0.0***0:00.00*kmirrord** *********
*3068*root******20***0**1624**568**460*S****0**0.0 ***0:00.50*syslogd************
*3074*root******18***0**1576**380**308*S****0**0.0 ***0:00.06*klogd**************
*3086*bind******25***0*56272*3896*2156*S****0**0.0 ***0:04.03*named**************
*3183*root******25***0**1576**560**472*S****0**0.0 ***0:00.00*acpid**************
*3188*root******18***0**1160**304**264*S****0**0.0 ***0:00.13*da-popb4smtp*******
*3192*nobody****18***0**7524**956**744*S****0**0.0 ***0:00.24*directadmin********
*3196*root******15***0**1940**648**480*S****0**0.0 ***0:00.17*dovecot************
*3197*root******15***0**2484*1252**776*S****0**0.0 ***0:00.13*dovecot-auth*******
*3206*mail******15***0**6968**808**580*S****0**0.0 ***0:00.00*exim***************
*3211*dovecot***15***0**3308*1512*1240*S****0**0.0 ***0:00.00*pop3-login*********
*3212*dovecot***15***0**3312*1504*1236*S****0**0.0 ***0:00.00*pop3-login*********
*3215*dovecot***15***0**3312*1508*1240*S****0**0.0 ***0:00.01*pop3-login*********
*3216*dovecot***15***0**3312*1504*1236*S****0**0.0 ***0:00.00*pop3-login*********
*3217*dovecot***15***0**3308*1508*1240*S****0**0.0 ***0:00.00*pop3-login*********
*3219*dovecot***15***0**3308*1508*1240*S****0**0.0 ***0:00.00*pop3-login*********
*3227*dovecot***18***0**3316*1512*1248*S****0**0.0 ***0:00.00*imap-login*********
*3228*dovecot***18***0**3312*1520*1248*S****0**0.0 ***0:00.00*imap-login*********
*3229*dovecot***18***0**3312*1516*1248*S****0**0.0 ***0:00.00*imap-login*********
*3230*dovecot***18***0**3312*1520*1248*S****0**0.0 ***0:00.00*imap-login*********
*3231*dovecot***18***0**3312*1516*1248*S****0**0.0 ***0:00.00*imap-login*********
*3232*dovecot***18***0**3312*1516*1248*S****0**0.0 ***0:00.00*imap-login*********
*3233*dovecot***18***0**3316*1516*1248*S****0**0.0 ***0:00.00*imap-login*********
*3234*dovecot***18***0**3316*1516*1248*S****0**0.0 ***0:00.00*imap-login*********
*3235*dovecot***18***0**3312*1516*1248*S****0**0.0 ***0:00.00*imap-login*********
*3236*dovecot***18***0**3316*1520*1248*S****0**0.0 ***0:00.00*imap-login*********
*3237*dovecot***18***0**3316*1520*1248*S****0**0.0 ***0:00.00*imap-login*********
*3238*dovecot***18***0**3316*1516*1248*S****0**0.0 ***0:00.00*imap-login*********
*3239*dovecot***18***0**3316*1520*1248*S****0**0.0 ***0:00.00*imap-login*********
*3240*dovecot***18***0**3316*1516*1248*S****0**0.0 ***0:00.00*imap-login*********
*3241*dovecot***18***0**3316*1512*1248*S****0**0.0 ***0:00.00*imap-login*********
*3242*dovecot***18***0**3312*1516*1248*S****0**0.0 ***0:00.00*imap-login*********
*3306*root******20***0**2656**448**224*S****0**0.0 ***0:00.00*nginx**************
*3307*nobody****15***0**2900*1280**740*S****0**0.0 ***1:57.20*nginx**************
*3308*nobody****15***0**3688*2068**740*S****0**0.0 ***1:59.84*nginx**************
*3310*nobody****15***0**3148*1528**740*S****0**0.0 ***1:59.48*nginx**************
*3312*nobody****15***0**4304*2684**740*S****0**0.0 ***1:56.33*nginx**************
*3313*nobody****15***0**3348*1728**740*S****0**0.0 ***2:01.71*nginx**************
*3347*ftp*******18***0**4220*1236**648*S****0**0.0 ***0:00.08*proftpd************
*3369*root******15***0**4928*1084**756*S****0**0.0 ***0:00.02*sshd***************
*3614*root******20***0**2192**864**680*S****0**0.0 ***0:00.04*cron***************
*3651*root******15***0*50788*1664*1284*S****0**0.0 ***0:02.38*searchd************
*3664*root******18***0**1572**492**424*S****0**0.0 ***0:00.00*getty**************
*3666*root******18***0**1572**492**424*S****0**0.0 ***0:00.00*getty**************
*3667*root******18***0**1572**492**424*S****0**0.0 ***0:00.00*getty**************
*3668*root******18***0**1572**488**424*S****0**0.0 ***0:00.00*getty**************
*3670*root******18***0**1576**496**424*S****0**0.0 ***0:00.00*getty**************
*3671*root******18***0**1572**492**424*S****0**0.0 ***0:00.00*getty**************
23636*dovecot***15***0**3308*1504*1240*S****0**0.0 ***0:00.00*pop3-login*********
29751*dovecot***15***0**3312*1508*1236*S****0**0.0 ***0:00.00*pop3-login*********
32129*dovecot***15***0**3312*1512*1240*S****0**0.0 ***0:00.00*pop3-login*********
32166*dovecot***15***0**3308*1504*1236*S****0**0.0 ***0:00.00*pop3-login*********
25630*dovecot***15***0**3312*1508*1240*S****0**0.0 ***0:00.00*pop3-login*********
15098*nobody****20***0**7524**280***68*S****0**0.0 ***0:00.00*directadmin********
15141*nobody****18***0**7524**280***68*S****0**0.0 ***0:00.00*directadmin********
15162*nobody****18***0**7524**280***68*S****0**0.0 ***0:00.00*directadmin********
15232*nobody****18***0**7524**280***68*S****0**0.0 ***0:00.00*directadmin********
15316*nobody****18***0**7524**280***68*S****0**0.0 ***0:00.00*directadmin********
15441*dovecot***15***0**3308*1504*1236*S****0**0.0 ***0:00.00*pop3-login*********
15531*dovecot***15***0**3308*1504*1236*S****0**0.0 ***0:00.00*pop3-login*********
*6592*dovecot***16***0**3308*1508*1240*S****0**0.0 ***0:00.00*pop3-login*********
*6594*dovecot***17***0**3308*1508*1240*S****0**0.0 ***0:00.00*pop3-login*********
*6630*dovecot***17***0**3312*1508*1236*S****0**0.0 ***0:00.00*pop3-login*********
28221*root******18***0**558m**11m*4444*S****0**0.1 ***0:00.35*httpd**************
13797*apache****15***0**559m**26m**17m*S****0**0.3 ***4:22.14*httpd**************
*8089*apache****17***0**561m**26m**15m*S****0**0.3 ***0:25.91*httpd**************
**940*apache****15***0**559m**22m**13m*S****0**0.3 ***0:09.11*httpd**************
**967*apache****15***0**559m**20m**11m*S****0**0.3 ***0:03.92*httpd**************
*1052*apache****15***0**2228*1052**756*R****0**0.0 ***0:00.00*top****************

[Antonio]

Usi apache davanti ad nginx o il contrario?

[Final_Alpha]

Uso nginx come reverse proxy, nginx per files statici ed apache files dinamici.

[Antonio]

Uso nginx come reverse proxy, nginx per files statici ed apache files dinamici.

Se usi solo IPB non capisco perché usare anche apache, vai di nginx + php in fastcgi

[Final_Alpha]

Dovrei cmq capire e risolvere questo problema del carico troppo elevato, altrimenti se poi si presenta anche su nginx?!

[Antonio]

Dovrei cmq capire e risolvere questo problema del carico troppo elevato, altrimenti se poi si presenta anche su nginx?!

Leggi i log di apache e vedi cosa succede quando sei nella situazione descritta.

[Final_Alpha]

Leggi i log di apache e vedi cosa succede quando sei nella situazione descritta.

sono sempre nella situazione descritta, intendi error_log ?

[Antonio]

sono sempre nella situazione descritta, intendi error_log ?

Anche access log; per capire quali pagine sono interessate.

[FlameNetworks]

Come posso sapere da dove proviene questo carico, ricordo che il sito è lentissimo,
e risolverlo?

Un attimo che consulto la sfera di cristallo...
Niente da fare, l'oracolo ha detto che non ci sono elementi sufficienti per poter analizzare il problema.

Scherzi a parte, installa munin e vedi se con i grafici c'è qualcosa di utile.
Poi fornisci anche i dati sul traffico/acessi, la configurazione del Webserver e gli error_log.

Ciao,

F.

[Final_Alpha]

file di configurazione httpd, etc/httpd/conf/httpd.conf:

Spoiler

#
# This is the main Apache HTTP server configuration file. It contains the
# configuration directives that give the server its instructions.
# See <URL:http://httpd.apache.org/docs/2.2> for detailed information.
# In particular, see
# <URL:http://httpd.apache.org/docs/2.2/mod/directives.html>
# for a discussion of each configuration directive.
#
# Do NOT simply read the instructions in here without understanding
# what they do. They're here only as hints or reminders. If you are unsure
# consult the online docs. You have been warned.

ServerRoot "/etc/httpd"
Listen 8080
MaxClients 50
TimeOut 20
MinSpareServers 10
MaxSpareServers 10
MaxRequestsPerChild 500
ListenBacklog 50
#LoadModule dummy_module /usr/lib/apache/mod_dummy.so
#LoadModule php5_module /usr/lib/apache/libphp5.so
Include /etc/httpd/conf/extra/httpd-phpmodules.conf

AcceptMutex fcntl
User apache
Group apache

ServerAdmin admin@localhost
DocumentRoot "/var/www/html"

<Directory /home/*>
AllowOverride All
Options -MultiViews -Indexes FollowSymlinks IncludesNoExec +Includes
<Limit GET POST OPTIONS PROPFIND>
Order allow,deny
Allow from all
</Limit>
<LimitExcept GET POST OPTIONS PROPFIND>
Order deny,allow
Deny from all
</LimitExcept>
</Directory>

<Directory />
Options All
AllowOverride All
</Directory>

<Directory "/var/www/html">
Options Indexes FollowSymLinks
AllowOverride All
Order allow,deny
Allow from all
<IfModule mod_suphp.c>
suPHP_Engine On
suPHP_UserGroup webapps webapps
</IfModule>
</Directory>

<IfModule dir_module>
DirectoryIndex index.html index.htm index.shtml index.php index.php5 index.php4 index.php3 index.phtml index.cgi
</IfModule>

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

ErrorLog /var/log/httpd/error_log
LogLevel warn

<IfModule log_config_module>
#replace %b with %O for more accurate logging
<IfModule mod_logio.c>
LogFormat "%h %l %u %t \"%r\" %>s %O \"%{Referer}i\" \"%{User-Agent}i\"" combined
LogFormat "%h %l %u %t \"%r\" %>s %O" common
LogFormat "%O" bytes

LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\" %I %O" combinedio
</IfModule>

# CustomLog /var/log/httpd/access_log common
</IfModule>

<IfModule alias_module>
# Include some DirectAdmin alias
Include conf/extra/httpd-alias.conf
</IfModule>

<Directory "/var/www/cgi-bin">
AllowOverride None
Options None
Order allow,deny
Allow from all
</Directory>

DefaultType text/plain

<IfModule mime_module>
TypesConfig conf/mime.types
AddType application/x-gzip .tgz
AddEncoding x-compress .Z
AddEncoding x-gzip .gz .tgz
AddType application/x-compress .Z
AddType application/x-gzip .gz .tgz
AddHandler cgi-script .cgi
AddHandler type-map var
AddType text/html .shtml
AddOutputFilter INCLUDES .shtml
AddType video/x-ms-asf .avi
AddType video/mpeg .mpg
AddType video/mpeg .mpeg
AddType video/quicktime .mov
AddType video/x-ms-wmv .wmv
</IfModule>

#EnableMMAP off
#EnableSendfile off

################################################## #####################################
# Do not change anything in included files, because they are rewritten by DirectAdmin #
################################################## #####################################

# This is needed for PHP
Include conf/extra/httpd-php-handlers.conf

# Server-pool management (MPM specific)
Include conf/extra/httpd-mpm.conf

# Multi-language error messages
Include conf/extra/httpd-multilang-errordoc.conf

# Fancy directory listings
Include conf/extra/httpd-autoindex.conf

# Language settings
Include conf/extra/httpd-languages.conf

# User home directories
#Include conf/extra/httpd-userdir.conf

# Real-time info on requests and configuration
Include conf/extra/httpd-info.conf

# Virtual hosts
Include conf/extra/httpd-vhosts.conf

# Local access to the Apache HTTP Server Manual
#Include conf/extra/httpd-manual.conf

# Distributed authoring and versioning (WebDAV)
Include conf/extra/httpd-dav.conf

# Various default settings
Include conf/extra/httpd-default.conf

# Secure (SSL/TLS) connections
Include conf/extra/httpd-ssl.conf

# Deflate module settings
Include conf/extra/httpd-deflate.conf

# All the DirectAdmin vhosts
Include conf/extra/directadmin-vhosts.conf

# All suPHP directives
Include conf/extra/httpd-suphp.conf

# All the other includes needed by the custombuild script
Include conf/extra/httpd-includes.conf

################################################## #####################################
# End of included files that are rewritten by DirectAdmin #
################################################## #####################################

<IfModule ssl_module>
SSLRandomSeed startup builtin
SSLRandomSeed connect builtin
</IfModule>

Script per l'ottimizzazione di Mysql (di hostingtalk):

usato di mattina, quando il carico è basso, altrimenti non parte quando il traffico è alto.

http://oi51.tinypic.com/2r4objk.jpg

Un attimo che consulto la sfera di cristallo...
Niente da fare, l'oracolo ha detto che non ci sono elementi sufficienti per poter analizzare il problema.

Scherzi a parte, installa munin e vedi se con i grafici c'è qualcosa di utile.
Poi fornisci anche i dati sul traffico/acessi, la configurazione del Webserver e gli error_log.

Ciao,

F.

installo munin e vi faccio sapere,

i dati sul traffico/acessi, da dove?

stasera metto error_log e access_log che ora non posso.

[FlameNetworks]

i dati sul traffico/acessi, da dove?

AWStats per le statistiche sugli accessi.
Per il traffico mensile, se hai un pannello di controllo dovresti avere quel dato già disponibile.

Ma il KeepAlive su apache è Off oppure On???