Yes, we have high churn on some of our tables and running ANALYZE TABLE on them usually helps when the optimizer has gone stupid on us. In newer InnoDB(s) it *might* be sufficient to tweak how deep InnoDB dives into the indexes periodically to sample, but I've only tried that on our XtraDB test boxes so far. Our production 5.0.xx boxes end up benefiting from the occasional ANALYZE.
Jeremy On Thu, Jul 30, 2009 at 8:21 AM, Brian Aker <[email protected]> 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<https://launchpad.net/%7Edrizzle-discuss> > Post to : [email protected] > Unsubscribe : > https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-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
