Aiuto per configurazione

[blurenegade]

Salve amici,
ho da poco preso un server virtuale unmanaged ed avrei bisogno di aiuto per la configurazione.

Il server dispone di 1GB di ram

l'output di cat /proc/cpuinfo è il seguente:

Spoiler

vps:/# cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 6
model : 26
model name : Intel(R) Xeon(R) CPU E5506 @ 2.13GHz
stepping : 5
cpu MHz : 2133.425
cache size : 4096 KB
physical id : 0
siblings : 1
core id : 0
cpu cores : 1
apicid : 0
initial apicid : 0
fpu : yes
fpu_exception : yes
cpuid level : 4
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat clflush mmx fxsr sse sse2 ht syscall nx lm constant_tsc up rep_good pni ssse3 cx16 sse4_1 sse4_2 popcnt lahf_lm
bogomips : 4272.36
clflush size : 64
cache_alignment : 64
address sizes : 40 bits physical, 48 bits virtual

l'ouptup di free -m è il seguente

Spoiler

total used free shared buffers cached
Mem: 1005 871 133 0 76 211
-/+ buffers/cache: 584 421
Swap: 1717 0 1717

questo è il mio apache2.conf

Spoiler

ServerRoot "/etc/apache2"
LockFile /var/lock/apache2/accept.lock
PidFile ${APACHE_PID_FILE}
Timeout 120
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 15
<IfModule mpm_prefork_module>
StartServers 8
MinSpareServers 5
MaxSpareServers 20
ServerLimit 150
MaxClients 150
MaxRequestsPerChild 2000
</IfModule>

<IfModule mpm_worker_module>
StartServers 2
ServerLimit 150
MaxClients 150
MinSpareThreads 25
MaxSpareThreads 75
ThreadsPerChild 25
MaxRequestsPerChild 0
</IfModule>

User www-data
Group www-data
AccessFileName .htaccess
<Files ~ "^\.ht">
Order allow,deny
Deny from all
</Files>

DefaultType text/plain

HostnameLookups Off

ErrorLog /var/log/apache2/error.log

LogLevel warn

Include /etc/apache2/mods-enabled/*.load
Include /etc/apache2/mods-enabled/*.conf
Include /etc/apache2/httpd.conf
Include /etc/apache2/ports.conf

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

CustomLog /var/log/apache2/other_vhosts_access.log vhost_combined

Include /etc/apache2/conf.d/

Include /etc/apache2/sites-enabled/
AddOutputFilter INCLUDES .shtml
AddType text/html .shtml
AddType application/x-httpd-php .php
AddType application/x-httpd-php-source .phps

l'output di apache2 -V

Spoiler

Server version: Apache/2.2.9 (Debian)
Server built: Dec 11 2010 21:34:00
Server's Module Magic Number: 20051115:15
Server loaded: APR 1.2.12, APR-Util 1.2.12
Compiled using: APR 1.2.12, APR-Util 1.2.12
Architecture: 64-bit
Server MPM: Prefork
threaded: no
forked: yes (variable process count)
Server compiled with....
-D APACHE_MPM_DIR="server/mpm/prefork"
-D APR_HAS_SENDFILE
-D APR_HAS_MMAP
-D APR_HAVE_IPV6 (IPv4-mapped addresses enabled)
-D APR_USE_SYSVSEM_SERIALIZE
-D APR_USE_PTHREAD_SERIALIZE
-D SINGLE_LISTEN_UNSERIALIZED_ACCEPT
-D APR_HAS_OTHER_CHILD
-D AP_HAVE_RELIABLE_PIPED_LOGS
-D DYNAMIC_MODULE_LIMIT=128
-D HTTPD_ROOT=""
-D SUEXEC_BIN="/usr/lib/apache2/suexec"
-D DEFAULT_PIDLOG="/var/run/apache2.pid"
-D DEFAULT_SCOREBOARD="logs/apache_runtime_status"
-D DEFAULT_LOCKFILE="/var/run/apache2/accept.lock"
-D DEFAULT_ERRORLOG="logs/error_log"
-D AP_TYPES_CONFIG_FILE="/etc/apache2/mime.types"
-D SERVER_CONFIG_FILE="/etc/apache2/apache2.conf"

questo il mio my.cnf

Spoiler

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

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

[mysqld]
set-variable=local-infile=0
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
language = /usr/share/mysql/english
skip-external-locking

key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 128K
thread_cache_size = 8
myisam-recover = BACKUP

query_cache_limit = 1M
query_cache_size = 16M

log_slow_queries = /var/log/mysql/mysql-slow.log

expire_logs_days = 10
max_binlog_size = 100M

skip-bdb

[mysqldump]
quick
quote-names
max_allowed_packet = 16M

[mysql]

[isamchk]
key_buffer = 16M

!includedir /etc/mysql/conf.d/

Sul server ho alcuni siti relizzati in php/mysql
un sito in wordpress
e una newsletter in phplist

ho impostato un cron che superata una certa soglia di load mi invia una mail con l'output di top

Spoiler

-------------------------------------------
System snapshot from top:
-------------------------------------------
top - 1532 up 21:50, 1 user, load average: 59.35, 24.13, 9.12
Tasks: 165 total, 1 running, 164 sleeping, 0 stopped, 0 zombie
Cpu(s): 3.9%us, 0.5%sy, 0.0%ni, 94.4%id, 0.8%wa, 0.3%hi, 0.1%si, 0.0%st
Mem: 1029492k total, 1019300k used, 10192k free, 2276k buffers
Swap: 1759076k total, 1554652k used, 204424k free, 31132k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND

163 root 15 -5 0 0 0 S 4.0 0.0 0:04.10 kswapd0
12351 www-data 20 0 271m 11m 4252 D 4.0 1.2 0:01.54 apache2
1 root 20 0 10316 484 464 S 0.0 0.0 0:01.30 init
2 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 kthreadd
3 root RT -5 0 0 0 S 0.0 0.0 0:00.00 migration/0
4 root 15 -5 0 0 0 S 0.0 0.0 0:00.48 ksoftirqd/0
5 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/0

6 root 15 -5 0 0 0 S 0.0 0.0 0:03.26 events/0
7 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 khelper

41 root 15 -5 0 0 0 S 0.0 0.0 0:06.38 kblockd/0
43 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 kacpid
44 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 kacpi_notify
111 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 ksuspend_usbd
117 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 khubd
120 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 kseriod
161 root 20 0 0 0 0 D 0.0 0.0 0:02.40 pdflush

162 root 20 0 0 0 0 D 0.0 0.0 0:09.38 pdflush
164 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 aio/0
673 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 ata/0
674 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 ata_aux

773 root 15 -5 0 0 0 D 0.0 0.0 0:25.98 kjournald
849 root 16 -4 16920 416 412 S 0.0 0.0 0:00.08 udevd
1195 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 kpsmoused

1689 daemon 20 0 8024 360 356 S 0.0 0.0 0:00.00 portmap
1700 statd 20 0 10140 472 468 S 0.0 0.0 0:00.00 rpc.statd
1884 root 20 0 118m 948 756 S 0.0 0.1 0:04.85 rsyslogd
1895 root 20 0 3800 376 372 S 0.0 0.0 0:00.00 acpid
1912 bind 20 0 112m 632 628 S 0.0 0.1 0:00.02 named
1926 root 20 0 48868 688 564 S 0.0 0.1 0:00.04 sshd
2858 root 20 0 19268 508 504 S 0.0 0.0 0:00.00 xinetd
3013 sw-cp-se 20 0 48948 940 748 S 0.0 0.1 0:01.72 sw-cp-serverd
3067 daemon 20 0 16360 272 272 S 0.0 0.0 0:00.00 atd

3087 root 20 0 19836 648 548 S 0.0 0.1 0:00.12 cron
3117 root 20 0 3800 420 400 S 0.0 0.0 0:00.00 getty
3118 root 20 0 3800 396 392 S 0.0 0.0 0:00.00 getty
3119 root 20 0 3800 396 392 S 0.0 0.0 0:00.00 getty
3120 root 20 0 3800 396 392 S 0.0 0.0 0:00.00 getty
3121 root 20 0 3800 396 392 S 0.0 0.0 0:00.00 getty
3122 root 20 0 3800 396 392 S 0.0 0.0 0:00.00 getty
10353 root 20 0 77084 1084 984 S 0.0 0.1 0:00.92 sshd
10355 root 20 0 18852 1168 948 S 0.0 0.1 0:00.04 bash
10853 root 20 0 36848 964 824 S 0.0 0.1 0:02.94 master
10855 postfix 20 0 39692 1328 1028 S 0.0 0.1 0:05.26 qmgr
10858 postfix 20 0 41872 1188 940 S 0.0 0.1 0:02.26 tlsmgr
10954 root 20 0 21728 464 460 S 0.0 0.0 0:00.00 couriertcpd
10956 root 20 0 13932 380 376 S 0.0 0.0 0:00.00 courierlogger
10965 root 20 0 21728 464 460 S 0.0 0.0 0:00.00 couriertcpd
10967 root 20 0 13932 380 376 S 0.0 0.0 0:00.00 courierlogger
10974 root 20 0 21728 464 460 S 0.0 0.0 0:00.00 couriertcpd
10976 root 20 0 13932 380 376 S 0.0 0.0 0:00.00 courierlogger
10984 root 20 0 21728 464 460 S 0.0 0.0 0:00.00 couriertcpd
10986 root 20 0 13932 380 376 S 0.0 0.0 0:00.00 courierlogger
11732 postfix 20 0 38904 1072 924 S 0.0 0.1 0:00.02 pickup
12192 root 20 0 227m 4608 2944 S 0.0 0.4 0:00.28 apache2
12193 www-data 20 0 162m 1152 456 S 0.0 0.1 0:00.00 apache2
12195 www-data 20 0 275m 21m 4156 D 0.0 2.1 0:03.10 apache2
12196 www-data 20 0 264m 5828 4212 S 0.0 0.6 0:08.14 apache2
12197 www-data 20 0 271m 9736 4116 D 0.0 0.9 0:02.22 apache2
12198 www-data 20 0 271m 11m 4124 S 0.0 1.1 0:01.22 apache2
12199 www-data 20 0 271m 11m 4240 S 0.0 1.1 0:01.44 apache2
12200 www-data 20 0 271m 9732 4112 D 0.0 0.9 0:02.42 apache2
12201 www-data 20 0 271m 20m 4112 S 0.0 2.1 0:04.06 apache2
12202 www-data 20 0 271m 5208 4112 S 0.0 0.5 0:02.96 apache2
12340 postfix 20 0 39192 1236 1056 S 0.0 0.1 0:00.04 cleanup
12347 www-data 20 0 270m 7832 4216 D 0.0 0.8 0:01.26 apache2
12348 www-data 20 0 271m 7240 4112 S 0.0 0.7 0:01.40 apache2
12350 www-data 20 0 271m 8756 4216 S 0.0 0.9 0:01.30 apache2
12401 www-data 20 0 270m 9.8m 4116 D 0.0 1.0 0:00.80 apache2
12483 root 20 0 165m 1320 1268 S 0.0 0.1 0:00.02 sw-engine-cgi
12493 psaadm 20 0 179m 1568 1540 S 0.0 0.2 0:00.80 sw-engine-cgi
12494 psaadm 20 0 175m 4912 3528 S 0.0 0.5 0:00.40 sw-engine-cgi
12495 psaadm 20 0 176m 5136 2968 S 0.0 0.5 0:00.56 sw-engine-cgi
12519 www-data 20 0 270m 16m 4072 D 0.0 1.6 0:00.96 apache2
12521 www-data 20 0 270m 12m 4064 D 0.0 1.2 0:00.78 apache2
12523 www-data 20 0 270m 12m 4064 D 0.0 1.3 0:00.84 apache2
12525 www-data 20 0 251m 10m 3920 S 0.0 1.0 0:00.40 apache2
12527 www-data 20 0 251m 9996 3920 S 0.0 1.0 0:00.44 apache2
12528 www-data 20 0 270m 26m 4064 D 0.0 2.6 0:00.84 apache2
12530 www-data 20 0 254m 13m 3940 D 0.0 1.4 0:00.48 apache2
12536 www-data 20 0 254m 16m 3940 D 0.0 1.6 0:00.48 apache2
12537 www-data 20 0 251m 12m 3920 D 0.0 1.2 0:00.46 apache2
12539 www-data 20 0 251m 11m 3920 D 0.0 1.1 0:00.42 apache2
12540 www-data 20 0 250m 9.8m 3844 D 0.0 1.0 0:00.38 apache2
12543 www-data 20 0 250m 10m 3868 D 0.0 1.1 0:00.44 apache2
12545 www-data 20 0 253m 13m 3920 D 0.0 1.4 0:00.44 apache2
12547 www-data 20 0 251m 12m 3920 S 0.0 1.3 0:00.44 apache2
12549 www-data 20 0 253m 14m 3920 D 0.0 1.4 0:00.44 apache2
12557 www-data 20 0 255m 25m 3960 D 0.0 2.5 0:00.48 apache2
12558 www-data 20 0 247m 23m 3844 D 0.0 2.3 0:00.44 apache2
12559 www-data 20 0 253m 28m 3924 D 0.0 2.8 0:00.40 apache2
12560 www-data 20 0 251m 20m 3920 S 0.0 2.0 0:00.38 apache2
12561 www-data 20 0 253m 21m 3920 D 0.0 2.2 0:00.38 apache2
12565 www-data 20 0 251m 10m 3920 S 0.0 1.1 0:00.36 apache2
12566 www-data 20 0 252m 20m 3920 D 0.0 2.0 0:00.38 apache2
12567 www-data 20 0 253m 21m 3920 D 0.0 2.2 0:00.40 apache2
12568 www-data 20 0 270m 28m 4072 S 0.0 2.8 0:00.78 apache2
12569 www-data 20 0 251m 21m 3920 S 0.0 2.1 0:00.34 apache2
12570 www-data 20 0 270m 22m 4064 D 0.0 2.3 0:00.70 apache2
12571 www-data 20 0 254m 11m 3952 D 0.0 1.1 0:00.50 apache2
12572 www-data 20 0 256m 17m 3964 D 0.0 1.7 0:00.54 apache2
12573 www-data 20 0 251m 12m 3920 D 0.0 1.2 0:00.34 apache2
12574 www-data 20 0 256m 15m 3964 D 0.0 1.6 0:00.50 apache2
12575 www-data 20 0 270m 28m 4072 S 0.0 2.8 0:00.84 apache2
12576 www-data 20 0 270m 28m 4072 S 0.0 2.8 0:00.84 apache2
12577 www-data 20 0 253m 9.8m 3924 D 0.0 1.0 0:00.42 apache2
12578 www-data 20 0 270m 25m 4064 S 0.0 2.6 0:00.78 apache2
12579 www-data 20 0 270m 27m 4088 S 0.0 2.7 0:00.70 apache2
12580 www-data 20 0 251m 17m 3920 D 0.0 1.8 0:00.36 apache2
12581 www-data 20 0 253m 14m 3924 D 0.0 1.4 0:00.42 apache2
12583 www-data 20 0 270m 28m 4072 D 0.0 2.9 0:00.74 apache2
12584 www-data 20 0 258m 34m 3964 D 0.0 3.4 0:00.48 apache2
12585 www-data 20 0 254m 19m 3956 D 0.0 1.9 0:00.44 apache2
12586 www-data 20 0 253m 15m 3924 D 0.0 1.5 0:00.46 apache2
12587 www-data 20 0 251m 17m 3940 S 0.0 1.8 0:00.34 apache2
12589 www-data 20 0 232m 6800 3732 S 0.0 0.7 0:00.12 apache2
12590 www-data 20 0 254m 26m 3952 D 0.0 2.7 0:00.38 apache2
12591 www-data 20 0 253m 13m 3928 D 0.0 1.3 0:00.40 apache2
12592 www-data 20 0 253m 10m 3924 D 0.0 1.0 0:00.38 apache2
12593 www-data 20 0 258m 36m 3984 D 0.0 3.6 0:00.40 apache2
12594 www-data 20 0 257m 27m 3984 D 0.0 2.7 0:00.42 apache2
12595 www-data 20 0 227m 4740 3028 S 0.0 0.5 0:00.02 apache2
12596 www-data 20 0 227m 6548 3500 S 0.0 0.6 0:00.06 apache2
12597 www-data 20 0 232m 7060 3764 S 0.0 0.7 0:00.08 apache2
12598 www-data 20 0 230m 8328 3320 S 0.0 0.8 0:00.04 apache2
12599 www-data 20 0 232m 6704 3748 S 0.0 0.7 0:00.10 apache2
12600 www-data 20 0 227m 3144 1444 S 0.0 0.3 0:00.00 apache2
12601 www-data 20 0 229m 7516 3500 S 0.0 0.7 0:00.04 apache2
12603 www-data 20 0 227m 3072 1440 S 0.0 0.3 0:00.00 apache2
12604 www-data 20 0 230m 7092 3692 S 0.0 0.7 0:00.10 apache2
12605 www-data 20 0 227m 5284 3000 S 0.0 0.5 0:00.00 apache2
12608 www-data 20 0 231m 9m 3676 S 0.0 1.0 0:00.12 apache2
12609 www-data 20 0 231m 9.9m 3672 S 0.0 1.0 0:00.08 apache2
12610 www-data 20 0 238m 17m 3736 D 0.0 1.8 0:00.16 apache2
12611 www-data 20 0 229m 7784 3148 S 0.0 0.8 0:00.02 apache2
12613 www-data 20 0 231m 9.9m 3668 S 0.0 1.0 0:00.06 apache2
12654 psaadm 20 0 165m 504 472 S 0.0 0.0 0:00.00 sw-engine-cgi
12659 psaadm 20 0 165m 504 472 S 0.0 0.0 0:00.00 sw-engine-cgi
12686 root 20 0 10304 1440 1092 S 0.0 0.1 0:00.02 apache2
12690 postfix 20 0 43308 2868 2260 S 0.0 0.3 0:00.04 smtp
12692 postfix 20 0 39832 3484 2112 S 0.0 0.3 0:00.02 trivial-rewrite
12703 root 20 0 10304 748 372 S 0.0 0.1 0:00.00 apache2
12704 root 20 0 17284 1380 1124 S 0.0 0.1 0:00.00 apache2ctl
12706 root 20 0 153m 6944 4656 D 0.0 0.7 0:00.16 apache2
12707 www-data 20 0 227m 2848 904 S 0.0 0.3 0:00.00 apache2
12708 www-data 20 0 227m 2848 904 S 0.0 0.3 0:00.00 apache2
12709 root 20 0 47244 2124 1612 S 0.0 0.2 0:00.00 cron
12710 root 20 0 8852 1192 988 S 0.0 0.1 0:00.00 load_average_mo
12732 root 20 0 48868 232 136 D 0.0 0.0 0:00.00 sshd
12733 postfix 20 0 43308 2968 2344 S 0.0 0.3 0:00.00 smtp
12734 postfix 20 0 38900 2192 1732 S 0.0 0.2 0:00.00 spawn
12735 mhandler 20 0 11616 1104 852 S 0.0 0.1 0:00.00 postfix-queue
12736 root 20 0 44188 3600 2212 D 0.0 0.3 0:00.02 smtpd
12737 postfix 20 0 43308 2968 2344 S 0.0 0.3 0:00.00 smtp
12738 postfix 20 0 43308 2964 2344 S 0.0 0.3 0:00.00 smtp
12739 postfix 20 0 43308 2968 2344 S 0.0 0.3 0:00.02 smtp
12740 postfix 20 0 43308 2968 2344 S 0.0 0.3 0:00.00 smtp
12741 postfix 20 0 38936 2252 1776 D 0.0 0.2 0:00.00 bounce
12742 postfix 20 0 38936 2252 1776 D 0.0 0.2 0:00.00 bounce
12743 postfix 20 0 38936 2252 1776 D 0.0 0.2 0:00.00 bounce
12744 postfix 20 0 38936 2252 1776 D 0.0 0.2 0:00.00 bounce
12745 postfix 20 0 38904 2228 1756 S 0.0 0.2 0:00.00 proxymap
12746 root 20 0 18956 1204 844 R 0.0 0.1 0:00.00 top
20529 root 20 0 10180 444 440 S 0.0 0.0 0:00.00 mysqld_safe
20566 mysql 20 0 498m 19m 3120 D 0.0 1.9 5:56.90 mysqld
20567 root 20 0 5040 428 424 S 0.0 0.0 0:00.00 logger

quando capita questo (molto spesso) ricevo in console un OOM con conseguente kill di mysql, apache ecc. e devo riavviare il server.

Non sono un sistemista e sicuramente ce ne vorrebbe uno... ma devo arrangiarmi da solo

qualcuno mi può aiutare?

[EvolutionCrazy]

hai problemi di memoria lì...

serve l'output di mod_status (extended) per valutare dove sta il problema...

nel cron quindi fatti mandare sia quello che un po' di info da netstat

nel frattempo prova ad abbassare:
"Timeout 120"

e in php.ini

imposta un max_execution_time basso (tipo 30sec) idem per i limiti dei vari parse di input

[blurenegade]

hai problemi di memoria lì...

serve l'output di mod_status (extended) per valutare dove sta il problema...

nel cron quindi fatti mandare sia quello che un po' di info da netstat

nel frattempo prova ad abbassare:
"Timeout 120"

e in php.ini

imposta un max_execution_time basso (tipo 30sec) idem per i limiti dei vari parse di input

Ciao e grazie della risposta. :-)

a quanto devo portare il Timeout?

max_execution_time è gia impostato a 30

quali altri limiti devo abbassare?

[EvolutionCrazy]

max_input_time per esempio...

comunque bisogna vedere mod_status quandoe sce il problema...

timeout abbassalo più che puoi... prova a 30secondi

[blurenegade]

max_input_time per esempio...

comunque bisogna vedere mod_status quandoe sce il problema...

timeout abbassalo più che puoi... prova a 30secondi

ho seguito i tuoi consigli... non mi resta che aspettare il prossimo OOM...

nel frattempo ti volevo solo chiedere se le configurazioni di apache e mysql possono andare bene così come sono.

[EvolutionCrazy]

Un minimo l'hai fatto. Per una vps anche troppi client.. comunque attendiamo un mod status