In MySQL 5.5 and higher, you can change the setting of
dynamically at runtime, to control whether or not InnoDB
performs statistics gathering when metadata statements are
executed. To change the setting, issue the statement
0). Changing this
setting requires the
SUPER privilege and
immediately affects the operation of all connections.
This setting is related to the feature described in Section 8.5, “Controlling Optimizer Statistics Estimation”.