Pozdrav,
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.
Da li moze mala pomoc oko sto finijeg setovanja Mysql Config fajla.
Trenutno ovako izgleda moj my.cnf
Citat:
[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.