github major/MySQLTuner-perl v2.8.44

4 hours ago

Release Notes - v2.8.44

Date: 2026-05-27

📝 Executive Summary

2.8.44 2026-05-27

- chore: implement compliance check script to enforce zero-dependency and single-file design.
- chore: implement post-checkout Git hook to automatically verify version consistency on checkout.
- feat: develop automated end-of-life (EOL) date synchronization check script to audit LTS versions in CI.
- feat: develop automated specification consistency auditor and Spec-to-Test Mapping Matrix.
- feat: develop LTS API auto-bumping utility with GitHub Actions integration.
- feat: develop version bump dry-run simulation script and post-commit Git hook for automated doc sync.
- feat: re-implement HTML report option (--reportfile) removing CPAN Text::Template dependency (#791).
- feat: make unit-tests target quiet/clean by default in Makefile, and add unit-tests-debug target for verbose debugging.
- fix: resolve false positive AUTO_INCREMENT near max capacity warning on BIGINT UNSIGNED columns with low row count by checking type-specific limits using information_schema (#913).
- fix: refactor version parsing regexes in mysql_version_eq() and helper functions to prevent uninitialized value warnings.
- fix: resolve compile-time and runtime warnings in unit tests, mock override ordering, and definedness checks.
- fix: fix $fh scoping bug in process_sysbench_metrics where file handle was declared inside if(!open) guard and went out of scope before read loop.
- fix: fix $fh scoping bug in historical_comparison (same pattern as process_sysbench_metrics).
- fix: fix hash initialization bug in merge_hash (my %result = {} changed to my %result = ()).
- test: add unit test for type-specific auto_increment capacity warnings.
- test: update issue_37.t to support new information_schema query format.
- test: add unit test for HTML report generation logic.
- test: expand unit tests with parameterized test matrix covering supported/outdated versions across major versions 5, 8, 9, 10, and 11.
- test: add unit_system.t to verify architecture, transport, and formatting helpers, increasing test coverage to 61%.
- test: add unit_coverage_boost.t covering 12 pure utility functions (trim, escape_html, hr_bytes, merge_hash, etc.).
- test: add unit_coverage_boost2.t covering 17 I/O, MariaDB engine, and print wrapper functions (redwrap, file2array, mariadb_tokudb, etc.).
- test: add unit_coverage_boost3.t with deep-mocked tests for 22 diagnostic subroutines (mysql_plugins, mysql_indexes, system_recommendations, check_query_anti_patterns, process_sysbench_metrics, etc.).
- test: improve subroutine coverage from 55% to 92% (154 out of 167 subroutines).
- ci: configure CI workflows to trigger on all branches and execute compliance checks.
- ci: add EOL date check step to CI workflow.
- docs: enhance release-manager workflow with branch lifecycle and checkout hook instructions.
- docs: add Docker installation instructions (docker pull/run) and release location to all README files (EN, FR, IT, RU).

📈 Diagnostic Growth Indicators

Metric Current Progress Status
Total Indicators 15 0 🛡️
Efficiency Checks 0 0 🛡️
Risk Detections 2 0 🛡️
Information Points 13 0 🛡️

🛠️ Internal Commit History

  • docs: add Docker install instructions and releases location in all READMEs (e1b77ed)
  • docs: regenerate release notes (849e4d2)
  • feat(test): clean unit tests output and fix mock compilation warnings (35ecd52)
  • chore(ci): ignore execution.log in gitignore (a9ca211)
  • docs: regenerate release notes (acd852c)
  • fix(cli): resolve false positive AUTO_INCREMENT near max capacity warning (#913) (39d96eb)
  • chore(ci): update execution log with generate_usage outputs (1c60bff)
  • feat(ci): implement version dry-run validation, update LTS support tests, and update execution log (a78c747)
  • feat(ci): implement EOL sync, version dry-run validation, and git hooks (b59a2f7)
  • docs: generate USAGE.md (225e3e4)
  • feat(versions): update validate_mysql_version with 9.6 support and remove 9.5 (d2ca4d6)
  • feat(report): re-implement HTML report and cleanup templates (d3b6d3c)

⚙️ Technical Evolutions

➕ CLI Options Added

  • --compress-dump
  • --dump-limit

➖ CLI Options Deprecated

  • --data
  • --template

✅ Laboratory Verification Results

  • Automated TDD suite passed.
  • Multi-DB version laboratory execution validated.
  • Performance indicator delta analysis completed.

Deliverables

Standalone Script & Data

Asset Checksum
mysqltuner.pl [sha256]
basic_passwords.txt [sha256]
vulnerabilities.csv [sha256]

Docker Images

docker pull jmrenouard/mysqltuner:2.8.44
docker pull jmrenouard/mysqltuner:latest

Checksums (.sha256) are available in the assets list below.

Don't miss a new MySQLTuner-perl release

NewReleases is sending notifications on new releases.