Question about query priorities and virtualization
Posted by: Udi Weinsberg
Date: January 28, 2008 07:41AM

Hi,
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.

Is there a good method to do this?

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?
Will this give me priorities?
Any other good method to do this?

Thanks!
UDi.

Options: ReplyQuote


Subject
Written By
Posted
Question about query priorities and virtualization
January 28, 2008 07:41AM


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.