Like many monitoring solutions, mycheckpoint is Web-based. Here's an example chart:
mycheckpoint can be configured to monitor both MySQL and server metrics, like InnoDB buffer pool flushes, temporary tables created, operating system load, memory usage, and more. If you don't like charts, mycheckpoint can also generate human-readable reports.
As with stalk, alert conditions can be defined with email notifications, but no secondary tool like collect will be run to log additional troubleshooting data. Another useful feature is mycheckpoint's ability to monitor MySQL variables to detect changes that can lead to problems, or signal that someone has modified MySQL when they shouldn't have.
Monitoring MySQL isn't just for data centers or large deployments. Even if you have a single MySQL server, monitoring is essential; as with your vehicle, there's a lot to know about the system while it's running to help you foresee or avoid malfunctions. mycheckpoint is one solution among many worth trying.
Maintainer: Shlomi Noach
More info: http://code.openark.org/forge/mycheckpoint
Essential MySQL tool No. 8: shard-query
Queries against partitioned or sharded data sets can be accelerated dramatically using shard-query, which parallelizes certain queries behind the scenes. Queries that use the following constructs can benefit from shard-query's parallel execution:
- Subqueries in the FROM clause
- UNION and UNION ALL
Aggregate functions SUM, COUNT, MIN, and MAX can be used with those constructs, too. For example, this query can be executed in parallel by shard-query:
SELECT DayOfWeek, COUNT(*) AS c
JOIN dim_date USING(date_id)
BETWEEN 2000 AND 2008
GROUP BY DayOfWeek
ORDER BY c DESC;
Benchmarks show that parallelizing that query reduces its response time by roughly 85 percent, from 21 seconds to 3.
shard-query is not a stand-alone tool; it requires other programs like Gearman, and it's relatively complex to set up. But if your data is partitioned and your queries use any of the constructs listed above, then the benefits are worth the effort.