Gore se vrti vBulletin i torrent tracker, kada je rush hour average server load je oko 1.1 (znaci da server moze izdrzat opterecenje) nakon desetak sati load bolesno naraste cak i do 100. Gledajuci top, svaki proces koristi maximalno 2% memorije jedino mysqld raste trenutno je na 10.1%, a prije 10 sati kad sam ga restarto je bio na 4%. Jel imate neki savijet da pogledam sta ga tocno jede, moje znanje mi nista drugo ne dopusta osim da restartujem sql
EDIT: primjetio sam da svaki proces ima TIME+ 0:XX.XX, a mysqld je na 34:16.69 ne znam sta to znaci ali valjda vi znate :D
my.cnf izgleda ovako (znam da je tu frend diro ove varijable pa bi mozda to bio problem??)
Code:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
set-variable = max_allowed_packet=32M
set-variable = max_connections=4000
set-variable = key_buffer_size=64M
set-variable = read_buffer_size=2M
set-variable = join_buffer_size=2M
set-variable = query_cache_size=32M
set-variable = tmp_table_size=32M
set-variable = table_cache=2000
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[Ovu poruku je menjao bananko dana 28.08.2008. u 12:14 GMT+1]