Mysql Kill A Query !!top!! -

| Id | User | Host | db | Command | Time | State | Info | |----|------|------|----|---------|------|-------|------| | 19283 | app_user | 10.2.3.4:54321 | shop | Query | 347 | Sending data | SELECT * FROM orders o JOIN order_items oi ON o.id = oi.order_id JOIN products p ON oi.product_id = p.id WHERE o.created_at > '2023-01-01' AND p.tags LIKE '%summer%' |

Killing it was the only immediate option. No time for a graceful shutdown. mysql kill a query

Almost six minutes. That single query was hogging the CPU, locking critical rows, and starving the checkout service. | Id | User | Host | db