query timeout

Aikesheng Open Source Community

Aug 24, 2022 · Databases

Enforcing MySQL SELECT Timeout When max_execution_time Does Not Apply

This article explains the limitations of MySQL's max_execution_time for SELECT statements inside stored procedures and provides practical solutions—including external kill scripts and the Percona Toolkit's pt‑kill—to enforce query timeouts while warning against use in production environments.