How to prioritize some queries in MySQL?

Question

I have a large number of background reads and records and a much smaller number of user reads from a high-level MySQL database - is there a way to mark certain queries (user queries) as having high priority so that they give preference to background queries? I want the user response to be high, but really don't care about background requests.

thanks

Answer 1

MySQl supports insert delayed for delayed insert and low_priority for update s. And for your user, the high_priority extension on select is read. If you use the MyISAM storage engine, there is a related (but different) parallel insertion .