Hello.

I recently installed the newer 4.x series mysql. When started up using safe_mysqld it spawns 10 servers listening for connections. This is too many for the amount of traffic my site gets. 3 would be more like it...however I can't find a reference to change the number of servers started up anywhere in my.cnf or in the mysql docs.

Does anybody know how to change this, as you would do with the max_spare_servers directive in apache?

Just want to keep my system as slim as possible.

Thanks

*bump*

no one knows?

*cough* *bump*

Mysql, you know, mysql...
Surely someone must know this.

I'm REALLY a newbie, so I don't know if this is what you are searching for, but if you want to mantain the system as slim as possible, as you said, I guess you should tune your mysql server starting it as:

mysqld-safe -O --thread_concurrency var=3

(check the command line syntax...)

Ok, please don't flame me if it doesn't works. And remember to set it back to 10, if you've problems.

I hope to have been of help.
C'ya.

Well this got me on the right track, but doesn't do anything.

I hit up the man page and the docs, and they said that with the version I use you can just add the option:
"Please note that --set-variable is deprecated since MySQL 4.0, just use --var=option on its own"
so I tried:
mysqld --thread_concurrency=3
it starts, but still with 10 instances.
mysqld -O --thread_concurrency=3
craps out with an error:
"unknown option: --thread_concurrency"
even though it is in the manual.

And dude, don't worry, don't flame people in general, and I certainly won't when you have helped me.

I do appreciate it. And although it is still not working, I have a bit more of a clue, and will keep playing around with it...

Mhh, at this point my advice is to try posting a message to the appropriate mailing list. This should be the one:

http://lists.mysql.com/list.php?list=mysql&sub=1

Mozilla should be able to manage also a threaded view.

OK i'll try the list.

Thanks