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

pas7y ago

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

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.

pas7y ago

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