Vesta Control Panel - Forum

Code: Select all

key_buffer = 16K 
max_allowed_packet = 1M 
thread_stack = 64K 
table_cache = 4 
sort_buffer = 64K 
net_buffer_length = 2K

Code: Select all

max_connections= 20
connect_timeout= 5
wait_timeout= 28800
max_allowed_packet= 32M
thread_cache_size    = 50
sort_buffer_size= 4M
bulk_insert_buffer_size= 16M
tmp_table_size= 32M
max_heap_table_size= 32M
join_buffer_size= 256K
#
# * MyISAM
#
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched. On error, make copy and try a repair.
myisam_recover          = BACKUP
key_buffer_size= 128M
open-files-limit= 5000
table_open_cache= 2000
myisam_sort_buffer_size= 128M
concurrent_insert= 2
read_buffer_size= 2M
read_rnd_buffer_size= 1M

#
# * Query Cache Configuration
#
query_cache_type= OFF

#
# * Logging and Replication
#
log_warnings= 2
slow_query_log= 1
slow_query_log_file= /srv/d_cs-amx/mysql/log/mariadb-slow.log
long_query_time= 5
log_slow_verbosity= query_plan
log_bin= /srv/d_cs-amx/mysql/log/mariadb-bin
log_bin_index= /srv/d_cs-amx/mysql/log/mariadb-bin.index
sync_binlog= 1
expire_logs_days= 3
max_binlog_size        = 100M

#
# * InnoDB
#
default_storage_engine= InnoDB
innodb_buffer_pool_size= 128M
innodb_log_buffer_size= 8M
innodb_file_per_table= 1
innodb_open_files= 1024
innodb_io_capacity= 1024
innodb_flush_method= O_DIRECT
innodb_thread_concurrency= 0
innodb_stats_on_metadata= off
innodb_old_blocks_time= 1000