The configuration options “innodb_analyze_is_persistent”, “innodb_stats_persistent_sample_pages” and “innodb_stats_transient_sample_pages” provide improved accuracy of InnoDB index statistics, and consistency across MySQL restarts. InnoDB precomputes statistics that help the optimizer decide which indexes to use in a query, by sampling a portion of the index. You can adjust the amount of sampling that InnoDB does for each index. The resulting statistics can now persist across server restarts, rather than being recomputed (and possibly changing) due to restarts and some runtime events. The more accurate statistics can improve query performance, and the persistence aspect can keep query performance stable. When the persistent stats feature is enabled, the statistics are only recomputed when you explicitly run ANALYZE TABLE for the table.

Question

trilok sharma · Accepted Answer

The configuration options “innodb_analyze_is_persistent”, “innodb_stats_persistent_sample_pages” and “innodb_stats_transient_sample_pages” provide improved accuracy of InnoDB index statistics, and consistency across MySQL restarts. InnoDB precomputes statistics that help the optimizer decide which indexes to use in a query, by sampling a portion of the index. You can adjust the amount of sampling that InnoDB does for each index. The resulting statistics can now persist across server restarts, rather than being recomputed (and possibly changing) due to restarts and some runtime events. The more accurate statistics can improve query performance, and the persistence aspect can keep query performance stable. When the persistent stats feature is enabled, the statistics are only recomputed when you explicitly run ANALYZE TABLE for the table.

[. For the following questionsFind the odd word/letters/number from the given alternatives.Options:]

[For the following questionsFind the odd word/letters/number from the given alternatives.Options:]

[Select the missing numbers from the given responses]

[The self organizing list improves the efficiency of _______]

[As the SMI approaches 1.0, the software product starts becoming unstable]

[.Select the related word/letters/numbers from the given alternatives:42 : 56 :: 110 : ?]

[When the processor receives the request from a device, it responds by sending __]

[.A series is given, with one term missing. Choose the correct alternative from the given ones that will complete the series....

[Which of the following is the correct syntax to declare an ArrayList in Java?]

[Which of the following are the common factor of 21 x2y and 35 xy2?]

Featured Courses

Popular Pages

SAT (Scholastic Assessment Test)

NET

Reasoning special by Parwez Alam

Defence

Study24x7

UPSC & State PSC

Henry Harvin

CBSE Study Materials

SSC Preparation Strategies & Study Mater...

Banking/IRDA

Get the App

[The Application Process For GATE Exam]

[ESE Application form 2021- The complete process to fill the...

[ESE Application form 2021- The complete process to fill the...

[ESE Exam 2021 Overview]

[Preparation Strategy for ESE Civil Engineering]

[UPSC ESE 2020 Exam Analysis]

[Top 5 PSU companies hiring through GATE]

[Why to opt for PSU exams?]

[Preparation Strategy for ESE Electronics & Telecommunicatio...

[Facts you should know about PSU Exams]