> 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.
The unsatisfying thing is that (as Jeremy suggested) the limited sampling makes it error prone. I've met quite a few customers who want to disable automatic resampling because InnoDB keeps switching to sub optimal plans. They'd rather run ANALYZE TABLE manually (or schedule a cron job), so they can be on hand when it screws up. See http://bugs.mysql.com/bug.php?id=26598 and http://www.bigdbahead.com/?p=135 Perhaps the real solution would be to improve the sampling ;) - Morgan _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
