A web-based tool for analyzing MySQL slow query logs to identify and troubleshoot problematic database queries.
Box Anemometer is a MySQL slow query monitor that analyzes slow query logs from MySQL instances to identify problematic queries. It provides a web-based dashboard for visualizing query performance data, helping users pinpoint performance bottlenecks and optimize database efficiency.
Database administrators and developers managing MySQL databases who need to monitor and analyze slow query performance. It is particularly useful for teams seeking a more accessible alternative to command-line tools for query analysis.
Developers choose Box Anemometer for its visual interface that simplifies slow query analysis, integration with Percona Toolkit for log parsing, and features like automatic EXPLAIN plan generation and historical tracking, making database optimization more approachable and actionable.
Box SQL Slow Query Monitor
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
Provides a web-based interface for browsing and filtering slow query data, making analysis more accessible than command-line tools, as emphasized in the philosophy.
Seamlessly works with pt-query-digest for parsing and aggregating slow query logs, leveraging a trusted tool in the MySQL ecosystem, as specified in dependencies.
Generates and displays query execution plans automatically, helping users understand performance characteristics without manual intervention, a key feature highlighted.
Maintains history of query performance over time for trend analysis, enabling ongoing optimization efforts, as noted in the feature list.
Requires multiple steps including setting up a MySQL database, installing pt-query-digest, and configuring PHP, with potential errors like numeric argument issues shown in the README.
Heavily reliant on Percona Toolkit's pt-query-digest, meaning functionality is tied to this third-party tool and any changes or issues can disrupt analysis.
Specifically designed for MySQL slow query logs, making it unsuitable for teams using other databases or needing cross-platform monitoring.
The project status badge indicates it's in maintenance mode, suggesting reduced active development and potential for outdated features or lack of support.