PmaControl logo PmaControl
Resources › MySQL optimization center › MySQL General Query Log

MySQL General Query Log

Structured Markdown documentation to diagnose, measure, and optimize MySQL.

This page is original PmaControl documentation. It keeps a practical index structure for MySQL optimization work, without copying third-party content or depending on an external product.

Reading

The general log traces every connection and query. It is useful for short diagnostics, but expensive in production.

Collection

systemctl status mysql
journalctl -u mysql --since "1 hour ago"
SHOW FULL PROCESSLIST;
SHOW ENGINE INNODB STATUS\G

Correction

  1. Confirm the symptom with logs and metrics.
  2. Isolate the responsible account, database, query, or limit.
  3. Apply a targeted correction.
  4. Verify that the signal decreases after deployment.