Skip to content

v2.9.1

Latest
Latest

Choose a tag to compare

View all tags
@jmrenouard jmrenouard released this 29 Jul 08:24
v2.9.1
2b79f19

Release Notes - v2.9.1

Date: 2026-07-27

📝 Executive Summary

2.9.1 2026-07-27

- chore: automated project metadata update
- chore: remove execution.log from git repository and sync docs
- feat: recommend slow query log when disabled (#517)
- fix: update documentation and code
- ci: optimize pre-commit hook to only run unit tests when code, tests, or dependencies are modified
- chore(build): allow build scope in compliance auditor
- chore(build): rewrite dev_sync and doc_sync in Perl for consistency
- chore(deps): update actions/checkout action to v7.0.0 (#961)
- chore(deps): update all non-major dependencies (@commitlint/cli, @commitlint/config-conventional, brace-expansion, commitizen)
- chore(deps): update devops-infra/action-commit-push digest to f27e0951b748268e6ac8d91861eeac5bc2bd36a8 (#958)
- chore(deps): update devops-infra/action-commit-push digest to fa0c793 (#929)
- chore(deps): update docker/build-push-action digest to 53b7df9 (#939)
- chore(deps): update docker/login-action digest to abd2ef4 (#962)
- chore(deps): update docker/login-action digest to af1e73f (#940)
- chore(deps): update docker/setup-buildx-action digest to bb05f3f5519dd87d3ba754cc423b652a5edd6d2c (#959)
- chore(deps): update github/codeql-action digest to 99df26d4f13ea111d4ec1a7dddef6063f76b97e9
- chore(deps): update shogo82148/actions-setup-mysql digest to 076e636 (#930)
- chore(deps): update softprops/action-gh-release digest to 718ea10 (#934)
- chore(deps): update ubuntu:latest docker digest to 53958ec (#935)
- chore(deps): update ubuntu:latest docker digest to b7f48194d4d8b763a478a621cdc81c27be222ba2206ca3ca6bc42b49685f3d9e
- chore(docs): add custom rule for GitHub issue creation
- chore(docs): implement rule to decompose unit tests into readable segments
- chore(docs): update agent best practices and customization rules
- chore(main): add doc links in localhost warnings and support custom local subdomains
- chore(main): hide hostname, ssl, and replication warnings on localhost (#933)
- chore(releases): start v2.9.1 branch with version bump and dependency updates
- feat(cli): implement agent-json flag returning structured actionable schema (#955, jmrenouard#63)
- feat(cli): resolve remote memory, socket override, and temptable sizing issues (#923)
- feat(container): implement dockerized auditing daemon and zero-dependency MCP server (#954, jmrenouard#62)
- feat(main): audit InnoDB lock monitors and print all deadlocks configuration
- feat(main): enhance error log parser with OOM, semaphore waits, file limits, and page corruption alerts (#953)
- feat(main): implement advanced log parser and lock monitoring (#953, jmrenouard#61)
- feat(main): implement experimental Correlation Engine linking PFS wait events and CPU load with log events
- feat(metadata): fix test badge and update version references in READMEs
- feat(report): add pgBadger-inspired query, lock, and temp table visual analytics to HTML report (#791)
- feat(report): add verbose timings, step percentages, and snapshot summary
- feat(report): finalize HTML report, YAML output, and historical comparison
- feat(report): implement HA InnoDB Cluster diagnostics and Group Replication checks
- feat(report): implement advanced Galera Cluster 4 and PXC 8.0 diagnostics
- feat(report): implement phase 6 deep engine tuning and mark phase 8 completed
- feat(report): implement workload traffic profiling and query waits analysis (#960)
- fix(container): create default /defaults.cnf in Dockerfile and document volume mounts (#932)
- fix(main): add undefined/NULL guards to hr_num to resolve uninitialized warnings (#904)
- fix(main): address PR #931 code review feedback and enhance test validations
- fix(main): calculate query cache efficiency using Com_select on MariaDB (MDEV-4981) (#927)
- fix(main): exclude MariaDB user roles and support zero-config TLS (#936, #937)
- fix(main): only recommend increasing innodb_log_buffer_size when log waits occur (#938)
- fix(main): query events_errors_summary_global_by_error safely (#956, jmrenouard#64)
- fix(main): resolve uninitialized warnings in auto-increment audit and fix split delimiters (#913)
- fix(main): support '0' and 'OFF' value representations when checking slow query log status (#517) (finalized implementation)
- test(hook): verify pre-commit hook runs tests when test files change
- test(lab): add HA topology E2E tests, MCP server E2E test, and dedicated output analyzer
- test(lab): add HA validation profiles (galera.json, innodb_cluster.json, replication.json)
- test(lab): add build/analyze_mt_output.pl dedicated output analyzer with HA profile support
- test(lab): add build/test_ha.sh E2E orchestrator for Galera, InnoDB Cluster, and Replication topologies
- test(lab): add e2e_mcp_server.t for MCP server E2E validation with live MariaDB container
- test(lab): add unit test test_issue_810.t for issue 810 (#810)
- test(lab): expand unit tests for issue #517 to verify alternative representations of slow query log active state (#517)
- test(test): add unit tests for issues #553, #605, #671, #770, #774, #777, #781, #782, #783, #796 (#553, #605, #671, #770, #774, #777, #781, #782, #783, #796)
- test(test): add unit tests for issues #863, #864, #869, #874, #875, #881, #887 (#863, #864, #869, #874, #875, #881, #887)
- test(test): add unit tests for issues #896, #900, #904, #913, #923, #927, #932, #938 (#896, #900, #904, #913, #923, #927, #932, #938)
- test(test): add unit tests for potential issues and split unit_coverage_boost3
- test(test): add unit_agent_json.t to validate actionable JSON schema (#955)
- test(test): add unit_deadlocks_pfs.t to validate InnoDB deadlock PFS checks
- test(test): add unit_eol_warnings.t to validate version support warnings
- test(test): add unit_galera_pxc.t to validate Phase 9 Galera cluster checks
- test(test): add unit_ha_cluster.t to validate Phase 7 HA cluster checks
- test(test): add unit_log_parser.t to validate advanced log parsing and correlation (#953)
- test(test): add unit_mcp_server.t to validate JSON-RPC protocol compliance (#954)
- test(test): add unit_replication_internals.t to validate Phase 8 replication features
- test(test): add unit_version_helpers.t to validate version caching and helpers
- test(test): add unit_workload_traffic.t to validate Phase 11 workload profiling (#960)
- test(test): split unit_coverage_boost3.t into three smaller test files
- test(test): update workload traffic and HA cluster unit tests to use tab-delimited mock data
- test(test): verify replication terminology and checksums in unit tests (#888)
- ci(build): implement static SQL linter and fix PFS deadlock error query
- docs(metadata): promote HTML reports and add E2E examples
- docs(metadata): remove timestamp from doc-sync generated files
- docs(releases): regenerate release notes and changelog
- docs(roadmap): add Phase 22 for High Availability & Replication Auto-Discovery
- docs(roadmap): add Phase 24 (Boolean Normalization), Phase 25 (Deprecated Variables), Phase 26 (Subtest Decomposition) to ROADMAP.md
- docs(roadmap): add Phase 27 (Multi-Language Normalization), Phase 28 (CI Version Matrix), Phase 29 (Publish Pipeline), Phase 30 (Build Stack Rationalization) from transversal audit
- docs(roadmap): group strategic technical evolutions into phases 18 to 21
- docs(roadmap): link strategic technical evolutions specification and enforce changelog staging
- docs(roadmap): mark Phase 12 as completed in ROADMAP.md
- docs(roadmap): mark Phase 16 and 17 as completed in ROADMAP.md
- docs(roadmap): update Phase 7, Phase 9, Phase 10, and Phase 11 status to completed in ROADMAP.md
- docs: add AGENT.md integration guide for AI and MCP server
- docs: add LightPath as sponsor, relocate coffee button, and use star-history chart
- docs: add MCP and AI integration guide for MySQL database tuning
- docs: generate FEATURES.md
- docs: generate end-of-life status files
- docs: link recent features to GitHub issues in Changelog
- docs: link recent features to jmrenouard fork issues in Changelog
- docs: regenerate release notes
- docs: update potential issues log with Phase 9 Galera audit findings
- docs: update potential issues log with Renovate dependency dashboard analysis
- docs: update potential issues log with release v2.9.0 and v2.9.1 audit results
- docs: update repository links to major/MySQLTuner-perl and add GitHub stars badge
- style: tidy mysqltuner.pl

📈 Diagnostic Growth Indicators

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

🛠️ Internal Commit History

  • docs(releases): add GitHub issue references to Changelog and Release Notes (e464db9)
  • Merge branch 'major/master' into v2.9.1 to resolve GitHub Action workflow conflicts (1f12622)
  • chore: automated project metadata update (4df668a)
  • chore(deps): update docker/login-action digest to abd2ef4 (#962) (e1da863)
  • docs: regenerate release notes (98564e4)
  • style: tidy mysqltuner.pl (01bb574)
  • chore(deps): update actions/checkout digest to d23441a (#961) (2a7fbcb)
  • docs: regenerate release notes (e45de80)
  • docs: regenerate release notes (d6d0b3e)
  • style: tidy mysqltuner.pl (b493719)
  • ci(build): implement static SQL linter and fix PFS deadlock error query (48e0472)
  • docs: regenerate release notes (317883d)
  • docs: regenerate release notes (6551702)
  • chore(deps): update docker/setup-buildx-action digest to bb05f3f (#959) (fa2ab7d)
  • chore: automated project metadata update (504dce8)
  • chore(deps): update devops-infra/action-commit-push digest to f27e095 (#958) (d943b35)
  • docs: regenerate release notes (fe66f7f)
  • fix(main): resolve uninitialized warnings in auto-increment audit and fix split delimiters (049b59a)
  • docs: regenerate release notes (5340c55)
  • fix(main): support '0' and 'OFF' value representations when checking slow query log status (#517) (b9f4083)
  • docs: regenerate release notes (bb4ae91)
  • test(lab): add HA topology E2E tests, MCP server E2E test, and dedicated output analyzer (2999bad)
  • test(test): verify replication terminology and checksums in unit tests (#888) (18d1da0)
  • docs: regenerate release notes (07193c5)
  • fix(main): query events_errors_summary_global_by_error safely (#956, jmrenouard#64) (28b50b3)
  • docs: regenerate release notes (0a06930)
  • docs: regenerate release notes (08fa6a8)
  • docs: regenerate release notes (938b2ed)
  • docs(roadmap): add Phase 22 for High Availability & Replication Auto-Discovery (372751e)
  • docs: regenerate release notes (682abca)
  • docs: regenerate release notes (3f41b8a)
  • docs: regenerate release notes (11895cb)
  • docs: link recent features to jmrenouard fork issues in Changelog (f2bacfd)
  • docs: regenerate release notes (adee75b)
  • docs: regenerate release notes (f20c04e)
  • docs: regenerate release notes (cf6f35a)
  • docs: link recent features to GitHub issues in Changelog (bffa416)
  • docs: regenerate release notes (8420a45)
  • docs: regenerate release notes (1741b75)
  • docs: regenerate release notes (688261e)
  • docs: add MCP and AI integration guide for MySQL database tuning (b30eefe)
  • docs: generate end-of-life status files (19d60a7)
  • docs: generate FEATURES.md (e14b427)
  • docs: regenerate release notes (f121ab1)
  • docs: regenerate release notes (dcc1d0b)
  • docs: add AGENT.md integration guide for AI and MCP server (a24b5da)
  • docs: regenerate release notes (a0338fb)
  • docs: regenerate release notes (67ed38c)
  • docs(roadmap): group strategic technical evolutions into phases 18 to 21 (de35c9c)
  • docs: regenerate release notes (31ec11c)
  • docs: regenerate release notes (1156c3b)
  • docs(roadmap): mark Phase 16 and 17 as completed in ROADMAP.md (5d5831f)
  • docs: regenerate release notes (2c961ba)
  • feat(cli): implement agent-json flag returning structured actionable schema (d71fdbc)
  • docs: regenerate release notes (81ae23a)
  • docs: regenerate release notes (7846c46)
  • docs: regenerate release notes (89004df)
  • feat(container): implement dockerized auditing daemon and zero-dependency MCP server (975977c)
  • docs: regenerate release notes for v2.9.1 (c0f4161)
  • docs(roadmap): mark Phase 12 as completed in ROADMAP.md (dd288c2)
  • docs: regenerate release notes (56d1eee)
  • docs: regenerate release notes (3978e7a)
  • docs: regenerate release notes (50f7224)
  • docs: regenerate release notes (e1cc6b4)
  • feat(main): implement advanced log parser and lock monitoring (23e42e6)
  • chore(docs): add custom rule for GitHub issue creation (e3250c7)
  • docs: regenerate release notes (0af805a)
  • docs: regenerate release notes (7854d3b)
  • docs: regenerate release notes (2896bbd)
  • test(test): add unit tests for potential issues and split unit_coverage_boost3 (c328efd)
  • docs: regenerate release notes (c5fdc7d)
  • docs: regenerate release notes (0ec038f)
  • docs: update potential issues log with Renovate dependency dashboard analysis (0842ba6)
  • docs: regenerate release notes (d5046d4)
  • docs: regenerate release notes (c2ec01e)
  • feat(report): implement workload traffic profiling and query waits analysis (89fa655)
  • docs: regenerate release notes (a3b5ef6)
  • docs: regenerate release notes (5fe8d27)
  • docs: update potential issues log with Phase 9 Galera audit findings (af711cc)
  • docs: regenerate release notes (5d424b7)
  • docs: regenerate release notes (372d930)
  • docs: regenerate release notes (4fd59e8)
  • feat(report): implement advanced Galera Cluster 4 and PXC 8.0 diagnostics (316ace4)
  • docs: regenerate release notes (503f1ca)
  • docs: regenerate release notes (0c1fa81)
  • feat(report): implement HA InnoDB Cluster diagnostics and Group Replication checks (8e9bdd6)
  • docs: regenerate release notes (3e7ea60)
  • docs: regenerate release notes (6b240ce)
  • chore(docs): update potential issues log with release v2.9.0 and v2.9.1 audit results (590e838)
  • docs: regenerate release notes (26a7c12)
  • docs: regenerate release notes (833f0ab)
  • chore(docs): implement rule to decompose unit tests into readable segments (d922e52)
  • chore(docs): update agent best practices and customization rules (63d4513)
  • docs: regenerate release notes (45e740f)
  • docs: regenerate release notes (7f2e769)
  • test(test): add unit_replication_internals.t to validate Phase 8 replication features (55953ec)
  • docs: regenerate release notes (67d9c47)
  • docs: regenerate release notes (da85245)
  • feat(report): implement phase 6 deep engine tuning and mark phase 8 completed (728dd29)
  • docs: regenerate release notes (aab8b0a)
  • docs: regenerate release notes (62ce873)
  • docs: regenerate release notes (3bd8c15)
  • chore(releases): start v2.9.1 branch with version bump and dependency updates (6d1e6a2)
  • chore(deps): update docker/login-action digest to af1e73f (#940) (618b6dd)
  • chore(deps): update docker/build-push-action digest to 53b7df9 (#939) (3b680e7)

⚙️ Technical Evolutions

➕ CLI Options Added

  • --action
  • --agent-json
  • --description
  • --expected_outcome
  • --findings
  • --id
  • --impact_score
  • --requires_restart
  • --risk_description
  • --risk_level
  • --rollback_statement
  • --stage-timings
  • --statement
  • --topic
  • --type
  • --yaml

✅ 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.9.1
docker pull jmrenouard/mysqltuner:latest

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

Assets 8
Loading