The JusDB Database Engineering Blog

Deep dives on PostgreSQL, MySQL, MongoDB and more — performance tuning, high availability, migrations and production war stories from our DBAs.

76 canonical articlesBrowse the complete archive

Popular Searches

Optimization Articles

← Clear filter

Showing 4 of 76 articles

MySQL Tablespace Encryption (TDE): Encrypting Data at Rest

MySQL InnoDB tablespace encryption (TDE) encrypts data pages on disk without changing application code — using a two-tier keyring architecture that separates the master key from table keys.

MySQL9 minMar 22, 2022
Read

Configuring Efficient MySQL Log Rotation with logrotate

MySQL generates multiple log files that will fill your disk if left unmanaged. Here's how to configure logrotate correctly for MySQL error logs, slow query logs, and binary logs.

MySQL7 minJan 30, 2022
Read

Battle of Memory Allocators: A Deep Dive

Discover how jemalloc, tcmalloc, and mimalloc can dramatically improve MySQL memory management. Real benchmarks showing 2-4x performance improvements and memory leak prevention.

10 minJan 18, 2022
Read

10 Powerful JSON Functions in MySQL 8 Every Developer Should Know

MySQL 8 dramatically improved JSON support with functions that eliminate the need for application-side parsing. Here are 10 JSON functions that will transform how you work with JSON columns in MySQL.

MySQL9 minJan 2, 2022
Read
Newsletter

Get the latest database insights and expert tips delivered to your inbox.

Stay Connected

Subscribe to our RSS feed for instant updates.

RSS Feed