Problem s MySQL a velkou zatezi.
Tomas Randa
lists at hosting50.cz
Wed Dec 8 15:17:44 CET 2004
Dobry den,
resim nasledujici problem s MySQL serverem o velke zatezi - kolem
200dotazu/s, verze 4.1.7:
v logu se objevuji ruzne hlasky, jako napr.:
#1041 - Out of memory; check if mysqld or some other process uses all
available memory; if not, you may have to use 'ulimit' to allow mysqld
to use more memory or you can add more swap space
041208 15:17:13 [ERROR] /usr/local/libexec/mysqld: Out of memory (Needed
65543 bytes)
atd.
Problem je ze uz nevim co s tim. Stroj ma fyzicky 2GB RAM, neswapuje.
Zvedal jsem promenne v my.cnf ale nepomaha to.
Nenasla by se tu dobra duse ktera by mela nejaky napad co s tim?
my.cnf:
[mysqld]
port = 3306
datadir = /data/db/mysql
socket = /tmp/mysql.sock
skip-locking
key_buffer = 960M
max_allowed_packet = 8M
table_cache = 1024
sort_buffer_size = 4M
read_buffer_size = 4M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache = 16
net_buffer_length = 65536
query_cache_size = 64M
thread_concurrency = 2
Diky moc za pomoc.
Tomas Randa, ICQ 100956181, lists at hosting50.cz
More information about the Users-l
mailing list