MySQL / MariaDB DBA

Common MySQL / MariaDB Database Administration Tasks & Troubleshooting

Question

Clients are refused because all connections are in use; what is the triage runbook?

Answer

1. Inspect the process list. 2. Separate active work from idle sessions. 3. Check max_connections and application pooling. 4. End confirmed runaway sessions with KILL. 5. Recheck connection admission; revert temporary capacity changes. Applies to MySQL and MariaDB.

This is 20 of 23 free samples for MySQL / MariaDB DBA.

More MySQL / MariaDB DBA topic samples