$ show major/MySQLTuner-perl
MySQLTuner-perl is a single-file Perl script for MySQL/MariaDB/Percona Server performance tuning and advisory. It connects to live database instances, collects metrics via SHOW commands, information_schema, and performance_schema, then provides actionable recommendations for performance, security, and resilience. The tool outputs in multiple formats (console, JSON, YAML, HTML, CSV) and includes advanced features like weighted health scoring (0-100), predictive capacity analysis, CVE vulnerability checking, replication analysis, and AI agent integration via --agent-json or MCP server. The repository enforces strict governance: zero CPAN dependencies in the main script, test-driven development, conventional commits, and automated release processes. Auxiliary scripts handle CVE updates, EOL synchronization, compliance checking, and release generation, all while maintaining high code quality and version consistency.
The LLM identified 3 files worth highlighting for reuse:
Fetches CVE data from multiple sources and updates vulnerabilities.csv. Isolated, self-contained, and demonstrates non-obvious skill in handling multiple data sources, error handling, and CSV manipulation. Could be reused for any CVE tracking task with minimal modification.
Synchronizes end-of-life dates from endoflife.date for MySQL/MariaDB/Percona versions. Demonstrates API interaction, data parsing, and file updating. Could be extracted for any version lifecycle tracking with minimal changes.
Provides functions to reset global state for unit testing. Isolated and demonstrates a testing pattern that could be reused in other Perl projects relying on global state, reducing test coupling and improving reliability.