Quote:
Originally Posted by Mythar
Hello, im experimenting with moving my server from Windows to Ubuntu (18.04) linux.
The server im experimenting with, is running proxmox, and i have setup a lxc container.
Everything seems to work, but i was wondering if any here has fine tuned MySQL/MariaDB ?
I usually use PGTune for PostgreSql.
Container has 8GB ram and 6 VCores (Hope thats enough ?)
Underlaying proxmox server has 16x 10K HDDs in raid 1 + 0
|
The database configuration does not need to be crazily optimized, some decent memory allocated to a few different buffers and you should be good to go.
Use MariaDB and this should be more than adequate to add on top of the defaults
Code:
query_cache_limit = 10M
query_cache_size = 16M
query_cache_type = 1
query_cache_min_res_unit = 2k
key_buffer = 16M
key_buffer_size = 16M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 8
max_allowed_packet = 16M
innodb_buffer_pool_size = 100M
tmp_table_size = 16M