performance – Page 45 – Türker Yıldırım

Redis 4.0 UNLINK frees in the background

NoteMarch 14, 20171 min read

Redis is single-threaded, so DEL on a structure with a million members blocks every other client for as long as freeing it takes — which is milliseconds for…

Rate limit a location in nginx

SnippetMarch 9, 20171 min read

Batching a WP-CLI loop so it does not exhaust memory

NoteFebruary 28, 20172 min read

A command iterating every post accumulates objects in the query cache and the object cache, so a loop that works over 10,000 rows fails over 200,000 — and…

webpack 3 scope hoisting, and what it actually saves

NoteFebruary 28, 20171 min read

webpack wraps every module in a function, which costs a closure per module at parse and at runtime. Scope hoisting concatenates modules that can safely share a scope…

Show the size of every Docker image layer

SnippetFebruary 16, 20171 min read

HTTP caching headers the application controls

NoteFebruary 14, 20171 min read

A reverse proxy or CDN caches what the response tells it to cache, which means the decision belongs in the application and usually is not made at all…

The asset pipeline Laravel 5.4 shipped

Deep diveJanuary 31, 20178 min read

Elixir wrapped gulp, which wrapped everything else. Mix wraps webpack directly — and leaves the configuration reachable when the abstraction runs out.

Prefix indexes on a long varchar

NoteJanuary 31, 20171 min read

Indexing a 255-character column costs 255 characters per row in the index, and for a lookup that is unique within the first dozen characters most of that is…

Show the InnoDB buffer pool hit rate

SnippetJanuary 25, 20171 min read

Replication lag is a symptom, not a metric

NoteJanuary 19, 20171 min read

Seconds_Behind_Master is the number everyone alerts on and it measures one thing: how far behind the applying thread is on the transaction it is currently executing. It reads…