Tag

pt-kill

0 views collected around this technical thread.

Aikesheng Open Source Community

Oct 9, 2023 · Databases

Using MySQL Offline Mode to Disconnect Client Connections

This article explains how MySQL's offline_mode variable and the pt‑kill tool can be used by DBAs to place a server in maintenance mode, instantly dropping non‑privileged client connections, preventing new ones, and providing a safe way to perform maintenance or backups.

Database MaintenanceMySQLOFFLINE_MODE

0 likes · 8 min read

Using MySQL Offline Mode to Disconnect Client Connections

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.

MySQLmax_execution_timept-kill

0 likes · 7 min read

Enforcing MySQL SELECT Timeout When max_execution_time Does Not Apply