MariaDB - So many threads? I'm on a test VM based on VMWare with MariaDB + nginx installed; when looking with htop this is the situation:



So we have 26 threads under the main process.

I know that inactive threads doesn't impact so much in memory / performaces, but for my "know how", is there a way (parameters?) to reduce the number of child threads under MariaDB / MySQL?

Googling around I've found something related to max_connections and thread_concurrency parameters that I've set both to 5 but once restarted nothing changed.

Thank you very much for your answers!
Once you have had some activity, I think the number of threads varies between

(misc) + thread_cache_size
(misc) + max_connections


thread_concurrency was specific to Solaris 8, and has been removed from newer versions of MySQL/MariaDB.

Where (misc) is 1 for the main process plus replication slave threads plus innodb read/write/purge threads.  (Thanks danblack)