Blog

Guides from the NOC

Written from running the hardware — what breaks, why, and the command that fixes it.

3 posts matching “database-performance” · Clear

All 3 Most read WordPress 1 VPS 1 Troubleshooting 1
WordPress WordPress wp_options Bloat: Find and Fix Autoload Data

A bloated wp_options table with too much autoloaded data slows every WordPress page load. Here's how to find the worst offenders and clean it up safely.

22 August 2026 · 5 min · 7 views VPS MySQL/MariaDB Tuning on a VPS: my.cnf Settings That Matter

Slow WordPress or app on your VPS even with low CPU? Tune innodb_buffer_pool_size, max_connections, and tmp_table_size in my.cnf the right way.

28 July 2026 · 6 min · 9 views Troubleshooting MySQL Slow Query Log: Find and Fix Queries Slowing Your Site

Site feels sluggish but CPU looks fine? Learn how to enable the MySQL slow query log, read it with mysqldumpslow, and fix the queries actually slowing you down.

16 July 2026 · 6 min · 20 views