Discover all the new features in MySQLTuner v2.9.3: deep InnoDB AHI & Performance Schema stage profiling, MySQL 8.4+/9.x TLS detection, origin-aware MariaDB deprecation checks, AI MCP skills, and MySQL 9.7 LTS / 26.7 & MariaDB 13.0 support.
Tag: Performance
MySQLTuner v2.9.2: Enhanced Galera Diagnostics, InnoDB Cluster Auditing, and Faster Execution
Discover the new features in MySQLTuner v2.9.2: advanced Galera (wsrep) diagnostics, hardware LSI MegaRAID detection fixes, –skipworkload parameter, and CVE database path fallbacks.
MySQLTuner v2.9.1: Introducing AI-Driven Database Audits and Deep Diagnostics
Discover the new features in MySQLTuner v2.9.1: AI-focused JSON output, Model Context Protocol (MCP) server, deep InnoDB and HA cluster diagnostics, SQL linter, and HA E2E test harness.
MySQLTuner v2.9.0: Introducing Interactive HTML Reports for Database Optimization
Discover the new Interactive HTML Reports in MySQLTuner v2.9.0! Learn about the self-contained dashboard, resource saturation heatmap, and visual performance indicators.
Hardening Database Audits: Security and Data Protection Improvements in MySQLTuner
Hardening database audits: learn how MySQLTuner-perl was secured against symlink attacks and credential exposure in log files in the latest v2.8.44 releases.
Modernizing Legacy Perl: How MySQLTuner Reached 92% Test Coverage and Zero-Dependency Autonomy
How do you modernize legacy Perl? Take a look behind the scenes at how the MySQLTuner team achieved a massive leap from 55% to 92% test coverage without using external mocking libraries.
What’s New in MySQLTuner v2.8.44: A Deep Dive into the Latest 3 Months of Performance Tuning Evolution
Discover the latest features in MySQLTuner v2.8.44! Learn about the new zero-dependency HTML reports, advanced SQL dump compression, and core-aware cache optimization recommendations.
Mastering Readline Shortcuts under Linux: Boost Your Command-Line Productivity
Master GNU Readline keyboard shortcuts to double your command-line efficiency and speed up your terminal navigation.
Live Migration with pgcopydb: Zero Downtime Thanks to Follow Mode
Learn how to use pgcopydb’s –follow option and logical replication slots to achieve near-zero downtime live migrations of PostgreSQL databases.
Technical Architecture and Parallelization in pgcopydb
A deep dive into pgcopydb’s multi-process architecture, table chunking features, and parallel index rebuilding capabilities for faster migrations.