php – Page 23 – Türker Yıldırım

The queue table that became a bottleneck at four million rows

Deep diveJune 3, 202210 min read

A database-backed queue that worked for four years. SELECT FOR UPDATE SKIP LOCKED, and a lock wait timeout.

The report that ran on a replica and was three minutes stale

Deep diveMay 31, 202210 min read

Read routing added for capacity, and a report that disagreed with the dashboard. Two numbers, both correct, three minutes apart.

Style variations, and the theme that ships four designs

Deep diveMay 18, 202210 min read

6.0 in May, and styles/ as a directory of theme.json fragments. Four client sites that differ only in colour and type.

An SLO that survived contact with the business

Deep diveMay 17, 202214 min read

99.9% was written in a document in 2020 and had never been measured. Three teams with three definitions of “up”.

PHPStan level 9 is about mixed, and it is a project

NoteMay 10, 20222 min read

Level 9 requires every mixed to be narrowed before use, which is a different order of work from level 8. Every boundary that decodes JSON, reads a configuration…

Reading a container’s real CPU quota before sizing a pool

NoteMay 8, 20222 min read

nproc reports the host’s cores, so a worker pool sized from it starts thirty-two processes in a container entitled to two. The arithmetic is integer division, so a…

hash_equals for anything that arrived in a request

NoteApril 28, 20222 min read

String comparison short-circuits on the first differing byte, which leaks how much of a secret an attacker has guessed. The argument order is the detail that is almost…

Sharded pub/sub, and the cluster that could not broadcast

Deep diveApril 25, 20229 min read

A broadcast that goes to every node on every publish. Classic pub/sub does not scale in a cluster, and 7.0 gives channels that respect slots.

Ubuntu 22.04 and the OpenSSL 3 that broke your extension

NoteApril 20, 20222 min read

22.04 in April ships OpenSSL 3, and a PHP extension compiled against 1.1 does not load against it. The extension case is a rebuild and is straightforward once…

Redis functions replace the Lua scripts nobody could version

Deep diveApril 12, 202210 min read

7.0 in April, and a script registry that survives a restart. EVAL with a SHA nobody can map back to source.