check_mysql runs as a daemon with a continuous connection to MySQL, watching the list of running SELECT queries. It enforces a timeout for queries: if a query runs too long, it is killed and a report including the query and EXPLAIN output are emailed. Its probably not something you'd want to use on a production system, but it is very useful during development and testing phases for finding, analyzing, and optimizing SQL queries.