PmaControl logo PmaControl
  • Home
  • PmaControl
    • AI Agents 13 on-premise agents
    • Plans Community, Cloud, On-Premise, Premium
    • Documentation Guides, API, architecture
    • Changelog Every stable 5.x release
    • Marketplace Community plugins
    • Clients 28+ companies
    • FAQ 25 questions / 7 categories
    Databases
    • MariaDB 35 articles
    • MySQL 15 articles
    • Galera Cluster 6 articles
    • MaxScale 4 articles
    • ProxySQL 3 articles
    • Amazon Aurora MySQL 0 article
    • Azure Database 0 article
    • ClickHouse 0 article
    • GCP CloudSQL 0 article
    • Percona Server 0 article
    • SingleStore 0 article
    • TiDB 0 article
    • Vitess 0 article
    Solutions
    • Support 24×7 MariaDB & MySQL emergencies
    • SQL Observability Monitoring, alerts, topology
    • High Availability Replication, failover, Galera
    • Disaster Recovery Backup, restore, RPO/RTO
    • Security & Compliance Audit, GDPR, SOC2
    • Migration & Upgrade Zero downtime, pt-osc, gh-ost
  • Plans
  • Resources
    • Documentation Technical guides & API
    • MySQL optimization center Markdown index, metrics, parameters, incidents
    • FAQ 25 frequently asked questions
    • Testimonials Client feedback & use cases
    • Blog Articles & insights
    • Roadmap Upcoming features
    Areas of expertise
    • SQL Observability Monitoring, alerts, Dot3 topology
    • High Availability Replication, failover, Galera
    • Security & Compliance Audit, GDPR, SOC2, ISO 27001
    • Disaster Recovery Backup, restore, RPO/RTO
    • Performance & Optimisation Digests, EXPLAIN, tuning
    • Migration & Upgrade Zero downtime, pt-osc
    Quick links
    • GitHub Wiki 26 pages — install, engine, plugins
    • Source code Official GitHub repository
    • Support 24×7 MariaDB & MySQL emergencies
    • Book a demo 30 min — real architecture
  • Support 24×7
  • Book a demo
Book a demo
🇫🇷 FR Français 🇬🇧 EN English 🇵🇱 PL Polski 🇷🇺 RU Русский 🇨🇳 ZH 中文 🇸🇦 AR العربية
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.
PmaControl
contact@pmacontrol.com
About Privacy Legal notice GitHub Developers Contact
Do not wait for an incident to understand your architecture. © 2014-2026 PmaControl — 68Koncept