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

🛠️ 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

Docker Images

docker pull jmrenouard/mysqltuner:2.8.45
docker pull jmrenouard/mysqltuner:latest

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