Baking · Events · Postmortem: how we exhausted the connection pool in baking-events

251
BAr/baking-events·posted by winter·just nowTutorial

Postmortem: how we exhausted the connection pool in baking-events

It took me two weeks of on-and-off digging and plenty of wrong turns. Writing the process down as it happened so the next person spends less time.

On trade-offs, my view is this: if nobody on the team owns this area long-term, do not introduce a second mechanism. With two coexistence you first have to work out which one is even in play when things break, and that costs far more than the performance you saved.

Documentation first44%
Source code first28%
Just ask someone17%
Run a demo and learn by error11%

427 votes total

27 comments

27 comments

M
WwinterOP·2 days ago

This matches what we see in production. We only hit it past 3k QPS; the earlier load tests showed nothing — the test traffic was too clean, with no long-tail requests.

442
Zzhu_zong·2 days ago

One counter-example: below baking-events 7.4 the semantics of that code are different, so do not copy it verbatim. We got burned in staging and rolled back once.

463
Kkernel_panic·yesterday

Thanks for sharing real numbers — far more useful than the articles that only cover concepts.

394
Kkite·2 days ago

Worth learning from this debugging approach. We went straight at the logs and took a much longer route.

198
Zzhu_zongMod·28 minutes ago

I see point 3 differently. The trade-off depends on your read/write ratio: read-heavy with little writing means caching actually widens the inconsistency window.

307
Zzhou_yiOP·2 days ago

Saved. I am reworking this area this week — this saves a lot of wrong turns.

186
Kkernel_panic·2 days agoedited

Agreeing with the above. One addition: with this option enabled the GC count in your metrics doubles, so adjust the alert threshold at the same time or it will keep firing.

203
Kkernel_panic·1 hour ago

We have run this in production for two years without hitting it. That said, we never reached this scale, so our experience is not really evidence here.

194
Kkernel_panic·3 minutes ago

Agreeing with the above. One addition: with this option enabled the GC count in your metrics doubles, so adjust the alert threshold at the same time or it will keep firing.

114
Oops_wangOP·12 minutes agoedited

There is actually a simpler fix that needs no architecture change: move this check up to the gateway and the problem disappears. The cost is one extra lookup at the gateway.

18
Ddev_zhou·28 minutes ago

I just read the baking-events source — the author actually explains the reasoning in a comment, roughly "so that it degrades into predictable behaviour in extreme cases".

334
Rran_bo·5 hours ago

I see point 3 differently. The trade-off depends on your read/write ratio: read-heavy with little writing means caching actually widens the inconsistency window.

1
Cchen_dev·28 minutes ago

Has anyone run a controlled experiment? I did, reducing it to a single variable, and the difference was 4% — within noise. So I suspect the main cause is something else.

46
Zzhu_zong·28 minutes ago

Can you give a minimal reproduction? I ran it locally for ten minutes and could not reproduce on macOS with the latest version.

51
Hhuang_keOP·5 hours ago

A question: what changes in a container with a 512Mi memory limit? That is how we run it in production.

259
Oops_wang·2 hours ago

One counter-example: below baking-events 7.4 the semantics of that code are different, so do not copy it verbatim. We got burned in staging and rolled back once.

146
Ddev_zhou·2 days ago

Can you give a minimal reproduction? I ran it locally for ten minutes and could not reproduce on macOS with the latest version.

4
Sslow_query·3 minutes agoedited

We have run this in production for two years without hitting it. That said, we never reached this scale, so our experience is not really evidence here.

30
Oops_wang·3 minutes ago

This matches what we see in production. We only hit it past 3k QPS; the earlier load tests showed nothing — the test traffic was too clean, with no long-tail requests.

159
Cchen_dev·2 days ago

This is not a baking-events problem, it is a usage problem. The docs say this API is not thread-safe and you must lock around it yourself.

62
Zzhou_yi·5 hours ago

This is not a baking-events problem, it is a usage problem. The docs say this API is not thread-safe and you must lock around it yourself.

8
Zzhou_yiOP·2 days ago

There is actually a simpler fix that needs no architecture change: move this check up to the gateway and the problem disappears. The cost is one extra lookup at the gateway.

1
Zzhou_yi·yesterdayedited

Worth learning from this debugging approach. We went straight at the logs and took a much longer route.

24
Llinlin·just nowedited

Sharing our numbers, 8 cores 16GB, same scenario:

| Concurrency | P50 | P99 |
|---|---|---|
| 200 | 12ms | 88ms |
| 500 | 31ms | 340ms |

P99 clearly collapses at 500 concurrency, which lines up with your knee point.

22
Zzhu_zong·2 days ago

I just read the baking-events source — the author actually explains the reasoning in a comment, roughly "so that it degrades into predictable behaviour in extreme cases".

19
Hhuang_ke·2 days ago

Has anyone run a controlled experiment? I did, reducing it to a single variable, and the difference was 4% — within noise. So I suspect the main cause is something else.

18
Wwinter·2 days ago

Sharing our numbers, 8 cores 16GB, same scenario:

| Concurrency | P50 | P99 |
|---|---|---|
| 200 | 12ms | 88ms |
| 500 | 31ms | 340ms |

P99 clearly collapses at 500 concurrency, which lines up with your knee point.

1

This is the post detail page /en/c/baking-events/post/p4. Posts and comments are generated deterministically from a seeded PRNG, so the same post always renders the same content and the link can be shared, reloaded and indexed. In production this page reads MySQL for the post, Redis for hot-post caching, and fetches the whole comment tree in a single query on the path column.

See the database schema →