MySQL Forums
Forum List  »  Events (Job Scheduler)

Query Priorities
Posted by: Udi Weinsberg
Date: January 28, 2008 08:07AM

I have two types of customers that make queries - high and low priority.
I need that if a high priority customer starts a query, all low priority queries will be 'suspended' and once the high priority completes - the low priority should resume.

Can the job scheduler help me here?

If not, I thought of running a virtual server with mysqld that will serve only the low priority clients. The entire virtual server process will be with low priority, thus if a high priority query will be executed, the virtual server will get sched'ed out.

Will this work? Can I run two mysqld that operate on the same data?


Options: ReplyQuote

Written By
Query Priorities
January 28, 2008 08:07AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.