- Issue created by @ajay547
- 🇦🇺Australia larowlan 🇦🇺🏝.au GMT+10
How many paragraphs are you saving at the same time?
- 🇮🇳India madhavibhatt
Hello,
aws cpu writer instance facing cpu spike upto 90%
and this spike observed in business off hours like random spike(mostly on Sunday) only where no one did any changes from drupal cms site
and same configuration set for lower environment also but on lower environment never observe spike,
Try to reproduce on lower env - created page with so many nested paragraph, taxonomy and entity reference revision content type
but no spikeearlier we are getting everyday spike on creating basic page - 90 to 95 % cpu usage
and we find this - Entity queries querying the latest revision very slow with lots of revisions 🐛 Entity queries querying the latest revision very slow with lots of revisions Needs work | https://www.drupal.org/project/drupal/issues/2950869 🐛 Entity queries querying the latest revision very slow with lots of revisions Needs work
and apply this patch - Query optimizations for latest revision queries for revisionable - https://www.drupal.org/files/issues/2022-07-07/2950869-134.patch → - so daily spike is fixed (with approx 5 to 8 paragraph adding while creating basic page)