There us in the InnoDB Plugin a parameter to control the number of
index dives, and a bug fix for 64-bit machines regarding sampling.
Chech the doc on InnoDB.com.
Ken
Sent from my iPhone
On Jul 31, 2009, at 1:46 AM, dormando <[email protected]> wrote:
I tend to issue this about once a week against production... Usually
if
something flips around more than once we push out a USE INDEX hint and
bury it though.
If there's any way to improve the sampling, or optionally disable it,
that'd be a big help. Systems like TheSchwartz tend to go from empty
to
full in a weird way and back again often, which break the query plan
almost consistently.
-Dormando
On Thu, 30 Jul 2009, Brian Aker wrote:
Hi!
What experiences have people had with ANALYZE TABLE? Tinkering
around with it
I am wondering if anyone ever uses this with Innodb with any
satisfaction.
Cheers,
-Brian
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
