Database Administration
Add a Generated Column in MySQL
A generated column holds a value MySQL computes from the rest of the row, so it can never drift out of step. This tutorial…
//
Tag: Performance
Server Administration
Add a Swap File to a Small Server
Add a swap file to a small server and a memory spike stops killing your processes. fallocate reserves the file, mkswap formats it, swapon…
Programming
Capture Output With Output Buffering in PHP
ob_start catches everything a script prints, so a template that echoes becomes a function that returns. That one trick powers shortcodes and page caches,…
Programming
Read a Large File Line by Line With PHP Generators
A generator hands back one line at a time instead of building the whole array, which cut peak memory from 35.3 MB to 2.0…
Server Administration
Check Disk, Memory and CPU Usage From the Terminal
Diagnose a struggling Linux server in under a minute with df, du, free and top - which resource is short, and which directory or…
Database Administration
Search Text With a MySQL FULLTEXT Index
Replace a slow LIKE '%word%' with a FULLTEXT index: rank matches by relevance in natural-language mode, require or exclude terms in boolean mode, and…