How one connection kills a database

This post introduces the ability to view and kill connections in Postgres and MySQL databases on PlanetScale. It details how unhandled exceptions can lead to stuck transactions and blocked queries, causing downtime. The PlanetScale dashboard now provides a live list of connections with columns for Process ID, State, Duration, and Blocked Queries. Users can click into a connection to see more details and choose to Cancel query, Terminate transaction, or Terminate connection. For Vitess, options include canceling the query or terminating the connection, with visibility per keyspace and shard. The CLI offers `pscale branch connections top` for a live, interactive view and `pscale branch connections show --format json` for JSON output, with commands to cancel queries or terminate connections.