I have a large number of background reads and writes, and a much smaller number of user reads, of a highly contended MySQL database - is there any way to flag certain queries (the user queries) as being high priority so that they take preference over background queries? I want user responsiveness to be high, but don't really care about the background queries.
我有大量的后台读取和写入,以及用户读取数量少得多的高度争用的MySQL数据库 - 有没有办法将某些查询(用户查询)标记为高优先级,以便他们优先考虑背景查询?我希望用户响应能力很高,但并不真正关心后台查询。
Thanks
1 个解决方案
#1
5
MySQl supports insert delayed for delayed inserts and low_priority for updates. And for your user reads, there's the high_priority extension on select. If you're using the MyISAM storage engine, there's the related (but different) concurrent inserts feature.
MySQl支持延迟插入的插入延迟和更新的low_priority。对于您的用户读取,select上有high_priority扩展名。如果您正在使用MyISAM存储引擎,则会出现相关(但不同)的并发插入功能。
#1
5
MySQl supports insert delayed for delayed inserts and low_priority for updates. And for your user reads, there's the high_priority extension on select. If you're using the MyISAM storage engine, there's the related (but different) concurrent inserts feature.
MySQl支持延迟插入的插入延迟和更新的low_priority。对于您的用户读取,select上有high_priority扩展名。如果您正在使用MyISAM存储引擎,则会出现相关(但不同)的并发插入功能。