cloud-sql-mysql-monitor

To troubleshoot slow queries on Google Cloud SQL for MySQL, this Skill analyzes query execution metrics and execution plans to identify bottlenecks and optimize indexing strategies. It connects directly to the database to perform real-time performance audits.

To monitor Cloud SQL MySQL system resources, this Skill uses PromQL to track CPU, memory, network, and InnoDB buffer pool metrics via Google Cloud Monitoring. This integration ensures your database infrastructure stability under load.

To detect table fragmentation and missing unique indexes in MySQL, this Skill executes diagnostic SQL commands to perform database health checks. This identifies tables lacking primary keys and prevents data integrity issues.

Yes, you need Google Cloud Monitoring integration and direct database connectivity to audit MySQL performance. These prerequisites enable PromQL-based metric tracking and real-time execution of diagnostic SQL for performance analysis.

The best way to identify top active queries on a Cloud SQL MySQL instance is using this Skill's query performance analysis. It lists active queries by connecting to your project database instance and evaluating real-time execution metrics.

MySQL performance bottlenecks occur due to slow queries, resource limits, or schema issues. This Skill provides granular visibility into query execution, system resource utilization, and structural health to identify fragmented tables and missing indexes.