I'm looking into optimizing my database server and this is what I read in Maria's official documentation here.
How true is this? More so, how is this true?
Apologies if this is not the best place to ask this question. Please redirect me.
Server Fault is a question and answer site for system and network administrators. It only takes a minute to sign up.Sign up to join this community
In my experience, MySQL/MariaDB do not need much CPU. Hence HyperThreading (etc) are not very important in the performance question. Usually, heavy CPU usage is readily cured by
See http://mysql.rjweb.org/doc.php/mysql_analysis#slow_queries_and_slowlog for setting up the slowlog and providing suitable info for us to help you with fixing slow queries.
Hyperthreading, in hyper-simplified terms, is a compromise between number of CPU "cores" and speed of the cores. By adding hyperthreading, designers let you simultaneously run more processes that are CPU-bound, but each one takes a little longer to finish. A single connection to MariaDB will use only a single cpu hyperthread, so having more of them rarely helps. And, unless you are doing especially complex queries, each query will finish "fast enough".
Which is your situation?