MariaDB configurations

I see in the mariadb-server.cnf there is a comment saying some options are tuned for “low-end devices (Like a Raspberry Pi)”.

Can we have a way to override the settings, or select an alternative profile when running on better performing hardware (e.g. NUC, VMs, etc)?

I think it may be lagging a fair bit on large queries and seems to be using very little of the available CPU/RAM allocated. I would like a way to tune it for better performance on a mid or higher end device with several GB RAM and multiple CPUs available.

Very much interested in exposing either basic memory settings or entire MariaDB config. I’m running my Hassio Supervised on a mini-PC which gives me enough memory to bump these settings up.