Comment 19 for bug 1607300

Revision history for this message
Ross E Carver (recarv) wrote :

Hi, I've been following this bug and have implemented several of the temporary fixes, including upgrading server (currently PS 5.7.16-10-log) which should include the fix.

I have a table with around 30m rows which are updated often - high turnover of about 50+ % of table rows based on updates (no deletes) on a weekly or bi-weekly basis. We have other tables with append-only style behavior totaling over 1b rows without problem.

This is a long bug list, so I'm hoping to get some new info requests for help to diagnose the problem before I try to alleviate the problem and destroy any possible evidence in so doing. I'd post as a new bug, but it does relate to this because the temporary fixes and behavior are the same.

Please let me know what you'd like for further evidence to investigate - I can sustain the degraded performance until 12/31 (thankfully due to holidays).