Da li moze mala pomoc oko sto finijeg setovanja Mysql Config fajla.
Trenutno ovako izgleda moj my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
old_passwords=1
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[ndbd]
connect-string="nodeid=2;host=localhost:1186"
[ndb_mgm]
connect-string="host=localhost:1186"
wait_timeout=60
connect_timeout = 10
interactive_timeout = 120
net_buffer_length = 1024K
join_buffer_size = 4M
sort_buffer_size = 8M
read_buffer = 2M
write_buffer = 2M
read_buffer_size = 4M
read_rnd_buffer_size = 4M
table_cache = 500
max_allowed_packet = 32M
max_connections=30
max_user_connections=200
myisam_sort_buffer_size = 64M
key_buffer = 128M
key_buffer_size = 64M
thread_stack = 128K
thread_cache_size = 128
thread_concurrency = 8
query_alloc_block_size = 16k
Query_cache_limit = 2M
Query_cache_size = 128M
Query_cache_type = 1
long_query_time = 3
table_cache = 800
table_open_cache = 128
table_definition_cache = 800
query_cache_min_res_unit = 5K
delay-key-write=OFF
[mysqldump]
quick
max_allowed_packet = 16M
[mysqlhotcopy]
interactive-timeout
Koristim Joomla CMS i Invision Board, radi se o sajtovima koje vidite u mojoj signaturi.
Nisam strucan mnogo u My.cnf finim podesavanjima i max iskoriscenosti sistema.
Moj hosting je baziran na VPS-u koristim Fedora 11 OS.
Mysql nosi verziju 5.1.47
Ram velicina 786MB, stalna iskoriscenost ne prelazi preko 300MB kad je pod nekim opterecenjem (220mb u stanju mirovanja), ja bi zeleo ako mogu da povecam da mysql koristi vise rama za brzi load ili sta vec, mozda i ram ne utice tolko.
Isto ne znam jel ima nesto posebno u Apache i PHP da se podesi :P ali to je vec za neki drugi deo foruma.
Hvala unapred na pomoci.