🚀 go-pugleaf

Witam,

oto moj plik: my.cnf
// --
[mysqld]
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /home/mysql/data
tmpdir          = /home/mysql/tmp
bind-address    = 0.0.0.0
skip-name-resolve
max_connections = 1000
skip-locking

#key_buffer = 6144M
key_buffer = 4096M
max_allowed_packet = 16M
#table_cache = 768
table_cache = 8192
sort_buffer_size = 2048M
net_buffer_length = 64K
read_buffer_size = 128K
#read_rnd_buffer_size = 128K
read_rnd_buffer_size =258048
myisam_sort_buffer_size = 2048M

thread_cache = 16
query_cache_limit = 8388608
#query_cache_size = 2048M
query_cache_size = 134217728
query_cache_type=1
query_cache_min_res_unit = 1M
thread_concurrency = 8
max_binlog_size = 64M
#max_heap_table_size = 4096M
tmp_table_size = 2048M

#log_slow_queries       = /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
#log_bin                        = /var/log/mysql/mysql-bin.log
// --

Serwer ma 12GB RAM-u, 8 rdzeni. Nie działa cache dla zapytan oraz
zapytania dzialaja dosyc wolno. Czy moge cos jeszcze pozmieniac w tym
pliku konfiguracyjnym, aby to zmienic?

Dzieki z gory.

Pozdrawiam