Download your favorite Linux distribution at LQ ISO.
Go Back > Forums > Linux Forums > Linux - Software
User Name
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.


  Search this Thread
Old 01-16-2007, 04:33 AM   #1
Registered: Apr 2004
Location: Leeds, UK
Distribution: FC1, FC2, Debian
Posts: 308

Rep: Reputation: 30
MySQL: Single thread, how can I get more?

We have MySQL 4.1 running on a RedHat box, and contrary to previous installs I've done when it starts there is only 1 linux thread running for it. I'm used to seeing 10-ish. This single thread can run up to 50% cpu (viewed in `ps aux`). Is there a way I can tell mysql to increase the number of threads started?
Old 01-16-2007, 10:50 AM   #2
LQ Newbie
Registered: Jan 2007
Posts: 8

Rep: Reputation: 0
Mysql Threads

I've been running Mysql for awhile under Suse. My current version is 5.0.26. Mainly because I just upgraded to Suse 10.2, but before then I was running version 4 (which minor I'm not sure since I've slept a time or two since then At any rate, getting back to mysql threads. As far as I know, mysql will start with 1 thread, but as more users log in, additional threads are spawned. You can limit the number of threads when settting it up, but I've never found anything in regards to setting the number of threads to start out with. However, you can find what options are required to get what you want by running "mysqld --verbose --help" and if that don't answer your questions, perhaps "man mysqld"? There is a setting in there for "--thread-cache-size" but that is for setting the maximum number of threads to allow




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
So many AC-97 sound problems, lets bring them to a single thread. nathanmoorehead Linux - Hardware 20 01-03-2007 11:20 AM
How to Umount single MySQL database KimVette Linux - Software 2 07-13-2005 12:55 PM
How to read a single sequential record from MySQL? VorlonInfoTech Linux - Software 1 11-17-2004 10:08 PM
MySql Thread error on startup Biggen Linux - Software 9 09-30-2004 08:05 AM
MySQL - command - create user/single database dmedici Linux - Software 3 06-21-2004 03:17 PM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 05:10 PM.

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