MySQL/MariaDB optimization?

[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

[Akkadius]

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

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

[Mythar]

Thx, i will try it out