Comment 3 for bug 1159802

Revision history for this message
Swany (greenlion) wrote : Re: [Bug 1159802] Re: innodb_stats_auto_update and innodb_stats_on_metadata should be both disabled

That is how we teach it in class. Is this unexpected?

Sent from my iPhone

On Mar 26, 2013, at 7:21 PM, Laurynas Biveinis <email address hidden> wrote:

> These two variables are not exactly identical. For example,
> innodb_stats_auto_update=1, innodb_stats_on_metadata=0 should cause
> stats update on sufficient table rows changed, but not on the metadata
> ops.
>
> Let's document this for now.
>
> ** Also affects: percona-server/5.1
> Importance: Undecided
> Status: New
>
> ** Also affects: percona-server/5.5
> Importance: Undecided
> Status: New
>
> ** Also affects: percona-server/5.6
> Importance: Undecided
> Status: New
>
> ** Changed in: percona-server/5.6
> Status: New => Invalid
>
> ** Changed in: percona-server/5.5
> Status: New => Triaged
>
> ** Changed in: percona-server/5.5
> Importance: Undecided => Low
>
> ** Changed in: percona-server/5.1
> Importance: Undecided => Low
>
> ** Changed in: percona-server/5.1
> Status: New => Triaged
>
> ** Changed in: percona-server/5.1
> Assignee: (unassigned) => Hrvoje Matijakovic (hrvojem)
>
> ** Changed in: percona-server/5.5
> Assignee: (unassigned) => Hrvoje Matijakovic (hrvojem)
>
> ** Tags added: doc
>
> --
> You received this bug notification because you are subscribed to Percona
> Server.
> Matching subscriptions: percona-server-bugs
> https://bugs.launchpad.net/bugs/1159802
>
> Title:
> innodb_stats_auto_update and innodb_stats_on_metadata should be both
> disabled
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/percona-server/+bug/1159802/+subscriptions