Mysql a processy

[David Ťok]

Zdravim,

  mam potize s mysql-3.23.51. Obcas, kdyz vzroste zatez, tak server
jakoby prestal killovat svoje thready. Pak ale odmita spojeni (od apache
z jineho stroje). Po nejakem case (5min+-) to vsechno vykilluje a zase
jede dal s nejakymi 35 thready. Load systemu jde i na 15 oproti
normalnim 0.9-2.

Zkousel jsem ruzne hybat s timeouty a omezenimi na pocet pripojeni,...
ale vzdycky to udelalo znova :-(.

S cim by se dalo jeste pohnout aby tento stav nenastaval...?

2xPentium3, 2GB RAM, jadro 2.2.19, stroj je to vyhradne pro mysql,
slouzi jako databaze webserveru.

/etc/my.cnf
[mysqld]
datadir=/var/mysql
socket=/var/run/mysql/mysql.sock
language=english
set-variable	= max_connections=384
set-variable	= max_connect_errors=40
set-variable	= key_buffer=384M
set-variable	= max_allowed_packet=1M
set-variable	= table_cache=1024
set-variable	= sort_buffer=32M
set-variable	= record_buffer=2M
set-variable	= thread_cache=16
set-variable	= thread_concurrency=4
set-variable	= myisam_sort_buffer_size=64M
set-variable	= max_sort_length=64
set-variable	= wait_timeout=60
set-variable	= interactive_timeout=600

Normalni zatez je asi zhruba:
Threads: 24  Questions: 125797  Slow queries: 40  Opens: 538  Flush
tables: 1  Open tables: 532 Queries per second avg: 183.378


diky za kazdy tip...

-- 
        david tok, uid: 0, C14H9Cl5 na coolnet.cz