Baza jeste 'veca' - sve ukupno nekih 2.6GB, ima 20ak DB-a i 2 imaju preko 200 tabela. Koristim je samo ja, za razvoj aplikacije, znaci pristupam iskljucivo iz lokala i to je to. Prvih pola sta koristenja odaziv je i dobar, onda pocne da usporava i uspoarava.. Desavalo mi se da kad je tako spora, kad se nakacim na DB i uradim 'show tables' da mu treba i po 20sec da mi odgovori???
Restartujem, pa onda malo bolje, ali mi se svejedno cini sporom. Osim toga, u process usage monitoru (ili kako se vec zove win app) vidim da stalno cita i pishe po disku, cak i kad nista nije nakaceno na DB. Ne prekida.. ?
Ima li pomoci?
MySQL verzija je 5.1.41.
Ovo je dio conf fajla (ja sam vec mjenjao vrijednosti)
[mysqld]
basedir = "C:/xampp/mysql/"
datadir = "C:/xampp/mysql/data/"
port = 3306
socket = "MySQL"
skip-locking
key_buffer = 256M
max_allowed_packet = 16M
table_cache = 256
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
query_cache_size = 52428800
default-time-zone = "Europe/Paris"
log_error = "C:/xampp/mysql/data/mysql.err"
pid_file = "mysql.pid"
general_log = 0
general_log_file = "C:/xampp/mysql/data/mysql.log"
slow_query_log = 1
slow_query_log_file = "C:/xampp/mysql/data/mysql-slow.log"
enable-named-pipe
skip-federated
#log-bin = mysql-bin
#binlog_format = mixed
server-id = 1
# Point the following paths to different dedicated disks
tmpdir = "C:/xampp/tmp/"
#log-update = "C:/xampp/tmp/mysql"
innodb_data_home_dir = "C:/xampp/mysql/data/"
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = "C:/xampp/mysql/data/"
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50