Check MySQL Group Replication status to monitor cluster health, member roles, replication channels, and transaction certification for performance tuning.
Identify and analyze slow MySQL queries using performance_schema data to optimize database performance by examining execution times, row statistics, and query patterns.
Creates compressed remote MySQL, PostgreSQL, or MongoDB backups over SSH without modifying the source database. Supports transaction-safe MySQL dumps and PostgreSQL custom-format backups.
Enables read-only SQL queries and schema inspection for legacy MySQL 5.0–5.6 deployments using SHOW-based metadata tools, without write operations or modern authentication support.
Analyze MySQL index statistics to identify low cardinality indexes, oversized indexes, and infrequently used indexes for database performance optimization.
Analyze MySQL audit log configuration, verify plugin status, review recent audit events, and identify compliance gaps for MySQL Enterprise Audit, MariaDB, and Percona audit plugins.
Lists MySQL engine versions available for Cloud DB Serverless in ascending order. Use this to see which versions you can select for your serverless database.
Analyze MySQL query patterns to identify full table scans and inefficient index usage, then generate prioritized index recommendations for performance optimization.
Analyze MySQL configuration settings to identify performance issues and get optimization recommendations for memory, InnoDB, connections, and logging parameters.