High CPU usage by mariadb even after allocated more memory to mariadb?

mysql linux cpu-usage mariadb

Solution 1:

200% isn't a lot of CPU when you have 16 cores. 200% is two full cores (amongst the 16 you have in an r4.4xlarge). Considering the amount of memory you have in use, MariaDB is certainly up to something. The fact that you are only using 2 of your 16 cores, I'd say you were under utilising CPU.

Use the htop utility to better see mariaDB's use of the cores.

Solution 2:

There was a bug https://jira.mariadb.org/browse/MDEV-15016 . That bug got fixed. Use latest version (10.2.13, 10.3.5) and verify everything is OK again.

Related

Extracting part of the string using Ansible regex_search and save the output as a variable
Extraneous solution from substituting in equations
Connected Implies Path (Polygonally) Connected
Repeated squaring techniques
In what sense is the forgetful functor $Ab \to Grp$ forgetful?
singularity of analytic continuation of $f(z) = \sum_{n=1}^\infty \frac{z^n}{n^2}$
How to solve $|a+b|+|a-b|=c$?
2 is a primitive root mod $3^h$ for any positive integer $h$
Probability of being dealt four-of-a-kind in a set of $5$ cards?
Chromatic polynomial for a bipartite graph
How do we calculate this sum $\sum_{n=1}^{\infty} \frac{1}{n(n+1)\cdots(n+p)}$?
Why $L^{r}(X)\cap L^{t}(X)\subset L^{s}(X)$ for $1<r<s<t$?