A rather complex (depending on standards) query running on a table with about 1M records. Creating some temporary tables and building arrays and jsonb. On localhost I get average of 2.5 seconds. On Google SQL I get 17-19 seconds. Note: Other queries, like simple selects, are faster on server than on local. As it should. I did run vacuum, rebuilded
Tag: google-cloud-sql
Will remove MySQL logs file impact the performance of the database?
One of our users is using Cloud SQL(MySQL). They turn on general logs flag and log_output is file. They need these general logs because of some special circumstances. MySQL generates about 8TB of general logs and these logs result a bigger use of the disk. Here is the tricky part: They want to remove these general logs file [1] to