Skip to content

v2.9.4

Latest

Choose a tag to compare

@jmrenouard jmrenouard released this 16 Nov 22:23
· 2 commits to master since this release
dd09776

Release Notes - v2.9.4

Date: 2026-11-16

📝 Executive Summary

2.9.4 2026-11-16

- chore(ai): adapt AI governance rules and add skills for isolated testing and Windows telemetry (#1010)
- chore(build): add automated GitHub issue creation orchestrator for audit remediation (#1022)
- chore(build): rationalize release and features generators with deterministic data structures (#1040)
- chore(compliance): whitelist JSON::PP in compliance sentinel (#1046)
- chore(release): execute v2.9.4 release verification, Changelog synchronization, and governance delivery (#1043)
- feat(cli): expose native --list-indicators JSON export contract and refactor generators (#1046)
- feat(engine): wire diagnostic auditors for PFS stages, AHI, TLS ciphers, and table cache (#1038)
- fix(build): accept Audit Snapshot Summary alongside General Statistics in analyze_mt_output.pl (#78)
- fix(build): correct increment_major_version target variables in Makefile (#1040)
- fix(build): harden parallel_test.sh image mapping, internal injection, JSON/HTML export, and test_envs.sh compose detection (#78)
- fix(build): normalize release_gen.pl diagnostic extraction and wrap indicators in inline code (#78)
- fix(build): support isolated env path overrides in audit_specifications.pl and check_doc_links.pl (#1044)
- fix(cli): exclude read-only, dot keys, and static variables from dynamic SET GLOBAL (#1027)
- fix(cli): format SET GLOBAL SQL values, honor --agent-json --outputfile, and validate --feature against allowed subroutines (#78)
- fix(cli): migrate JSON serialization and comparison to Core JSON::PP and propagate dump_result exit code (#78)
- fix(cli): preserve nocolor on outputfile and verify downloaded file size in update (#1035)
- fix(cli): prevent duplicate LIMIT clause in select_csv_file (#1036)
- fix(compliance): remove non-core JSON from check_compliance.pl allowed modules and report numeric warnings in audit_tests.pl (#78)
- fix(container): detect cgroup v2/v1 memory limits, support MYSQLTUNER_PROC_MEMINFO override, suppress host tool/lsblk/fs noise, and wrap PFS/container log streams (#78)
- fix(engine): add authoritative is_mariadb version gating for MySQL 26.10 and MariaDB 10.x-13.0+ (#78)
- fix(engine): compute InnoDB buffer pool page memory using innodb_page_size (#1026)
- fix(engine): eliminate duplicate foreign key mismatch query in table structures (#1037)
- fix(engine): filter SQL modeling column and FK checks to BASE TABLE, escape LIKE _id, deduplicate composite PK counts, and ensure CSV trailing newline (#78)
- fix(engine): fix PFS error_log severity/order query, anti-pattern check, historical comparison keys, and --dumpdir column scan guards (#78)
- fix(engine): preload virtual column tables and deduplicate engine queries (#1029)
- fix(engine): remove silent mutation SET GLOBAL innodb_stats_on_metadata in check_metadata_perf (#1022)
- fix(engine): replace exit(256) with exit(1) on fatal database connection failure (#78)
- fix(engine): resolve false positive for BIGINT UNSIGNED AUTO_INCREMENT primary keys (#1007)
- fix(engine): use object_name in PFS index wait query and fix bitwise operator in stats (#1034)
- fix(galera): read Galera status from mystat, fix wsrep context, and resolve index type (#1033)
- fix(innodb): cache Performance Schema and GCache memory query results (#1030)
- fix(mcp): fail closed on DB query failure, honor target_ram_percentage, lock/atomically write caches, and tighten SQL sanitization (#78)
- fix(replication): handle NULL replica lag and stopped threads cleanly and parse tab-separated SHOW REPLICA HOSTS (#78)
- fix(report): validate staged update_tuner_version downloads with perl -c, escape HTML script blocks and CSV quotes, and isolate mysqldump and fragmented_tables exports (#78)
- fix(security): escape shell and SQL metacharacters in select_one and credential options (#1023)
- fix(security): escape SSH/container/defaults arguments, enable standalone --ssh-host, use SSHPASS env for sshpass, skip remote local file checks, preserve debian.cnf precedence, and escape SQL string literals (#78)
- fix(security): remediate Dependabot vulnerabilities in fast-uri, brace-expansion, and js-yaml (#1016)
- fix(system): correct fs.nr_open sysctl recommendation, sunrpc threshold, and mountpoint (#1032)
- fix(system): gate local FS/OS/kernel probes under active transport, anchor mountpoint filters, guard zero-size disks and non-numeric sysctls, close correct handle, and use logical_cpu_cores fallback (#78)
- fix(system): guard getpwuid call on Windows platforms in setup_environment (#1028)
- fix(system): modernize Windows metrics discovery using PowerShell CIM with WMIC fallback (#992)
- fix(system): respect --noprocess flag and exclude mariadbd and garbd in process memory (#1024)
- fix(system): return command output from infocmd_tab and deduplicate SHOW queries (#1031)
- fix(system): scale Windows FreeVirtualMemory to bytes and handle zero swap safely (#1025)
- fix(test): resolve chroot test failures and prevent tree mutation during test execution (#1010)
- fix(triage): support configurable state_file and tests_dir paths across issue triage orchestrator and validators (#78)
- fix(versions): synchronize MySQL 26.10 short-term release cycle with endoflife.date (#75)
- test(build): add automated test suites for audit remediation validation (#1022)
- test(build): add release note diagnostic sanitization, shallow-clone resilience, and Changelog parity assertions to unit_release_gen.t (#78)
- test(build): add unit_lab_harness.t validating parallel_test.sh and test_envs.sh (#78)
- test(ci): integrate hermetic adversarial stress test suites for doc-lint and release governance (#1044) (#1045)
- test(ci): isolate Dockerfile ENTRYPOINT check from CMD and add npm security overrides unit test (#75)
- test(cli): add pod_cli_sync.t validating POD options and CLI metadata parity (#1039)
- test(cli): add test_list_indicators.t validating indicator export contract (#1046)
- test(cli): add unit_m4_autofix_agent_json.t for auto-fix comments and agent JSON (#1027)
- test(docs): add automated verification test for multi-language README translation parity (#1045)
- test(engine): add unit_m1_index_stats_csv.t for PFS index queries and CSV LIMIT deduplication (#1034)
- test(engine): add unit_m3_query_dedup_caching.t for query deduplication and diagnostic caching (#1029)
- test(engine): add unit_m4_connected_auditors.t for diagnostic auditor execution (#1038)
- test(engine): add unit_ponytail_audit_fixes.t and update JSON, SSH transport, and regression mock assertions (#78)
- test(engine): add unit_report_accuracy_fixes.t and update SQL modeling assertions (#78)
- test(galera): add unit_m3_galera_indexes_fk.t for Galera status and index metadata (#1033)
- test(innodb): add unit_m3_innodb_buffer_pool.t for InnoDB buffer pool sizing calculations (#1026)
- test(mcp): add unit_mcp_ponytail_fixes.py and mock-CLI failure subtests in unit_skill_buffer_pool.t (#78)
- test(security): add unit_m1_sql_security.t for SQL mutation removal and shell escaping (#1022)
- test(system): add unit_m2_env_windows_update.t for Windows getpwuid safety and updater verification (#1028)
- test(system): add unit_m2_process_swap.t for process memory and Windows swap telemetry (#1024)
- test(system): add unit_m2_system_kernel_fs.t for command deduplication, sysctl, and filesystem metrics (#1031)
- test(triage): isolate Python triage tests with TemporaryDirectory and verify SHA-256 invariance in stress_ci_doc_lint_adversarial.t (#78)
- ci(build): add doc-lint job to PR workflow for POD/CLI parity and invariants (#1044)
- ci(lab): source default configs in build/test_envs.sh from build/get_supported_envs.pl (#78)
- ci(release): synchronize release and Docker workflows, Dockerfile layers, VERSION file, and CVE list from master (#75)
- docs(build): extend documentation link auditor with multi-artifact version invariants (#1042)
- docs(ci): add YAML frontmatter to specifications and align QA traceability matrix (#1042)
- docs(cli): eliminate phantom CLI options in POD and USAGE.md and document missing options (#1039)
- docs(docs): add GitHub release and Docker image badges across multilingual READMEs (#75)
- docs(docs): automate multi-language README translation synchronization and verification (#1045)
- docs(docs): synchronize multi-language READMEs, version badges, and full skills catalog (#1042)
- docs(docs): synchronize Vietnamese README translation badges and links for v2.9.4 (#78)
- docs(mcp): assign explicit Mermaid subgraph IDs and deduplicate AI agent architecture guides (#1041)
- docs(rules): resolve license conflict to GPLv3 and clean external prompt boilerplate (#1041)
- docs(system): correct kernel sysctl and Galera parameter typos and document v2.9.4 audit subroutines (#1041)

📈 Diagnostic Growth Indicators

Metric Current Progress Status
Total Indicators 1125 +33 🚀
Efficiency Checks 165 +4 🚀
Risk Detections 322 +10 🚀
Information Points 582 +10 🚀
Recommendations 56 +9 🚀

🧪 New Diagnostic Capabilities

🛑 New Risk Detections

  • Initial TCP slot entries is < 100, please consider having a value greater than 100
  • JSON::PP module required for comparison analysis.
  • Replication lag analysis: IO thread is stopped or unhealthy ($replica_io_running). Check network or source availability.
  • Replication lag analysis: Replication lag is NULL/unknown. Check replica thread status.
  • Replication lag analysis: SQL thread is stopped or unhealthy ($replica_sql_running). Check replication errors.
  • This replication replica has unknown lag ($seconds_behind_replica).
  • Unknown or disallowed feature: $feature

✅ New Efficiency Metrics

  • Log from cloud $myvar{'log_error'} exists
  • Log journal $myvar{'log_error'} exists

ℹ️ New Information Points

  • Skipping host network, process, filesystem, and kernel probes in container mode.

🛠️ Internal Commit History

  • fix(container): isolate os_setup /proc/meminfo in tests via MYSQLTUNER_PROC_MEMINFO (bf281f8)
  • docs: regenerate release notes (1e4b6af)
  • test(build): fix unit_release_gen.t false positive in shallow CI clones (3f94edb)
  • docs(docs): merge upstream Vietnamese README and sync v2.9.4 badges (2f0385e)
  • docs: regenerate release notes (4173999)
  • fix(engine): remediate v2.9.4 report accuracy and ponytail audit findings (9395404)
  • Merge pull request #1048 from Huyvux12/docs-vietnamese (4d99280)
  • Merge pull request #76 from jmrenouard/fix/sync-master-and-pr68-v294 (558a254)
  • ci(release): sync master updates and mysql 26.10 matrix into v2.9.4 (86f4240)
  • docs: add Vietnamese translation of README and sync with v2.9.3 (edf1333)
  • docs: regenerate release notes (8709020)
  • feat(cli): expose --list-indicators, add doc-lint CI & sync translations (#1044, #1045, #1046) (1f33ba3)
  • docs: regenerate release notes (29a2fcf)
  • docs(docs): remediate documentation audit findings 1-16 and prospectives (#1039) (7479f98)
  • fix(engine): replace bitwise | with logical || for query_cache_type (#1034) (ba34357)
  • docs: regenerate release notes (dcd7c00)
  • fix(engine): remediate ponytail audit issues 1-17 and add unit test suites (a1e034b)
  • docs: regenerate release notes (30b8d35)
  • fix(security): remediate Dependabot alerts in package overrides (119b303)
  • fix(release): restore intact historical release notes for v2.9.3 (800639e)
  • chore(release): bump version to 2.9.4 and synchronize release artifacts (baf0620)
  • docs: regenerate release notes (7fae2b0)
  • chore(ai): adapt AI governance rules and add skills for isolated testing and Windows telemetry (d428c59)
  • docs: regenerate release notes (05d0c79)
  • fix(test): resolve chroot test failures and prevent tree mutation during test execution (#1010) (86706b3)
  • docs: regenerate release notes (17b4afa)
  • fix(system): modernize Windows metrics discovery using PowerShell CIM with WMIC fallback (#992) (cb3f04b)
  • fix(engine): resolve false positive for BIGINT UNSIGNED AUTO_INCREMENT primary keys (#1007) (d6ca116)

⚙️ Technical Evolutions

➕ CLI Options Added

  • --list-indicators

✅ Laboratory Verification Results

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