Skip to content

v2.8.45

Latest
Latest

Choose a tag to compare

View all tags
@jmrenouard jmrenouard released this 15 Jun 20:21
v2.8.45
289d87f
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Verified
Learn about vigilant mode.

Release Notes - v2.8.45

Date: 2026-06-04

📝 Executive Summary

2.8.45 2026-06-04

- chore: restore doc_sync.py utility script and run doc synchronization.
- feat: export both complete (unfiltered) and filtered CSV files for sys views in dumpdir.
- feat: filter system databases from PFS/sys schema analysis queries and dumpdir exports.
- feat: integrate temptable_max_ram into per-thread buffer memory calculations.
- feat: bypass temptable_max_ram logic if internal_tmp_mem_storage_engine is set to MEMORY or if the engine is MariaDB.
- feat: verify temptable_max_mmap against available disk space in tmpdir.
- feat: add InnoDB index/data ratio check and CSV dump for tables > 50,000 rows.
- feat: display Host/RAM info and Database Uptime in system_recommendations() under remote or cloud modes.
- feat: display database server uptime in all configurations inside get_system_info() and system_recommendations().
- fix: normalize dollar sign escaping in SQL queries to prevent syntax errors and shell interpolation failures.
- fix: skip x$ps_schema_table_statistics_io views in dumpdir schema exports to prevent execution failures on newer MariaDB releases.
- perf: optimize column exploration in mysql_tables by fetching engine and column details in bulk (reducing queries from 2N+3 to 2 per table).
- test: update schemadir.t and repro_no_index.t mocks to match the bulk queries.
- test: update unit tests to verify both filtered and unfiltered dumpdir exports.
- test: add unit tests for system database filtering logic.
- test: add unit tests for temptable memory limit calculations.
- test: add unit test for index/data ratio calculation logic.
- test: add unit tests for temptable_max_mmap disk space checks, MEMORY engine bypass, and MariaDB bypass.
- test: add complementary subtest for non-binding temptable_max_ram scenario to tests/issue_864.t.
- test: add unit tests for compliance checks, doc synchronization, and release files verification.
- test: add unit test for remote/cloud host recap in tests/unit_coverage_boost3.t.

📈 Diagnostic Growth Indicators

Metric Current Progress Status
Total Indicators 14 -1 🛡️
Efficiency Checks 0 0 🛡️
Risk Detections 2 0 🛡️
Information Points 12 -1 🛡️

🛠️ Internal Commit History

  • perf: optimize column exploration in mysql_tables (0e34fe9)
  • chore: update documentation sync timestamp and execution logs (232918d)
  • docs(metadata): update automatically generated README timestamp (24224ea)
  • docs: regenerate release notes (34b3229)
  • feat(cli): export both complete and filtered CSV files for sys views (ebd5409)
  • test(lab): create tests/issue_923.t and restore tests/issue_864.t (be4bd30)
  • chore: update execution logs and sync documentation timestamp (cab32f1)
  • fix(test): only verify release tag consistency if ref is a tag in check_release_files.sh (a0a3341)
  • docs(metadata): update automatically generated README timestamp (abe1eef)
  • docs: regenerate release notes (748bb03)
  • feat(cli): bypass temptable_max_ram on MEMORY/MariaDB and verify temptable_max_mmap (94a19ee)
  • docs: generate USAGE.md (8d0ddeb)
  • chore: release v2.8.45 (0347fad)

⚙️ Technical Evolutions

➕ CLI Options Added

  • --innodb_buffer_stats_by_schema
  • --innodb_buffer_stats_by_table
  • --processlist
  • --schema_auto_increment_columns
  • --schema_index_statistics
  • --schema_object_overview
  • --schema_redundant_indexes
  • --schema_table_lock_waits
  • --schema_table_statistics
  • --schema_table_statistics_with_buffer
  • --schema_tables_with_full_table_scans
  • --schema_unused_indexes
  • --session
  • --statement_analysis
  • --statements_with_errors_or_warnings
  • --statements_with_full_table_scans
  • --statements_with_runtimes_in_95th_percentile
  • --statements_with_sorting
  • --statements_with_temp_tables

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

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

Assets 8
Loading