Imali smo to upravo ovde na es-u. Problem je bio uglavnom u: 1. netuniranom mysqlu 2. lošem ponašanju mysqla na freebsdu kada je kompajliran bez linuxthreads

Koji operativni sistem, koja verzija mysql-a, koja podešavanja mysqla?
Daj show variables output.

Problem je sada (nadam se) resen, ali evo podataka:

OS je Red Hat 9, mysql ver.3.23.50
conf je bio Red Hat-ov 9 default a sada je stavljen conf za very large systems (huge) i sve radi brze a i nema sleep processa. Ovo su trenutne variable, na zalost nemam prethodni conf - bilo bi interesantno uporediti. Moj zakljucak je da je mysql imao malo resursa na raspolaganju i da se zbog toga gusio.
Nasao sam na netu dosta postova ljudi koji su imali ovakve probleme ali nisam nasao svrsishodne odgovore.
Znaci potrebno je ono sto je Gojko napisao - podesiti mysql i naravno pregledati dobro i testirati sve sql upite i maksimalno ih optimizovati da ne bi bespotrebno "jeli" resurse.

Ukoliko neko ima volje da gleda parametre i smatra da neke stvari treba drugacije definisati, bicu zahvalan na sugestijama.

back_log 50
basedir /usr/
binlog_cache_size 32768
character_set latin1
character_sets latin1 big5 cp1251 cp1257 croat czech danish dec8 dos estonia euc_kr gb2312 gbk german1 greek hebrew hp8 hungarian koi8_ru koi8_ukr latin2 latin5 swe7 usa7 win1250 win1251 win1251ukr ujis sjis tis620
concurrent_insert ON
connect_timeout 5
datadir /var/lib/mysql/
delay_key_write ON
delayed_insert_limit 100
delayed_insert_timeout 300
delayed_queue_size 1000
flush OFF
flush_time 0
have_bdb NO
have_gemini NO
have_innodb DISABLED
have_isam YES
have_raid NO
have_openssl NO
init_file
innodb_additional_mem_pool_size 1048576
innodb_buffer_pool_size 8388608
innodb_data_file_path
innodb_data_home_dir
innodb_file_io_threads 4
innodb_force_recovery 0
innodb_thread_concurrency 8
innodb_flush_log_at_trx_commit 1
innodb_fast_shutdown ON
innodb_flush_method
innodb_lock_wait_timeout 50
innodb_log_arch_dir
innodb_log_archive OFF
innodb_log_buffer_size 1048576
innodb_log_file_size 5242880
innodb_log_files_in_group 2
innodb_log_group_home_dir
innodb_mirrored_log_groups 1
interactive_timeout 28800
join_buffer_size 131072
key_buffer_size 402649088
language /usr/share/mysql/english/
large_files_support ON
locked_in_memory OFF
log OFF
log_update OFF
log_bin OFF
log_slave_updates OFF
log_long_queries OFF
long_query_time 10
low_priority_updates OFF
lower_case_table_names 0
max_allowed_packet 1047552
max_binlog_cache_size 4294967295
max_binlog_size 1073741824
max_connections 200
max_connect_errors 10
max_delayed_threads 20
max_heap_table_size 16777216
max_join_size 4294967295
max_sort_length 1024
max_user_connections 0
max_tmp_tables 32
max_write_lock_count 4294967295
myisam_max_extra_sort_file_size 256
myisam_max_sort_file_size 2047
myisam_recover_options 0
myisam_sort_buffer_size 8388608
net_buffer_length 16384
net_read_timeout 30
net_retry_count 10
net_write_timeout 60
open_files_limit 0
pid_file /var/run/mysqld/mysqld.pid
port 3306
protocol_version 10
record_buffer 2093056
record_rnd_buffer 2093056
query_buffer_size 0
safe_show_database OFF
server_id 0
slave_net_timeout 3600
skip_locking ON
skip_networking OFF
skip_show_database OFF
slow_launch_time 2
socket /var/lib/mysql/mysql.sock
sort_buffer 2097144
sql_mode 0
table_cache 512
table_type MYISAM
thread_cache_size 8
thread_stack 65536
transaction_isolation READ-COMMITTED
timezone CET
tmp_table_size 33554432
tmpdir /tmp/
version 3.23.58
wait_timeout 28800