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 Tbird67ForSale@stripped:
> In a message dated 10/16/03 9:27:04 AM Eastern Daylight Time,
> sgreen@stripped 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/mysql?unsub=1
>
>
----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.
