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.
:-)
