undefined | Better HN

0 pointsovi2567y ago0 comments

I've written cron jobs to update mysql statistics to prevent it from choosing bad query plans. It's as terrible as it sounds.

0 comments

2 comments · 1 top-level

pas7y ago· 1 in thread

How come it's not automatic and built-in? Why is a script terrible? (Does it have to enumerate all tables and piecewise run the stat update?)

ovi256OP7y ago

Yes, the stats update is per table. We only updated it for a few tables we really cared about.

j / k navigate · click thread line to collapse