As I understand it mysql is a single process multi-threaded application. I have heard of some thread schedulers that allow for a certain granularity of determining where to run a particular thread / process. I think this is the purpose behind Sun's processor groups.
Is there such a thing for Linux? Quoting [EMAIL PROTECTED]: > In a message dated 10/16/03 9:27:04 AM Eastern Daylight Time, > [EMAIL PROTECTED] writes: > > > This is down to the OS. As MySQL is multy threaded its all down to SMP > > support. > > > > with all due respect, I don't think that is 100% true. Although certainly > the underlying OS kernel must support multi-processors and discrete processor > > selection functionality, I am looking for user-based control of query > execution. > That would have to come from the DB package. Oracle has such functionality > > (at least on Unix-based versions) that I've used recently, including the > ability to dynamically allocate more processors to a running query. We do > this all > the time to complete a task of higher priority than others. Certainly with > Oracle one pays dearly for such software. I am just wondering what options > are > available in MySQL (if any). > > For example, I want to enable one user to perform read-only queries using the > > full machine resources. Other times, I'd like to restrict the queries from a > > specific user or group to processor 0 while the other 3 (or more) are > dedicated to handling higher priority tasks. > > Its likely that such features would bloat MySQL ... and I'd never want that, > > not even a fan of the sotred-procs... just making sure I am not missing > something in the docs or from some of the wizardry out there. > > :-) > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]