Posts

Showing posts from 2013

Why is my MySQL server using a single core while my processor has multiple cores ?

Image
I am writting my first ever blog post after four and a half years since I started my career as a MySQL DBA. I used to read lots of blog posts  especially from mysqlperformceblog , but  never really had the interest of writting one.  But this interesting question from a client made me write this blog post. “Why is my MySQL consuming only “core 0”, while I have 8 cores and there is hardly any usage in the other cores?” This is a question put forward by one of our clients. Started my investigation by looking into the cpu usage stats. It was true that only “core 0” was getting used and the other cores were rarely getting used.  Usage of “core 0” was like below Where as there is hardly any usage in the other cores as shown below But if we look at the overall cpu usage it rarely crossed 30%. But the client questioned “why can’t MySQL share the usage in ‘core 0’ with other cores?” In my first look found that the machine is a dedicated for MySQL with multi-thread