MySQL考试

Which statement is true about InnoDB persistent index statistics?

发布于 2021-02-25 23:45:16

【单选题】
A Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.
B Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.
C Updating index statistics is an I/O expensive operation.
D Execution plans based on transient index statistics improve precision when innodb_stats_persistent_sample_pages is increased.
E Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.

关注者

0

被浏览

33

杜霄凡 2023-02-25

会修电脑

此回答被采纳为最佳答案，开通VIP会员可查看

1 个回答

撰写答案

请登录后再发布答案，点击登录

关于作者

新年

这家伙很懒，什么也没写！

提问

回答

1249

被采纳

1249

关注TA

发私信

相关问题

1

认可是由认可机构对()以及从事评审、审核等认证活动人员的能力和执业资格,予以承认的合格评定活动。

2

<{p}>You wish to protect your MySQL database against SQL injection attacks.<{/p}><{p}>Which method would fail to do this?<{/p}>

3

<{p}>Examine this command, which executes successfully:<{/p}><{p}> $ mysqlrouter --bootstrap<{span style="font-size: 1em;"}>Examine this command, which executes successfully:<{/span}><{/p}><{p}> $ mysqlrouter --bootstrap user@hostname:port --directory=directory_path<{br/}>Which activity is performed?<{/p}>

4

《中华人民共和国认证认可条例》制定的目的是为了规范认证认可活动,提高产品、服务的(),促进经济和社会的发展。

5

被审批岗否决退回的贷款项目，贷款上报单位根据审批岗的反馈意见，经充分研究和补充论证后，可要求审批岗进行贷款复议，复议可以进行（）次。

6

<{p}>You issue this command:<{br/}>SHOW SLAVE STATUS<{br/}>In the output, there is a value for Seconds_behind_master. <{br/}>How is this time calculated?<{/p}>

7

认证认可活动应当遵循()的原则

8

Which condition is true about the use of the hash join algorithm?

9

安全性审查主要（）。

10

<{p}>Your MySQL environment has asynchronous position based-replication with one master and one slave.<{br/}>The slave instance had a disk I/O problem, so it was stopped.<{br/}>You determined that the slave relay log files were corrupted and unusable, but no other files are damaged.<{br/}>You restart MySQL Server.<{br/}>How can replication be restored?<{/p}>

发布
问题

手机
浏览

扫码手机浏览

在线
客服