let mysql use full resources
Posted
by
shekhar
on Super User
See other posts from Super User
or by shekhar
Published on 2014-06-06T08:29:18Z
Indexed on
2014/06/06
9:28 UTC
Read the original article
Hit count: 247
We have a Windows server 2008 R2. It has 24GB RAM and 2.926 Mhz, 8 Core(s), 8 Logical Process.
We have a large MySQL database and it's taking a lot of time to execute some queries. But while running queries, I have observed it's NOT utilizing full resources. I am thinking that if I let MySQL utilize maximum resources on my server, it can reduce execution time.
How can I let my MySQL server utilize maximum resources in a healthy way?
© Super User or respective owner