Meta tags:

Headings (most frequently used words):

configure, and, an, instance, curl, linux, macos, or, cloud, shell, powershell, windows, performance, capture, rest, create, update, existing, gcloud, v1, v1beta4, stay, organized, with, collections, save, categorize, content, based, on, your, preferences, before, you, begin, enable, disable, what, next, required, roles, products, pricing, support, resources, engage, the, probing, interval, consecutive, probes, of, metrics, thresholds,

Text of the page (most frequently used words):
the (220), and (99), cloud (93), sql (93), #gcloud (73), you (72), for (63), instance (62), instances (52), request (52), json (48), your (45), database (45), performance (43), following (41), default (41), auth (40), capture (38), project_id (38), using (38), with (37), connect (37), com (36), specify (32), projects (31), https (30), sqladmin (30), googleapis (30), edition (30), version (30), instance_id (28), command (28), use (28), manage (27), create (27), running (26), user (25), from (25), account (24), threshold (23), example (22), access (22), configure (22), seconds (21), then (20), region (20), can (19), must (19), headers (18), body (18), cli (18), active (18), data (18), overview (18), v1beta4 (17), that (17), set (17), about (16), application (16), don (16), mysql (16), content (15), patch (15), note (15), type (15), minimum (15), file (14), enterprise (14), save (13), execute (13), have (13), check (13), shell (13), than (13), google (12), operation_id (12), cred (12), print (12), token (12), authorization (12), bearer (12), method (12), charset (12), utf (12), expand (12), named (12), assumes (12), logged (12), currently (12), list (12), login (12), init (12), curl (12), enabled (12), transaction (12), read (12), number (12), enable (12), upgrade (12), logs (11), name (11), replicas (11), replication (11), mysql_8_4 (11), update (10), before (10), 600 (10), considered (10), over (10), greater (10), between (10), private (10), quickstart (10), true (9), settings (9), import (9), engine (9), status (8), send (8), invoke (8), one (8), transaction_duration_threshold (8), seconds_behind_source_threshold (8), running_threads_threshold (8), probe_threshold (8), probing_interval_seconds (8), threads (8), interval (8), plus (8), roles (8), service (8), server (8), databases (8), high (8), availability (8), external (8), thumb (7), policies (7), monitor (7), operations (7), windows (7), duration (7), log (7), based (7), time (7), probes (7), iam (7), management (7), vector (7), managed (7), terms (6), resources (6), support (6), more (6), view (6), kind (6), operation (6), targetlink (6), pending (6), inserttime (6), operationtype (6), targetid (6), selflink (6), targetproject (6), should (6), receive (6), response (6), similar (6), webrequest (6), contenttype (6), infile (6), uri (6), select (6), object (6), powershell (6), which (6), automatically (6), into (6), linux (6), macos (6), these (6), options (6), performancecaptureconfig (6), http (6), url (6), disable (6), config (6), value (6), 300 (6), lag (6), consecutive (6), trigger (6), post (6), tier (6), edition_type (6), database_version (6), flag (6), compute (6), issues (6), storage (6), backups (6), export (6), recovery (6), authentication (6), code (5), samples (5), information (5), 2025 (5), 10t22 (5), 735z (5), instance_name (5), beta (5), uncommitted (5), tracked (5), included (5), 3600 (5), 900 (5), primary (5), equal (5), not (5), size (5), min (5), cpucount (5), times (5), exceeded (5), valid (5), range (5), integer (5), metric (5), 86400 (5), existing (5), performance_capture_thresholds (5), probe_configuration (5), run (5), custom (5), query (5), tools (5), connection (5), certificates (5), ssl (5), tls (5), encryption (5), embeddings (5), choose (5), app (5), proxy (5), see (4), other (4), down (4), rest (4), replace (4), probingintervalseconds (4), probethreshold (4), runningthreadsthreshold (4), secondsbehindsourcethreshold (4), transactiondurationthreshold (4), performance_capture_enable (4), any (4), make (4), replacements (4), machine_type (4), enterprise_plus (4), machine (4), monitoring (4), insights (4), usage (4), migration (4), public (4), reconfigure (4), optimize (4), language (4), build (4), best (4), practices (4), disaster (4), control (4), users (4), organization (4), major (4), maintenance (4), free (4), system (3), understand (3), need (3), false (3), earlier (3), but (3), doesn (3), instead (3), supports (3), mysql_8_0_37 (3), project (3), values (3), flags (3), agent (3), thresholds (3), probing (3), metrics (3), when (3), get (3), permissions (3), guides (3), observability (3), analytics (3), capacity (3), tables (3), troubleshoot (3), reduce (3), table (3), prevent (3), backup (3), open (3), auditing (3), indexes (3), mcp (3), queries (3), audit (3), search (3), model (3), endpoint (3), reference (3), applications (3), files (3), restore (3), standard (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), pricing (2), products (2), last (2), updated (2), 2026 (2), utc (2), this (2), licensed (2), under (2), are (2), its (2), license (2), feedback (2), databaseversion (2), uses (2), probe (2), both (2), also (2), configuration (2), include (2), same (2), optional (2), configurations (2), mysql_8_0 (2), updating (2), might (2), required (2), predefined (2), viewer (2), admin (2), diagnose (2), detailed (2), pre (2), general (2), features (2), preview (2), documentation (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), memory (2), cache (2), improve (2), assistance (2), agents (2), saved (2), generate (2), predictions (2), dump (2), perform (2), point (2), option (2), back (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), 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, problem, 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, insert_time, where, want, behind, source, 100, perf, optimized, west1, definition, them, later, able, through, granting, folders, organizations, cloudsql, ask, administrator, grant, begin, lets, transient, capturing, degraded, snapshots, feature, subject, offerings, section, available, limited, launch, stage, descriptions, specific, postgresql, categorize, preferences, stay, organized, collections, home, orphan, debug, error, messages, looker, 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, filter, register, interact, models, llm, powered, langchain, embedding, workflow, online, integrate, vertex, generative, develop, cancel, parallel, csv, importing, exporting, deleted, enhanced, advanced, legacy, percona, xtrabackup, physical, large, replicating, autoscaling, promote, outside, connections, functions, operator, dns, certificate, authority, across, multiple, vpcs, learn, how, brute, force, protection, controls, endpoints, side, attach, fine, grained, conditions, identity, secret, manager, handle, secrets, residency, knowledge, catalog, gemini, statements, api, character, collation, operational, guidelines, migrating, versions, troubleshooting, new, peering, allowlists, self, connectivity, tests, locations, supported, deletion, delete, label, stop, restart, clone, edit, series, plan, prepare, local, computer, key, editions, discover, skip, main,

Text of the page (random words):
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 configure performance capture 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 lets you diagnose transient issues with your database by capturing detailed metrics for your instance when performance is degraded to use performance capture enable performance capture for your instance and configure the thresholds that trigger the detailed metrics based snapshots of your cloud sql instance before you begin to use performance capture you must enable query insights for your instance required roles to get the permissions that you need to create an instance and enable performance capture ask your administrator to grant you the following iam roles on the project cloud sql admin roles cloudsql admin compute viewer roles compute viewer 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 enable and configure performance capture you can enable performance capture when you create or update your cloud sql instance gcloud create and configure an instance to enable performance capture when you create your cloud sql instance run the following command gcloud beta sql instances create instance_name database version database_version region region tier tier edition edition_type performance capture config enabled true probe_configuration performance_capture_thresholds replace the following instance_name your instance name database_version the database version for example mysql_8_4 or mysql_8_0_37 if you don t specify a database version then default database version is mysql_8_0 region the region tier your machine type edition_type your cloud sql edition note if you specify mysql_8_4 for the database version and don t specify an edition type then the default cloud sql edition of the instance is enterprise_plus if you specify a database version earlier than mysql 8 4 or don t specify a database version and don t specify an edition type then the default cloud sql edition of the instance is enterprise if you specify mysql_8_4 for the database version but the region you specify doesn t support cloud sql enterprise plus edition then you must specify a region that supports cloud sql enterprise plus edition or create an cloud sql enterprise edition instance instead for the performance capture config flag include enabled true in the same flag definition you can specify optional configurations for probe_configuration and for performance_capture_thresholds or you can specify them later by updating the instance for example gcloud beta sql instances create my instance database version mysql_8_0 edition enterprise_plus tier db perf optimized n 4 region us west1 performance capture config enabled true probing interval seconds 30 probe threshold 5 running threads threshold 10 transaction duration threshold 300 update an existing instance to enable performance capture for an existing cloud sql instance run the following command gcloud beta sql instances patch instance_name performance capture config enabled true probe_configuration performance_capture_thresholds for the performance capture config flag include enabled true for the same flag you can specify optional configurations for probe_configuration and for performance_capture_thresholds you can also use the gcloud beta sql instances patch command to update the threshold configuration values for performance capture on an existing instance configure the probing interval and consecutive probes of performance metrics you can replace probe_configuration with one or both of the following flag settings if you don t set the flags then the monitoring agent uses the default value probing interval seconds seconds an integer between 20 and 86400 the time interval in seconds between metric probes for example 30 60 100 default is 30 probe threshold probes the number of consecutive times a threshold must be exceeded to trigger a performance capture valid range is 1 to 20 default is 3 configure performance capture thresholds you can replace performance_capture_thresholds with one or more of the following flag settings if you don t set values for the flags then the monitoring agent uses the default values for the thresholds running threads threshold threads for primary instances the minimum number of active threads considered to be over the threshold for example 10 must be greater than or equal to 10 if not set then the default is based on the size of the instance default is min 600 cpucount 20 seconds behind source threshold seconds for read replicas the minimum replication lag in seconds considered to be over the threshold must be greater than 0 default is 900 transaction duration threshold seconds the duration in seconds of an uncommitted transaction before the transaction is tracked and included in a performance capture log for example 300 600 minimum value is 60 default is 3600 rest v1 create and configure an instance before using any of the request data make the following replacements project_id your project id instance_id your instance id database_version the database version for example mysql_8_4 or mysql_8_0_37 if you don t specify a database version then default database version is mysql_8_4 region the region machine_type your machine type edition_type your cloud sql edition note if you specify mysql_8_4 for the database version or don t specify a database version and don t specify an edition type then the default cloud sql edition of the instance is enterprise_plus if you specify a database version earlier than mysql 8 4 and don t specify an edition type then the default cloud sql edition of the instance is enterprise if you specify mysql_8_4 for the database version or don t specify a database version but the region you specify doesn t support cloud sql enterprise plus edition then you must specify a region that supports cloud sql enterprise plus edition or create an cloud sql enterprise edition instance instead probing_interval_seconds an integer between 20 and 86400 the time interval in seconds between metric probes default is 30 probe_threshold the number of consecutive times a threshold must be exceeded to trigger a performance capture valid range is 1 to 20 default is 3 running_threads_threshold for primary instances the minimum number of active threads considered to be over the threshold for example 10 must be greater than or equal to 10 if not set then the default is based on the size of the instance default is min 600 cpucount 20 seconds_behind_source_threshold for read replicas the minimum replication lag in seconds considered to be over the threshold must be greater than 0 default is 900 transaction_duration_threshold the duration in seconds of an uncommitted transaction before the transaction is tracked and included in a performance capture log for example 300 600 minimum value is 60 default is 3600 http method and url post https sqladmin googleapis com v1 projects project_id instances request json body name instance_id region region databaseversion database_version settings tier machine_type edition edition_type performancecaptureconfig enabled true probingintervalseconds probing_interval_seconds probethreshold probe_threshold runningthreadsthreshold running_threads_threshold secondsbehindsourcethreshold seconds_behind_source_threshold transactiondurationthreshold transaction_duration_threshold to send your request expand one of these options curl linux macos or cloud shell note the following command assumes that you have logged in to the gcloud cli with your user account by running gcloud init or gcloud auth login or by using cloud shell which automatically logs you into the gcloud cli you can check the currently active account by running gcloud auth list save the request body in a file named request json and execute the following command curl x post h authorization bearer gcloud auth print access token h content type application json charset utf 8 d request json https sqladmin googleapis com v1 projects project_id instances powershell windows note the following command assumes that you have logged in to the gcloud cli with your user account by running gcloud init or gcloud auth login you can check the currently active account by running gcloud auth list save the request body in a file named request json and execute the following command cred gcloud auth print access token headers authorization bearer cred invoke webrequest method post headers headers contenttype application json charset utf 8 infile request json uri https sqladmin googleapis com v1 projects project_id instances select object expand content you should receive a json response similar to the following kind sql operation targetlink https sqladmin googleapis com v1 projects project_id instances instance_id status pending user user example com inserttime 2025 11 10t22 19 33 735z operationtype create name operation_id targetid instance_id selflink https sqladmin googleapis com v1 projects project_id operations operation_id targetproject project_id update an existing instance before using any of the request data make the following replacements performance_capture_enable set to true to enable performance capture for your instance probing_interval_seconds an integer between 20 and 86400 the time interval in seconds between metric probes default is 30 probe_threshold the number of consecutive times a threshold must be exceeded to trigger a performance capture valid range is 1 to 20 default is 3 running_threads_threshold for primary instances the minimum number of active threads considered to be over the threshold for example 10 must be greater than or equal to 10 if not set then the default is based on the size of the instance default is min 600 cpucount 20 seconds_behind_source_threshold for read replicas the minimum replication lag in seconds considered to be over the threshold must be greater than 0 default is 900 transaction_duration_threshold the duration in seconds of an uncommitted transaction before the transaction is tracked and included in a performance capture log for example 300 600 minimum value is 60 default is 3600 http method and url patch https sqladmin googleapis com v1 projects project_id instances instance_id request json body performancecaptureconfig enabled performance_capture_enable probingintervalseconds probing_interval_seconds probethreshold probe_threshold runningthreadsthreshold running_threads_threshold secondsbehindsourcethreshold seconds_behind_source_threshold transactiondurationthreshold transaction_duration_threshold to send your request expand one of these options curl linux macos or cloud shell note the following command assumes that you have logged in to the gcloud cli with your user account by running gcloud init or gcloud auth login or by using cloud shell which automatically logs you into the gcloud cli you can check the currently active account by running gcloud auth list save the request body in a file named request json and execute the following command curl x patch h authorization bearer gcloud auth print access token h content type application json charset utf 8 d request json https sqladmin googleapis com v1 projects project_id instances instance_id powershell windows note the following command assumes that you have logged in to the gcloud cli with your user account by running gcloud init or gcloud auth login you can check the currently active account by running gcloud auth list save the request body in a file named request json and execute the following command cred gcloud auth print access token headers authorization bearer cred invoke webrequest method patch headers headers contenttype application json charset utf 8 infile request json uri https sqladmin googleapis com v1 projects project_id instances instance_id select object expand content you should receive a json response similar to the following kind sql operation targetlink https sqladmin googleapis com v1 projects project_id instances instance_id status pending user user example com inserttime 2025 11 10t22 19 33 735z operationtype update name operation_id targetid instance_id selflink https sqladmin googleapis com v1 projects project_id operations operation_id targetproject project_id rest v1beta4 create and configure an instance before using any of the request data make the following replacements project_id your project id instance_id your instance id database_version the database version for example mysql_8_4 or mysql_8_0_37 if you don t specify a database version then default database version is mysql_8_4 region the region machine_type your machine type edition_type your cloud sql edition note if you specify mysql_8_4 for the database version or don t specify a database version and don t specify an edition type then the default cloud sql edition of the instance is enterprise_plus if you specify a database version earlier than mysql 8 4 and don t specify an edition type then the default cloud sql edition of the instance is enterprise if you specify mysql_8_4 for the database version o...