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.

51 canonical articlesBrowse the complete archive

Popular Searches

Database Performance Articles

← Clear filter

Showing 3 of 51 articles

MySQL Error Log Table Explained: Using performance_schema for Error Analysis

MySQL 8.0 exposes error logs through performance_schema.error_log — enabling SQL-based filtering by severity, component, and timestamp without grep-ing log files.

MySQL7 minMar 28, 2022
Read

Monitoring MySQL Using ProxySQL: Query Stats, Connection Metrics, and Alerting

ProxySQL maintains a rich internal stats schema that most teams never fully explore. Here's how to use ProxySQL's built-in monitoring to track query latency, backend health, and connection pool utilization.

MySQL8 minJan 30, 2022
Read

PgPool-II for PostgreSQL: Installation, Configuration, and Connection Pooling

PgPool-II provides connection pooling, read/write splitting, and automatic failover for PostgreSQL — but its extensive configuration can be overwhelming. Here's a practical guide to getting PgPool-II running in production.

PostgreSQL15 minJan 20, 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