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