Meta tags:

Headings (most frequently used words):

performance, capture, and, filter, view, logs, the, data, in, log, stay, organized, with, collections, save, categorize, content, based, on, your, preferences, before, you, begin, review, example, filters, required, roles, permissions, by, specific, event, across, filenames, products, pricing, support, resources, engage,

Text of the page (most frequently used words):
the (107), cloud (77), and (76), sql (56), for (48), #performance (46), instance (38), connect (37), log (32), #capture (30), using (29), manage (27), from (27), with (26), use (26), logs (25), about (24), data (21), database (21), mysql (19), overview (18), instances (17), event (16), labels (15), project_id (14), view (14), create (14), google (13), information (13), timestamp (13), your (13), configure (13), report (12), upgrade (12), following (11), specific (11), engine (11), more (10), you (10), replication (10), access (10), private (10), quickstart (10), see (9), example (9), projects (9), innodb (9), queries (9), monitor (9), high (9), import (9), status (8), project (8), file_name (8), cloudsql (8), googleapis (8), com (8), 2fmysql (8), logname (8), get (8), filter (8), logging (8), service (8), server (8), databases (8), set (8), availability (8), external (8), resources (7), thumb (7), this (7), policies (7), time (7), query (7), entry (7), issues (7), table (7), storage (7), iam (7), management (7), vector (7), managed (7), read (7), terms (6), all (6), replace (6), format (6), event_time (6), entries (6), threshold (6), transactions (6), documentation (6), tools (6), connection (6), roles (6), backups (6), export (6), recovery (6), replicas (6), authentication (6), code (5), samples (5), that (5), search (5), how (5), active (5), api (5), running (5), output (5), standard (5), permissions (5), custom (5), certificates (5), settings (5), ssl (5), tls (5), encryption (5), embeddings (5), choose (5), app (5), proxy (5), version (5), events (4), other (4), down (4), innodbstatus (4), 2025 (4), 16t13 (4), 07z (4), yyyy (4), first (4), activequeries (4), reports (4), across (4), file (4), monitoring (4), gcloud (4), cli (4), transaction (4), admin (4), seconds (4), replica (4), threads (4), show (4), pool (4), console (4), usage (4), migration (4), compute (4), application (4), public (4), reconfigure (4), optimize (4), language (4), build (4), best (4), practices (4), disaster (4), auth (4), control (4), users (4), organization (4), major (4), maintenance (4), free (4), system (3), support (3), understand (3), need (3), content (3), details (3), any (3), general (3), label (3), provides (3), number (3), can (3), lock (3), memory (3), name (3), guides (3), observability (3), analytics (3), capacity (3), tables (3), troubleshoot (3), reduce (3), prevent (3), backup (3), open (3), enable (3), auditing (3), disable (3), indexes (3), insights (3), mcp (3), audit (3), model (3), endpoint (3), reference (3), applications (3), files (3), restore (3), migrate (3), vpc (3), run (3), pooling (3), connectors (3), customer (3), tags (3), secure (3), place (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), architecture (2), started (2), pricing (2), products (2), last (2), updated (2), 2026 (2), utc (2), page (2), licensed (2), under (2), are (2), its (2), license (2), send (2), feedback (2), text (2), waits (2), search_text (2), primary_1_activequeries (2), find (2), triggering (2), look (2), explorer (2), examples (2), section (2), analysis (2), type (2), triggered (2), string (2), each (2), labeled (2), through (2), based (2), agent (2), sends (2), duration (2), long (2), interpret (2), information_schema (2), innodb_trx (2), contains (2), including (2), also (2), diagnose (2), applier (2), runningthreadsthreshold (2), state (2), contention (2), buffer (2), history (2), list (2), length (2), load (2), metrics (2), counts (2), description (2), multiple (2), select (2), then (2), might (2), required (2), predefined (2), viewer (2), have (2), pre (2), features (2), preview (2), sdk (2), languages (2), frameworks (2), infrastructure (2), costs (2), security (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), cache (2), improve (2), enterprise (2), plus (2), assistance (2), agents (2), saved (2), generate (2), invoke (2), predictions (2), dump (2), perform (2), point (2), option (2), back (2), replicate (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, easy, easytounderstand, solved, problem, solvedmyproblem, otherup, hard, hardtounderstand, incorrect, sample, incorrectinformationorsamplecode, missing, missingtheinformationsamplesineed, otherdown, tell, except, otherwise, noted, java, registered, trademark, oracle, affiliates, developers, apache, creative, commons, attribution, want, semaphore, textpayload, within, occurred, after, certain, primary_3_innodbstatus, primary_1_innodbstatus, compare, 1st, 3rd, useful, seeing, during, filenames, _1_, only, types, builder, related, filters, filename, identifies, sequence, which, report_type, sequence_number, instance_type, indicates, unique, two, help, sort, correlate, observed, when, detects, issue, configured, associated, longrunningtransactions, transactiondurationthreshold, being, tracked, watcher, replicastatus, behind, source, secondsbehindsourcethreshold, diagnostic, gtid, sets, schema, includes, five, relay, execution, position, used, errors, delays, worker, statement, critical, diagnosing, problems, growth, keywords, latest, detected, deadlock, mutex, semaphores, captures, grouped, bucketed, runtime, detailed, top, longest, helps, identify, periods, pinpoint, slow, processes, processlist, trigger, defined, correlates, configuring, thresholds, review, payload, captured, commands, like, spanning, lines, click, able, ask, administrator, grant, role, granting, folders, organizations, must, proper, before, begin, viewing, collects, feature, subject, offerings, available, limited, launch, stage, descriptions, postgresql, save, categorize, preferences, stay, organized, collections, home, updating, orphan, debug, error, messages, looker, user, rotate, broad, ranges, underprovisioned, overprovisioned, idle, temporary, increasing, retention, out, cpu, disk, definitions, increase, reliability, enforce, apply, recommendations, index, advisor, natural, querydata, conversational, securing, interactions, remote, work, register, interact, models, llm, powered, langchain, embedding, workflow, online, integrate, vertex, generative, develop, check, operations, cancel, parallel, csv, importing, exporting, deleted, enhanced, advanced, legacy, configuration, percona, xtrabackup, physical, large, replicating, autoscaling, lag, promote, outside, connections, functions, operator, dns, certificate, authority, vpcs, both, learn, brute, force, protection, controls, endpoints, side, attach, fine, grained, conditions, identity, secret, manager, handle, secrets, residency, knowledge, catalog, gemini, execute, statements, update, character, collation, operational, guidelines, migrating, versions, troubleshooting, new, peering, allowlists, self, windows, connectivity, tests, locations, flags, supported, deletion, delete, stop, restart, clone, edit, region, machine, series, plan, prepare, local, computer, shell, key, editions, discover, skip, main,

Text of the page (random words):
rt 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 view performance capture logs 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 performance capture collects and sends instance metrics data to cloud logging in the mysql performance capture log file for more information about viewing logs in cloud logging see view logs by using the logs explorer before you begin to view performance capture logs you must have the proper permissions to view logs in cloud logging for your project and instance required roles and permissions to get the permissions that you need to view performance capture logs ask your administrator to grant you the logs viewer roles logging viewer iam role on the project of the instance for more information about granting roles see manage access to projects folders and organizations you might also be able to get the required permissions through custom roles or other predefined roles view performance capture logs to view performance capture logs do the following in the google cloud console go to the cloud logging page go to cloud logging click all resources then select cloud sql database select your cloud sql instance filter for the log name logname projects project_id logs cloudsql googleapis com 2fmysql performance capture log replace project_id with your project id the log payload is in the string format and contains the output of captured commands like show engine innodb status spanning across multiple log lines review the data in a performance capture log each performance capture log is triggered by a performance event that you defined for your instance the following table correlates performance capture log entries with the configuring thresholds and provides a description of the performance data report that you can view in the entry log performance capture log entry description threshold trigger report name active queries captures database load metrics including connection and transaction counts grouped by state active query counts bucketed by runtime duration 2 seconds 2 to 10 seconds 10 seconds and detailed information for the top 50 longest running transactions or queries this report helps identify periods of high load and pinpoint specific slow queries for more information about how to interpret data about innodb transactions and processes see the information_schema innodb_trx table and the processlist table in the mysql documentation runningthreadsthreshold cloud sql admin api running threads threshold gcloud cli activequeries innodb status provides information about the state of the innodb storage engine at the time of the performance event this is critical for diagnosing lock contention transaction issues buffer pool problems and history list length growth keywords to look for transactions long running transactions lock waits semaphores mutex contention latest detected deadlock buffer pool and memory history list length for more information about innodb standard monitor output see innodb standard monitor and lock monitor output in the mysql documentation runningthreadsthreshold cloud sql admin api running threads threshold gcloud cli innodbstatus replication analysis contains replication diagnostic information including the output of show replica status gtid sets and details from performance schema tools the report also includes the first five events from the relay log following the execution position at the time of the performance event this report can be used to diagnose replication errors or delays for more information about show replica status output and replica applier threads see show replica status statement and monitoring replication applier worker threads in the mysql documentation secondsbehindsourcethreshold cloud sql admin api seconds behind source threshold gcloud cli replicastatus transaction watcher data details on the long running transactions being tracked for more information about how to interpret data about innodb transactions see the information_schema innodb_trx table in the mysql documentation transactiondurationthreshold cloud sql admin api transaction duration threshold gcloud cli longrunningtransactions filter the data in a performance capture log when performance capture detects an issue based on a threshold configured for your cloud sql instance the monitoring agent sends labeled log entries associated with the instance and type of report to cloud logging to help you sort through logs and correlate log entries with the performance issues observed for your instance you can filter the performance capture log entries by label each log entry is labeled with the following two labels time of the event or labels event_time indicates the time of the performance capture entry log the format is a unique timestamp string yyyy mm dd t hh mm ss z for example 2025 10 16t13 12 07z filename or labels file_name identifies the type of report and the sequence number of the performance capture log entry triggered by a performance event the format is instance_type _ sequence_number _ report_type for example primary_1_activequeries which is the first performance capture log entry of an active queries report example filters this section provides examples of how to filter the mysql performance capture log file for specific log entries for analysis in the following examples replace the following project_id project id of the cloud sql instance timestamp timestamp of the triggering performance event in the format yyyy mm dd t hh mm ss z for example 2025 10 16t13 12 07z filter by a specific performance event to filter by a specific performance event use the labels event_time label to find related log entries for example to get reports for a specific performance event use the following queries in logging logs explorer query builder get all reports for a specific event logname projects project_id logs cloudsql googleapis com 2fmysql performance capture log labels event_time timestamp get innodb report for a specific event logname projects project_id logs cloudsql googleapis com 2fmysql performance capture log ...