google-cloud-sql Archives

download mysql slow query log on google cloud sql

By adminPosted on February 16, 2023

Question : I’m having a difficult time locating the log file to download. When running show global variables like ‘%slow%’; […]

By adminPosted on January 26, 2023

Question : Consider this: UPDATE dest SET dest_col = (SELECT s.src_col FROM source s WHERE s.name = ‘abc’ ORDER BY […]

By adminPosted on January 25, 2023

Question : Im using google cloudsql but this is a more generic postgres question. I have a role (that is […]

By adminPosted on January 9, 2023

Question : I have a managed MySQL instance on GCP. Where would I find a query log? Is this something […]

By adminPosted on December 29, 2022

Question : This is My SQL Project instance log. I set the instance not to shut down automatically. But why […]

By adminPosted on November 29, 2022

Question : I have a table with 150 million rows in a Postgres database hosted in Cloud SQL (in Google […]

By adminPosted on November 9, 2022

Question : I’m trying to debug a very slow UPDATE query in one of my tables. The table name is […]

By adminPosted on October 30, 2022

Question : I’ve tried analyzing the EXPLAIN but unsure if I’m missing some helpful index. Queries take 20-30 seconds across […]

By adminPosted on October 4, 2022

Question : Directed here from S/O We have a Master/Replica configuration for Mysql innodb(5.7.32) databases in Cloud SQL… We have […]

By adminPosted on August 17, 2022

Question : I want to add terms to a text search dictionary without access to the file system shares/tsearch_data (specifically […]