Re: [google-cloud-sql-discuss] Re: Cloud SQL Dump time

Hi Alexis,

Answer to your questions:

- Which Cloud SDK / mysql command did you use?

Using postgres pg_dump utility

- Is it doing it on more than one computer?

Yes, I tried it on GCP VM, its much smooth there arround 5-7 seconds. And 2 minutes for 130MB data dump.

- Did it use to work before?

No, earlier I had same issue, so used the cloud sql backup utility. But here I needed just schema so had to use this.

- Have you tried another instance?
Yes, Same issue

- How big roughly is this instance?
This instance is occuping 2GB total space, with 7-8 databases

-------------Original message------------

I am experiencing an weird behaviour while taking a backup, its taking 5-7 minutes to get a schema dump of size 125kB from a GCP Cloud SQL DB to local machine.

Is there something that can be tuned here?

Dump process:

File Size:

Network:

Best,

Rajat

Best,

Rajat

---

From: 'Alexis (Google Cloud Support)' via Google Cloud SQL discuss <google-cloud-sql-discuss@googlegroups.com>
Sent: Thursday, July 23, 2020 04:39
To: Google Cloud SQL discuss <google-cloud-sql-discuss@googlegroups.com>
Subject: [google-cloud-sql-discuss] Re: Cloud SQL Dump time

 

Hello Rajat,

There could be a lot of possibilities but we will try to assist the best we can.

It appears that you tried to copy/paste information below but it's not visible to me. Without posting personal information, would you please indicate which command you used and also if it does it on another computer.

Questions:

- Which Cloud SDK / mysql command did you use?

- Is it doing it on more than one computer?

- Did it use to work before?

- Have you tried another instance?

- How big roughly is this instance?

I don't know how much data you have, but if it's because it's too small, then we can try to replicate the problem as soon as you provide us with more info.

Thank you

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/b6a61e2f-de39-45d1-a277-72d42b9deb1bo%40googlegroups.com.