LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 08-01-2003, 11:38 PM   #1
bulliver
Senior Member
 
Registered: Nov 2002
Location: Edmonton AB, Canada
Distribution: Gentoo x86_64; Gentoo PPC; FreeBSD; OS X 10.9.4
Posts: 3,760
Blog Entries: 4

Rep: Reputation: 78
mysql "max spare servers"????


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
 
Old 08-04-2003, 07:42 AM   #2
bulliver
Senior Member
 
Registered: Nov 2002
Location: Edmonton AB, Canada
Distribution: Gentoo x86_64; Gentoo PPC; FreeBSD; OS X 10.9.4
Posts: 3,760
Blog Entries: 4

Original Poster
Rep: Reputation: 78
*bump*

no one knows?
 
Old 08-16-2003, 04:16 PM   #3
bulliver
Senior Member
 
Registered: Nov 2002
Location: Edmonton AB, Canada
Distribution: Gentoo x86_64; Gentoo PPC; FreeBSD; OS X 10.9.4
Posts: 3,760
Blog Entries: 4

Original Poster
Rep: Reputation: 78
*cough* *bump*

Mysql, you know, mysql...
Surely someone must know this.
 
Old 08-16-2003, 04:38 PM   #4
tchernobog
Member
 
Registered: Aug 2003
Distribution: Latest Gentoo; Mandrake 9.1
Posts: 37

Rep: Reputation: 15
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.
 
Old 08-16-2003, 07:51 PM   #5
bulliver
Senior Member
 
Registered: Nov 2002
Location: Edmonton AB, Canada
Distribution: Gentoo x86_64; Gentoo PPC; FreeBSD; OS X 10.9.4
Posts: 3,760
Blog Entries: 4

Original Poster
Rep: Reputation: 78
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...
 
Old 08-17-2003, 05:50 AM   #6
tchernobog
Member
 
Registered: Aug 2003
Distribution: Latest Gentoo; Mandrake 9.1
Posts: 37

Rep: Reputation: 15
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.
 
Old 08-17-2003, 03:25 PM   #7
bulliver
Senior Member
 
Registered: Nov 2002
Location: Edmonton AB, Canada
Distribution: Gentoo x86_64; Gentoo PPC; FreeBSD; OS X 10.9.4
Posts: 3,760
Blog Entries: 4

Original Poster
Rep: Reputation: 78
OK i'll try the list.

Thanks
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Buzilla issue: "Can't connect to local MySQL server through socket '/tmp/mysql.sock'" vitopn Linux - General 3 05-21-2007 11:13 AM
"Xlib: extension "XFree86-DRI" missing on display ":0.0"." zaps Linux - Games 9 05-14-2007 04:07 PM
Linux 2.6.4 Boot Failure : "hda: max request size" tmc Linux - General 2 07-07-2004 07:40 AM
Can't find the "servers" option in the control center in Mandrake 10.0 Ggrot Mandriva 2 05-28-2004 10:22 AM
MySQL setup stops at command "./configure --prefix=/usr/local/mysql" k41184 Linux - Software 1 05-20-2004 03:44 PM


All times are GMT -5. The time now is 08:44 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration