DB writes, bottleneck during sync

[emhane]

Describe the feature

Canonicalization on FCU competes over rw access to db, with deleting entires on pruning. This leads to issues syncing.

Additional context

No response

Tasks

Preview Give feedback

1. Unable to sync base-mainnet with op-reth || op-node hangs whilst op-reth is 'pruning' #7500
   A-op-reth A-pruning C-bug S-stale +4
2. op-reth base sync stalling #7477
   A-op-reth A-pruning A-staged-sync C-bug +4
3. Buffer incoming engine messages if pruner is active #8203
   A-consensus C-bug C-enhancement +3
   
4. segment ring for fair + performant pruning on pruning interrupt #7343
   A-pruning C-perf M-prevent-stale S-blocked +4
5. Run prune hook only if there're segments to prune #7505
   A-pruning C-enhancement S-stale +3
6. feat(consensus): proceed with FCU on a running RW hook #6792
   A-consensus C-enhancement +2
7. Communicate to read-write engine hook that it needs to stop #6796
   A-consensus C-enhancement S-stale +3
8. Account and Storage History pruning should respect time limits #7435
   A-pruning C-enhancement +2
   
9. Pruner should have time-dependent deletion limits #6770
   A-pruning C-enhancement +2
   
10. sudden spike in pruning time #8957
    A-pruning C-bug +2

[github-actions]

This issue is stale because it has been open for 21 days with no activity.

[emhane]

is this issue irrelevant with new db design @Rjected @fgimenez ?

[fgimenez]

is this issue irrelevant with new db design @Rjected @fgimenez ?

yes, this should be fixed with the new design