Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

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.

share|improve this question
1  
They are not quite instances of mysql, but threads. –  Marius Balaban Apr 28 '12 at 20:33

1 Answer 1

up vote 4 down vote accepted

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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