问题描述:
[单选]
A database exists as a read-intensive server that is operating with query_cache_type = DEMAND.The database is refreshed periodically, but the resultset size of the queries does not fluctuate.Note the following details about this environment:数据库作为一个读密集型服务器存在,该服务器使用query_cache_type=DEMAND。需求数据库会定期刷新,但查询的resultset大小不会波动。注意有关此环境的以下详细信息:-A web application uses a limited set of queries.web应用程序使用有限的查询集。-The Query Cache hit rate is high.查询缓存命中率高。-All resultsets fit into the Query Cache.所有结果集都适合查询缓存。-All queries are configured to use the Query Cache successfully.所有查询都配置为成功使用查询缓存。The response times for queries have recently started to increase. The cause for this has correctly been identified as the increase in the number of concurrent users accessing the web service.Based solely on the information provided, what is the most likely cause for this slowdown at the databaselevel?查询的响应时间最近开始增加。其原因已被正确地确定为访问web的并发用户数量的增加基于服务仅根据所提供的信息,在数据库级别上最有可能导致这种减速的原因是什么?
A.The Query Cache is pruning queries due to an increased number of requests.
B.Query_cache_min_res_unit has been exceeded, leading to an increased performance overhead due to additional memory block lookups.
C.Mutex contention on the Query Cache is forcing the queries to take longer due to its single-threaded nature.由于查询缓存的单线程特性,查询缓存上的互斥争用正迫使查询花费更长的时间。
D.The average resultset of a query is increasing due to an increase in the number of users requiring SQLstatement execution.
参考答案:查看无
答案解析:无
☆收藏
答案解析:无
☆收藏
上一篇:Which two statements are true about InnoDB auto-increment locking?关于InnoDB auto-increment锁,哪两种说法是正确的?()
下一篇:Which query would you use to find connections that are in the same state for longer than 180 seconds?您将使用哪个查询来查找处于相同状态超过180秒的连接?()
- 我要回答: 网友(216.73.216.168)
- 热门题目: 1.安全通道、防护棚上警示标识牌 2.除上海地区外,“中国建筑集团 3.大门制作中,可在门上开设小门
