Meta tags:
Headings (most frequently used words):
performance, capture, and, pricing, cloud, sql, overview, stay, organized, with, collections, save, categorize, content, based, on, your, preferences, example, use, cases, how, data, is, captured, limitations, what, next, diagnose, database, stall, analyze, query, degradation, investigate, replication, lag, manage, long, running, transactions, configurable, triggers, cooldown, period, after, products, support, resources, engage,
Text of the page (most frequently used words):
the (75), cloud (66), and (65), sql (50), for (39), #performance (38), connect (37), #capture (32), instance (32), use (30), using (29), manage (27), from (27), database (27), with (21), overview (20), configure (19), instances (18), mysql (17), you (17), about (16), data (16), your (14), create (14), google (12), example (12), upgrade (12), log (11), high (11), query (10), set (10), read (10), private (10), quickstart (10), agent (9), number (9), service (9), access (9), import (9), engine (9), logs (8), triggers (8), replication (8), usage (8), server (8), databases (8), availability (8), external (8), system (7), thumb (7), information (7), more (7), policies (7), monitor (7), can (7), storage (7), that (7), replicas (7), when (7), threshold (7), issues (7), management (7), vector (7), managed (7), terms (6), resources (6), this (6), view (6), prevent (6), run (6), trigger (6), running (6), backups (6), export (6), recovery (6), iam (6), authentication (6), code (5), samples (5), pricing (5), problem (5), disable (5), insights (5), logging (5), might (5), lag (5), enable (5), issue (5), tools (5), connection (5), certificates (5), settings (5), ssl (5), tls (5), encryption (5), embeddings (5), choose (5), app (5), proxy (5), version (5), see (4), down (4), then (4), than (4), transaction (4), specific (4), probes (4), time (4), long (4), queries (4), standard (4), migration (4), compute (4), application (4), public (4), reconfigure (4), optimize (4), language (4), build (4), best (4), practices (4), custom (4), disaster (4), auth (4), control (4), users (4), organization (4), major (4), maintenance (4), free (4), support (3), understand (3), other (3), content (3), under (3), are (3), its (3), only (3), which (3), costs (3), cooldown (3), period (3), minutes (3), after (3), transactions (3), specified (3), runs (3), exceeds (3), seconds (3), active (3), threads (3), configurable (3), metrics (3), how (3), identifies (3), user (3), diagnose (3), point (3), guides (3), observability (3), analytics (3), capacity (3), tables (3), troubleshoot (3), reduce (3), table (3), backup (3), open (3), auditing (3), indexes (3), mcp (3), audit (3), search (3), model (3), endpoint (3), reference (3), applications (3), files (3), restore (3), migrate (3), vpc (3), pooling (3), connectors (3), customer (3), tags (3), secure (3), place (3), console (3), trial (3), product (3), 한국어 (2), 日本語 (2), עברית (2), português (2), brasil (2), italiano (2), indonesia (2), français (2), español (2), américa (2), latina (2), deutsch (2), english (2), sign (2), join (2), site (2), youtube (2), events (2), architecture (2), started (2), status (2), products (2), need (2), last (2), updated (2), 2026 (2), utc (2), licensed (2), license (2), send (2), feedback (2), available (2), have (2), excessive (2), snapshot (2), new (2), state (2), any (2), single (2), transactiondurationthreshold (2), replica (2), secondsbehindsourcethreshold (2), value (2), runningthreadsthreshold (2), following (2), captured (2), series (2), detailed (2), detected (2), has (2), been (2), temporary (2), detects (2), configuration (2), based (2), investigate (2), check (2), reveals (2), wide (2), degradation (2), index (2), root (2), cause (2), increase (2), connections (2), stall (2), section (2), cases (2), snapshots (2), transient (2), pre (2), general (2), features (2), preview (2), documentation (2), sdk (2), languages (2), frameworks (2), infrastructure (2), security (2), monitoring (2), networking (2), industry (2), solutions (2), distributed (2), hybrid (2), multicloud (2), pipelines (2), hosting (2), development (2), known (2), password (2), remove (2), authorized (2), networks (2), loss (2), enabling (2), automated (2), memory (2), cache (2), improve (2), enterprise (2), plus (2), assistance (2), agents (2), saved (2), generate (2), invoke (2), predictions (2), dump (2), perform (2), option (2), back (2), file (2), replicate (2), pool (2), pools (2), regional (2), kubernetes (2), flexible (2), phpmyadmin (2), client (2), authorize (2), services (2), write (2), keys (2), cmek (2), add (2), parameterized (2), views (2), studio (2), built (2), minor (2), network (2), edition (2), updates (2), shrink (2), start (2), environment (2), cross (2), technology (2), areas (2), close (2), subscribe, newsletter, our, third, decade, climate, action, cookies, privacy, tech, twitter, blog, engage, training, certification, center, getting, github, release, notes, community, forums, contact, sales, marketplace, all, easy, easytounderstand, solved, solvedmyproblem, otherup, hard, hardtounderstand, incorrect, sample, incorrectinformationorsamplecode, missing, missingtheinformationsamplesineed, otherdown, tell, except, otherwise, noted, page, details, java, registered, trademark, oracle, affiliates, developers, apache, creative, commons, attribution, what, next, later, must, also, enabled, limitations, storing, stores, incur, additional, overhead, during, sustained, event, implements, successful, automatically, activated, triggering, redundant, captures, while, extended, individual, longer, duration, 300, primary, goes, higher, 100, formatted, into, entries, sent, directly, project, stream, named, triggered, connects, diagnostic, commands, exceeded, continues, compare, live, rules, false, alarms, spikes, full, consecutive, three, row, defined, interval, default, operates, monitors, does, batch, job, amount, holding, locks, pinpoint, gtid, causing, falling, significantly, behind, source, accumulated, massive, undo, text, suddenly, degrades, analyze, define, semaphore, waits, mutex, contention, adaptive, hash, unresponsive, several, but, show, drop, per, second, qps, lists, experiences, such, slowdown, insufficient, determining, solves, capturing, moment, take, occur, detect, helps, resolve, complex, feature, subject, offerings, limited, launch, stage, descriptions, postgresql, save, categorize, preferences, stay, organized, collections, home, updating, orphan, debug, error, messages, looker, rotate, broad, ranges, underprovisioned, overprovisioned, idle, increasing, retention, out, cpu, disk, definitions, reliability, enforce, apply, recommendations, advisor, natural, querydata, conversational, securing, interactions, remote, work, filter, register, interact, models, llm, powered, langchain, embedding, workflow, online, integrate, vertex, generative, develop, operations, cancel, parallel, csv, importing, exporting, deleted, enhanced, advanced, legacy, percona, xtrabackup, physical, large, replicating, autoscaling, promote, outside, functions, operator, dns, name, certificate, authority, across, multiple, vpcs, both, learn, brute, force, protection, controls, endpoints, side, attach, fine, grained, conditions, roles, permissions, identity, predefined, secret, manager, handle, secrets, residency, knowledge, catalog, gemini, execute, statements, api, update, character, collation, operational, guidelines, migrating, versions, troubleshooting, peering, allowlists, self, windows, connectivity, tests, locations, flags, supported, deletion, delete, label, stop, restart, clone, edit, region, machine, plan, prepare, local, computer, shell, get, key, editions, discover, skip, main,
Text of the page (random words):
des reference samples resources cross product tools more console discover product overview cloud sql editions overview cloud sql for mysql features key terms get started free trial instances free trial instance overview create a free trial instance quickstart create and query a database in the cloud console create an instance in a private network and then import a database connect from a cloud service quickstart connect from cloud shell quickstart connect from cloud run quickstart connect from google kubernetes engine quickstart connect from app engine standard environment quickstart connect from app engine flexible environment quickstart connect from compute engine quickstart connect using private ip quickstart connect using the cloud sql auth proxy quickstart connect from your local computer plan and prepare overview choose a cloud sql edition choose a machine series choose a storage option region availability data cache overview create and manage instances create instances edit instances clone instances start stop and restart instances label instances delete instances prevent deletion of an instance supported instance settings view instance information configure database flags manage instance locations manage connectivity tests manage capacity about storage shrink shrink instance storage capacity manage maintenance updates maintenance updates on instances view and set maintenance windows perform self service maintenance upgrade upgrade an instance to cloud sql enterprise plus edition upgrade an instance by using in place upgrade upgrade an instance by using ip allowlists upgrade an instance by using vpc peering upgrade an instance to the new network architecture upgrade the database major version upgrade the database major version in place troubleshooting in place major version upgrade to mysql 8 0 known issues in mysql 8 0 minor versions upgrade the database major version by migrating data upgrade the database minor version use best practices general best practices operational guidelines databases create and manage databases update the character set and collation for a database execute sql statements using the cloud sql data api users about mysql users cloud sql built in database authentication manage users with built in authentication cloud sql studio manage your data using cloud sql studio write sql with gemini assistance manage your resources using knowledge catalog secure and control access overview about access control data residency overview use secret manager to handle secrets in cloud sql parameterized secure views overview use parameterized secure views organization policies cloud sql organization policies add predefined organization policies add custom organization policies identity and access management iam iam authentication roles and permissions use iam conditions configure instances for iam database authentication manage users with iam database authentication log in using iam database authentication fine grained access control with tags access control with google cloud tags attach and manage tags on cloud sql instances use encryption about client side encryption about customer managed encryption keys cmek use customer managed encryption keys cmek use cloud sql regional endpoints configure vpc service controls use cloud sql brute force protection connect choose how to connect to cloud sql authorize with authorized networks connect to an instance using public ip configure public ip connect to an instance using private ip learn about using private ip configure private ip configure private services access connect to an instance using a write endpoint private service connect overview connect to an instance using private service connect configure both private services access and private service connect connect to your instance across multiple vpcs connect using ssl tls certificates authorize with ssl tls certificates configure ssl tls certificates manage ssl tls certificates use a customer managed certificate authority ca set up a custom dns name connect using cloud sql language connectors cloud sql language connectors overview connect using the cloud sql language connectors connect using the cloud sql auth proxy about the cloud sql auth proxy connect using the cloud sql auth proxy connect using cloud sql proxy operator use managed connection pooling managed connection pooling overview configure managed connection pooling connect from applications connect using a mysql client connect from cloud run connect from cloud functions connect from app engine standard use phpmyadmin on app engine use phpmyadmin on cloud run connect from app engine flexible connect from compute engine connect from kubernetes engine connect from cloud build manage database connections connect from other mysql tools connect to an instance from outside its vpc replicate about replication in cloud sql create and manage replicas create read replicas manage read replicas create and manage indexes on read replicas promote replicas for regional migration or disaster recovery replication lag create and manage read pools about read pools create a read pool read pool autoscaling configure external replicas replicate from an external server about replicating from an external server configure cloud sql and the external server for replication use a managed import to set up replication from external databases use a dump file to set up replication from external databases use a custom import to set up replication from large external databases migrate data about data migration in cloud sql migrate from a percona xtrabackup physical file migrate from cloud sql to an external server availability and disaster recovery dr availability in cloud sql about high availability ha enable and disable high availability ha legacy configuration for high availability ha about disaster recovery dr use advanced disaster recovery dr back up and restore back up an instance cloud sql backups overview choose your backup option manage standard backups manage enhanced backups manage backups for deleted instances view audit logs for automated backups restore an instance overview restore an instance using a backup configure point in time recovery perform point in time recovery import and export best practices for importing and exporting data export and import using sql dump files export and import using csv files export and import files in parallel cancel the import and export of data check the status of import and export operations develop build generative ai applications using cloud sql integrate cloud sql with vertex ai invoke online predictions understand an example of an embedding workflow build llm powered applications using langchain interact with custom models using model endpoint management overview register a model generate embeddings invoke predictions model endpoint management reference vector search vector search enable and disable vector embeddings generate and manage vector embeddings create and manage vector indexes search and filter with vector embeddings work with vector embeddings preview use cloud sql for mysql with agents use the cloud sql remote mcp server best practices for securing agent interactions with mcp use saved queries overview create and manage saved queries build data agents with conversational analytics query database in natural language with querydata monitor and optimize about database observability monitor and troubleshoot with ai assistance audit audit logs mysql database auditing use mysql database auditing performance capture overview configure performance capture view performance capture logs query performance use query insights use index advisor monitor active queries system performance monitor instances view instance logs use system insights monitor cloud sql using the database insights mcp server apply recommendations create indexes or reconfigure join settings disable public ip enable database auditing enforce ssl tls encryption improve instance reliability by enabling high availability improve performance with enterprise plus increase the table open cache manage open tables and open table definitions manage high number of tables monitor disk availability optimize high cpu usage optimize high memory usage optimize instances with high number of out of memory events prevent data loss by enabling automated backups prevent data loss by increasing backup retention reconfigure connection settings reconfigure log settings reconfigure temporary table settings reduce idle cloud sql instances reduce overprovisioned cloud sql instances reduce underprovisioned cloud sql instances remove authorized networks remove broad public ip ranges rotate server certificates set instance password policies set user password policies use looker with cloud sql troubleshoot known issues troubleshoot error messages debug connection issues diagnose issues orphan tables issues updating storage capacity ai and ml application development application hosting compute data analytics and pipelines databases distributed hybrid and multicloud industry solutions migration networking observability and monitoring security storage access and resources management costs and usage management infrastructure as code sdk languages frameworks and tools home documentation databases cloud sql mysql guides send feedback cloud sql performance capture overview stay organized with collections save and categorize content based on your preferences mysql postgresql sql server preview this feature is subject to the pre ga offerings terms in the general service terms section of the service specific terms pre ga features are available as is and might have limited support for more information see the launch stage descriptions cloud sql for mysql performance capture helps you diagnose and resolve complex and transient performance issues in your mysql database when your instance experiences performance degradation such as a database slowdown or stall standard metrics can be insufficient for determining the root cause performance capture solves this issue by capturing detailed point in time snapshots of the database at the moment when a problem is detected you can use configurable triggers to take system wide snapshots when transient issues occur and to detect long running transactions example use cases this section lists example use cases for how you can use performance capture after you enable it for your instance diagnose a database stall issue an instance has been unresponsive for several minutes but the metrics show only a drop in queries per second qps and an increase in connections example usage define a threshold trigger using runningthreadsthreshold the performance capture log reveals a high number of semaphore waits which identifies a specific mutex contention for example on the adaptive hash index as the root cause analyze query degradation issue query performance suddenly degrades system wide example usage the performance capture log reveals a single long running transaction that accumulated a massive number of undo logs the log identifies the long running transaction user and query text investigate replication lag issue a read replica is falling significantly behind its source example usage you configure a high value trigger threshold for secondsbehindsourcethreshold you can check the performance capture log to pinpoint the specific gtid causing the lag manage long running transactions issue a batch job or user query runs for an excessive amount of time holding locks example usage you configure a threshold trigger for transactiondurationthreshold the performance capture log identifies the transaction that exceeds the threshold you can use this information to investigate how performance data is captured performance capture operates as an agent based service that monitors your instance when you enable performance capture your cloud sql instance does the following to capture performance data the agent probes your database configuration to read the triggers that you ve defined the agent then probes the metrics of your database at a configurable interval which is set to 30 seconds by default if a problem is detected and the threshold of a trigger has been exceeded then the agent continues to compare the database s live state to your rules to prevent any false alarms from temporary spikes the agent triggers a full performance capture only if it detects the problem for a consecutive number of probes for example the agent might trigger a performance capture if it detects that the number of threads are high for three probes in a row when a performance capture is triggered the agent connects to the database and runs a series of diagnostic commands to capture a detailed snapshot the captured information is formatted into log entries and sent directly to the project s cloud logging for the cloud sql instance under a specific log stream named mysql performance capture log configurable triggers you can configure the following triggers for performance capture runningthreadsthreshold triggers when the number of active threads running on a primary instance exceeds the specified value for example you might configure the threshold to run performance capture if the number of active running threads goes higher than 100 secondsbehindsourcethreshold triggers for replicas when replication lag exceeds the specified number of seconds for example you might configure the threshold to run performance capture if the read replica lag is more than 300 seconds transactiondurationthreshold triggers logging for individual transactions that run longer than the specified duration for example you might set up the trigger to log any single transaction that runs for more than 10 minutes cooldown period after a performance capture to prevent excessive logging and system overhead during a sustained performance event performance capture implements a cooldown period of 30 minutes after a successful snapshot capture this cooldown period is automatically activated to prevent the agent from triggering new redundant captures while the system is in an extended problem state pricing performance capture stores logs in cloud logging which can incur additional storage costs for more information about the pricing for storing logs in logging see pricing limitations you must have query insights enabled to use performance capture if you disable query insights then you also disable performance capture performance capture is available only for cloud sql for mysql 5 7 and later what s next configure performance capture view performance capture logs monitor instances send feedback except as otherwise noted the content of this page is licensed under the creative commons attribution 4 0 license and code samples are licensed under the apache 2 0 license for details see the google developers site policies java is a registered trademark of oracle and or its affiliates last updated 2026 07 17 utc need to tell us more easy to understand easyto...
|
