Tagged articles

query timeout

3 articles · Page 1 of 1

Mar 26, 2025 · Databases

StarRocks Production Troubleshooting: Data Loss, Memory Spikes, and Global Dictionary Errors

The author documents three StarRocks production issues: varchar(50) truncating MaxCompute strings, BE memory spikes caused by API gateway timeout mismatches, and a global dictionary error fixed by disabling low-cardinality optimization.

Data IntegrationMaxComputeProduction Troubleshooting

0 likes · 4 min read

StarRocks Production Troubleshooting: Data Loss, Memory Spikes, and Global Dictionary Errors

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.

MySQLPT-killScript

0 likes · 7 min read

Enforcing MySQL SELECT Timeout When max_execution_time Does Not Apply

dbaplus Community

Apr 17, 2022 · Databases

Why Killing Slow Queries Often Fails and a Safer MySQL Timeout Solution

The article examines how slow‑query‑induced avalanches arise in MySQL, explains why naïvely killing slow queries is fraught with accuracy, automation and responsibility issues, and proposes a signature‑based timeout mechanism that lets applications safely abort problematic queries.

DBAMySQLdatabase performance

0 likes · 17 min read

Why Killing Slow Queries Often Fails and a Safer MySQL Timeout Solution