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
