Friesi
28.04.03, 13:25
Hallo, also ich hab seit paar Wochen ein Problem.
Mein Server hängt sich einfach auf ..meist hat er kurz vorher einen load von 70 oder mehr.
System: Redhat 7.3
Kernel: 2.4.18
CPU: AMD Duron 1.2 Ghz
RAM: 1 GB Infinion 133Mhz
Mysql: 4.0.12
Apache: 2.0.45
hier ein auschnitt aus der Kernellog:
Apr 25 21:00:39 netzgames kernel: Out of Memory: Killed process 1157 (mysqld).
Apr 25 21:00:41 netzgames kernel: Out of Memory: Killed process 1262 (mysqld).
Apr 25 21:00:41 netzgames kernel: Out of Memory: Killed process 1263 (mysqld).
Apr 25 21:00:41 netzgames kernel: Out of Memory: Killed process 1489 (mysqld).
Apr 25 21:00:41 netzgames kernel: Out of Memory: Killed process 3655 (mysqld).
Apr 25 21:00:41 netzgames kernel: Out of Memory: Killed process 4069 (mysqld).
Apr 25 21:00:41 netzgames kernel: Out of Memory: Killed process 4367 (mysqld).
Apr 25 21:00:41 netzgames kernel: Out of Memory: Killed process 4673 (mysqld).
Apr 25 21:00:41 netzgames kernel: Out of Memory: Killed process 4699 (mysqld).
Apr 25 21:00:41 netzgames kernel: Out of Memory: Killed process 4702 (mysqld).
Apr 25 21:00:41 netzgames kernel: Out of Memory: Killed process 4803 (mysqld).
Apr 25 21:00:41 netzgames kernel: Out of Memory: Killed process 5071 (mysqld).
Apr 25 21:00:41 netzgames kernel: Out of Memory: Killed process 5073 (mysqld).
Apr 25 21:00:43 netzgames kernel: Out of Memory: Killed process 5075 (mysqld).
Apr 25 21:00:43 netzgames kernel: Out of Memory: Killed process 5104 (mysqld).
Apr 25 21:00:43 netzgames kernel: Out of Memory: Killed process 5494 (mysqld).
Apr 25 21:00:43 netzgames kernel: Out of Memory: Killed process 5508 (mysqld).
Apr 25 21:00:43 netzgames kernel: Out of Memory: Killed process 5514 (mysqld).
Apr 25 21:00:43 netzgames kernel: Out of Memory: Killed process 5519 (mysqld).
Apr 25 21:00:43 netzgames kernel: Out of Memory: Killed process 5548 (mysqld).
Apr 25 21:00:43 netzgames kernel: Out of Memory: Killed process 5621 (mysqld).
Apr 25 21:00:43 netzgames kernel: Out of Memory: Killed process 5624 (mysqld).
Apr 25 21:00:43 netzgames kernel: Out of Memory: Killed process 5646 (mysqld).
Apr 25 21:00:43 netzgames kernel: Out of Memory: Killed process 5695 (mysqld).
Apr 25 21:00:43 netzgames kernel: Out of Memory: Killed process 5895 (mysqld).
Apr 25 21:00:43 netzgames kernel: Out of Memory: Killed process 5978 (mysqld).
Apr 25 21:00:43 netzgames kernel: Out of Memory: Killed process 5979 (mysqld).
Apr 25 21:00:44 netzgames kernel: Out of Memory: Killed process 6003 (mysqld).
(...)
meine my.cfg
[mysqld]
max_connections = 800
key_buffer = 16M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 128
wait_timeout = 14400
connect_timeout = 10
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
skip-innodb
[safe_mysqld]
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
weis nun nicht, ob ihr sonst noch daten braucht.
Doch was könnte ich verändern, dass er sich nicht mehr aufhängt? :-/
Wäre um hilfe echt dankbar.
Ach was mir noch auffält, sobald ich den Apache starte, ist mein RAM bis auf 13 MB immer voll belegt.
Das hatte ich aber auch schon bei 1.3.x Versionen :-/
Mein Server hängt sich einfach auf ..meist hat er kurz vorher einen load von 70 oder mehr.
System: Redhat 7.3
Kernel: 2.4.18
CPU: AMD Duron 1.2 Ghz
RAM: 1 GB Infinion 133Mhz
Mysql: 4.0.12
Apache: 2.0.45
hier ein auschnitt aus der Kernellog:
Apr 25 21:00:39 netzgames kernel: Out of Memory: Killed process 1157 (mysqld).
Apr 25 21:00:41 netzgames kernel: Out of Memory: Killed process 1262 (mysqld).
Apr 25 21:00:41 netzgames kernel: Out of Memory: Killed process 1263 (mysqld).
Apr 25 21:00:41 netzgames kernel: Out of Memory: Killed process 1489 (mysqld).
Apr 25 21:00:41 netzgames kernel: Out of Memory: Killed process 3655 (mysqld).
Apr 25 21:00:41 netzgames kernel: Out of Memory: Killed process 4069 (mysqld).
Apr 25 21:00:41 netzgames kernel: Out of Memory: Killed process 4367 (mysqld).
Apr 25 21:00:41 netzgames kernel: Out of Memory: Killed process 4673 (mysqld).
Apr 25 21:00:41 netzgames kernel: Out of Memory: Killed process 4699 (mysqld).
Apr 25 21:00:41 netzgames kernel: Out of Memory: Killed process 4702 (mysqld).
Apr 25 21:00:41 netzgames kernel: Out of Memory: Killed process 4803 (mysqld).
Apr 25 21:00:41 netzgames kernel: Out of Memory: Killed process 5071 (mysqld).
Apr 25 21:00:41 netzgames kernel: Out of Memory: Killed process 5073 (mysqld).
Apr 25 21:00:43 netzgames kernel: Out of Memory: Killed process 5075 (mysqld).
Apr 25 21:00:43 netzgames kernel: Out of Memory: Killed process 5104 (mysqld).
Apr 25 21:00:43 netzgames kernel: Out of Memory: Killed process 5494 (mysqld).
Apr 25 21:00:43 netzgames kernel: Out of Memory: Killed process 5508 (mysqld).
Apr 25 21:00:43 netzgames kernel: Out of Memory: Killed process 5514 (mysqld).
Apr 25 21:00:43 netzgames kernel: Out of Memory: Killed process 5519 (mysqld).
Apr 25 21:00:43 netzgames kernel: Out of Memory: Killed process 5548 (mysqld).
Apr 25 21:00:43 netzgames kernel: Out of Memory: Killed process 5621 (mysqld).
Apr 25 21:00:43 netzgames kernel: Out of Memory: Killed process 5624 (mysqld).
Apr 25 21:00:43 netzgames kernel: Out of Memory: Killed process 5646 (mysqld).
Apr 25 21:00:43 netzgames kernel: Out of Memory: Killed process 5695 (mysqld).
Apr 25 21:00:43 netzgames kernel: Out of Memory: Killed process 5895 (mysqld).
Apr 25 21:00:43 netzgames kernel: Out of Memory: Killed process 5978 (mysqld).
Apr 25 21:00:43 netzgames kernel: Out of Memory: Killed process 5979 (mysqld).
Apr 25 21:00:44 netzgames kernel: Out of Memory: Killed process 6003 (mysqld).
(...)
meine my.cfg
[mysqld]
max_connections = 800
key_buffer = 16M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 128
wait_timeout = 14400
connect_timeout = 10
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
skip-innodb
[safe_mysqld]
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
weis nun nicht, ob ihr sonst noch daten braucht.
Doch was könnte ich verändern, dass er sich nicht mehr aufhängt? :-/
Wäre um hilfe echt dankbar.
Ach was mir noch auffält, sobald ich den Apache starte, ist mein RAM bis auf 13 MB immer voll belegt.
Das hatte ich aber auch schon bei 1.3.x Versionen :-/