InnoDB calculates its index statistics from the data pages already buffered in the buffer pool. This allows for faster statistics collection without requiring a full table scan.
A. Updating index statistics is an I/O expensive operation.
When InnoDB updates index statistics, it requires scanning the data pages on disk to calculate the statistics, which can be I/O-intensive, particularly if the table is large. The more pages InnoDB has to scan, the more expensive the operation becomes.
D
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_stats_persistent_sample_pages
The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE. [Increasing the value improves the accuracy of index statistics, which can improve the query execution plan], at the expense of increased I/O during the execution of ANALYZE TABLE for an InnoDB table.
Not C
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_stats_auto_recalc
This setting applies to tables created when the innodb_stats_persistent option is enabled.
A.
C is not correct because it mentions: "The innodb_stats_auto_recalc variable, which is enabled by default, controls whether statistics are calculated automatically when a table undergoes changes to more than 10% of its rows, not when new indexes are created.
When an index is added to an existing table, or when a column is added or dropped, index statistics are calculated and added to the innodb_index_stats table regardless of the value of innodb_stats_auto_recalc.
D is not about persistent indexed. E might be the answer but not sure
upvoted 2 times
...
This section is not available anymore. Please use the main Exam Page.1z0-908 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Miao089
5 days, 2 hours agoabpg
5 months, 3 weeks ago7206e44
9 months, 3 weeks agojackymak
1 year, 3 months agoZehir
1 year, 5 months agoboyjhantan
1 year, 6 months agoavrely
2 months, 3 weeks agoboyjhantan
1 year, 6 months agonkanike1
1 year, 7 months agomarklv
1 year, 7 months ago