8

I'm not an server administrator, but i would like to know why on the server i have like 10 myslq instances? Is it good or bad? Does it negatively impact speed of my website?

Here's screenshot: enter image description here

Thanks.

  • 1
    They are not quite instances of mysql, but threads. – Marius Balaban Apr 28 '12 at 20:33
10

By default MySQL starts more processes ("threads") to improve performance. If you are familiar with Apache, it does the same thing.

If you want to limit the number of threads, you'll want to limit the number of connections. You can use the max_user_connections variable to do this or with recent versions (5.5+) you can limit them per user.

|improve this answer|||||
  • Will that slow down mysql ? – Xsmael Mar 11 at 17:11
  • Your cpu is more important in that regards. If you got the CPU for it you won't notice it. – Rinzwind Mar 11 at 17:36
  • in fact, I'am experiencing this issue but do not have much option to increase CPU anytime soon, users are complaining about the web app being very slow and i suspected it was because of the database, and indeed it is, seeing the CPU at 100% almost all the time... So I was wondering what i could do to improve speed, using the same CPU. – Xsmael Mar 11 at 18:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.