mariadb.conf tweak for 16 GB RAM

Post Reply
User avatar
webxtek
Posts: 27
Joined: Wed Nov 18, 2020 7:43 pm
mariadb.conf tweak for 16 GB RAM

Post by webxtek »

Hi everyone,

I'm running a hetzner cloud with 4 vcpus and 8gb ram, planing to move to 16gb ram, anyway is there any special tweaks i could give to optimize more the server?

Thanks everyone :D

User avatar
dpeca
Site Admin
Posts: 551
Joined: Fri Jun 19, 2020 9:59 am
Your location: Serbia, Niš and Belgrade
First name and last name: Predrag Damnjanović
Re: Optimize DB

Post by dpeca »

my tweak of mariadb.conf for 16GB

Code: Select all

key_buffer_size = 512M
max_allowed_packet = 32M
# table_open_cache = 256
sort_buffer_size = 4M
net_buffer_length = 16K
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 128M
# thread_cache_size = 8
# query_cache_size= 16M
# thread_concurrency = 8

#innodb_use_native_aio = 0
innodb_file_per_table

max_connections=200
max_user_connections=50
# wait_timeout=30
interactive_timeout=50
long_query_time=5

table_open_cache = 20480
thread_cache_size = 384
query_cache_size = 50M
# thread_concurrency = 16
wait_timeout = 180
join_buffer_size = 16M
query_cache_type = 1
tmp_table_size = 512M
innodb_buffer_pool_size=2G


Post Reply