am setat innodb_buffer_pool_size=24G
si a scazut load de la 0.50 la 0.15 in cateva secunde.
ce ar mai fi de setat in my.cnf, daca nu cer prea mult?
asta am acuma:
[mysqld]
innodb_file_per_table=1
innodb_buffer_pool_size=24G
#skip-locking
#safe-show-database
#old_passwords=1
long_query_time=2
#log-slow-queries=/var/log/mysql-slow-queries.log
query_cache_limit=1M
query_cache_size=1G
query_cache_type=1
max_user_connections=1000
max_connections=1200
thread_cache_size=256
table_cache=8192
table_definition_cache=1280
key_buffer=256M
max_connect_errors=20
max_allowed_packet=128M
join_buffer=16M
#record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
read_rnd_buffer_size=1M
thread_concurrency=4
myisam_sort_buffer_size=64M
local-infile=0
concurrent_insert=2
max_heap_table_size=3G
tmp_table_size=3G
join_buffer_size=4M
open_files_limit=3584
Răspunde cu citat