Re:Move Fast and Migrate Things: How We Automated Migrations...
by tomnipotent on Thursday February 07, 2019 @01:23AM
(#19103426)
I can't tell you how many times over 20 years I've heard a DBA tell me "the statistics weren't updated" after an incident.
[ Parent
| on HN ]
Re:Move Fast and Migrate Things: How We Automated Migrations...
by ovi256 on Thursday February 07, 2019 @07:46AM
(#19104862)
I've written cron jobs to update mysql statistics to prevent it from choosing bad query plans. It's as terrible as it sounds.
Re:Move Fast and Migrate Things: How We Automated Migrations...
by pas on Thursday February 07, 2019 @09:04AM
(#19105261)
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?)