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]
