Sql

Calculating the right number of Linux huge pages for PostgreSQL is trickier than just dividing shared_buffers by the page size. This walkthrough shows how to use tuned to manage allocation and why you need to round up based on actual memory usage.

A practical guide to managing PostgreSQL WAL retention using the pg_archivecleanup utility, covering dry-run and delete modes, retention criteria, and a code walkthrough for novice users.

A practical guide to using SQLline to replicate SQL client behavior when testing JDBC connectors. Covers downloading the tool, setting up the classpath, and connecting to an Azure MySQL instance.

A quick reference for running mysqlcheck to verify and optimize MySQL databases, including the -A flag to target every database on the server in one pass.

A quick way to inspect what SELECT and UPDATE privileges a MySQL user actually holds, straight from the mysql.user table. Useful when an application is throwing permission errors and you need to confirm what the account can and cannot do.

Learn how to extract dynamic symbols from the mysqld binary and use them to resolve a crash stack dump into readable function names.