Monday, August 30, 2021

[google-cloud-sql-discuss] How to Connect Google SQL database from AWS EC2

Hello, i'm new member here, i have a problem for connecting my Cloud SQL DB from AWS Ec2, now i have VPN S2S between AWS and GCP and it's now already work for ping and remote vm each other, but when i want to connect database from AWS EC2 always fail and can't connect with error "ERROR 2003 (HY000): Can't connect to MySQL server on '10.xx.xx.xx' (110)" what must be to do?

thanks

--
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/4915fa96-6c32-42ac-bad8-4577e192aea8n%40googlegroups.com.

Tuesday, August 24, 2021

[google-cloud-sql-discuss] Unable to see query plan samples for query insights

Hi,

I am using query insights, but I am unable to see any query plan samples:

Screen Shot 2021-08-24 at 11.37.50 AM.png

Looking at the database logs, I noticed these log messages:

storage/speckle/postgres/extensions/google_insights/google_insights.c:1102: Unable to report sampled query plan for <query> due to hashtable size limit

I cannot find any information on what hashtable this is referring to. Anyone have ideas on how to fix this?

--
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/bca35f08-c863-4826-b624-e859582f7067n%40googlegroups.com.

Monday, August 23, 2021

[google-cloud-sql-discuss] Cloud SQL Memory metrics

Have you noticed a few changes in the Cloud SQL Console, the memory has two metrics "Total memory usage" and "Memory usage"

what do they mean?
#postgres

Confidentiality Notice: 
This e-mail transmission, and any documents, files or previous e-mail messages attached to it may contain confidential information that is legally privileged. If you are not the intended recipient, or a person responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of any of the information contained in or attached to this transmission is STRICTLY PROHIBITED.  If you have received this transmission in error, please immediately notify the sender. Please destroy the original transmission and its attachments without reading or saving in any manner.

--
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/da002791-ef37-49aa-b974-243b4287bc81n%40googlegroups.com.

Sunday, August 15, 2021

[google-cloud-sql-discuss] Re: Consumo de Memória RAM em Dobro após atualização CloudSQL PostgreSQL

Hi,

Any news about this topic?

Em terça-feira, 10 de agosto de 2021 às 10:43:55 UTC-3, Leonardo Rocha escreveu:
Hi,

I will write the menssage in english.

The instance of Postgres, that usually uses 900MB of memory RAM, are using 1,8GB after do upgrade (maintance) this sunday. I tried manually restart the instance, but when i powered on it was already using 1,8GB again. The snapshot of the last mensage show this case.

Can we downgrade the version or what we can do?
Em terça-feira, 10 de agosto de 2021 às 08:50:09 UTC-3, delgad...@google.com escreveu:
Hi there,

In future messages please use English  as it is our primary language for Google Groups and our ability to help in a foreign language is limited.

Thank you for your understanding.

On Tuesday, August 10, 2021 at 1:47:32 PM UTC+2 victor...@intereast.se wrote:
Opa Leonardo,

Identificamos o mesmo problema por aqui apos a manutencao. O grafico quase exatamente igual ao seu, so mudando a escala.
Qual eh a frenquencia da mutencao de sua instancia?
Aqui a ultima tinha sido em 25 the abril entao foram quase 10 features entrando de vez e estamos tentando identificar qual ou quais podem estar causando isso.

So identificamos porque configuramos um alerta e por acaso, o overload ultrapassou ele. Eu chutaria que muitos devem ter tido o aumento no uso de memoria mas nao identificado ainda...

Agradeco por sua atencao.

Victor Correa

On Monday, August 9, 2021 at 3:10:42 PM UTC+2 Leonardo Rocha wrote:
Bom dia,

Após a atualização do CloudSQL, para PostgreSQL, houve aumento no consumo de memória RAM, sendo que após reiniciar a instancia, ela está consumindo o dobro de memória RAM, conforme print em anexo.

Somente eu estou com esse problema?

No aguardo.

--
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/472a610f-212e-4c2e-ac74-3d6872ae5289n%40googlegroups.com.

Saturday, August 14, 2021

[google-cloud-sql-discuss] Installing DB on Google Cloud


I wanted to install an open source DB like PostgreSQL on Google cloud. So I wonder i anyone have link to instructional resource on the topic.

--
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/b35dc10f-f39a-4afd-a7a7-bef866ea1b6cn%40googlegroups.com.

Friday, August 13, 2021

[google-cloud-sql-discuss] My cloud mysql server not stating. any one can help?

My cloud mysql server not stating. any one can help?

--
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/47aa5052-8af8-4647-8b4a-951e0075a782n%40googlegroups.com.

Tuesday, August 10, 2021

[google-cloud-sql-discuss] Is cloud sql having issues?

I use tcp/ip connections for my apps and VMs. My apps and VMs were working fine till this morning but they seem to have stopped working suddenly. Even the pgAdmin client on my desktop cant connect to the cloud sql db anymore!

anybody else having similar issues?

--
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/41f2652c-02c6-43ca-b18b-1ba19a39560bn%40googlegroups.com.

[google-cloud-sql-discuss] Re: Consumo de Memória RAM em Dobro após atualização CloudSQL PostgreSQL

Hi there,

Sorry, once the original question was in portuguese I thought it would be pertinent comment in portuguese also.

Anyway, what Leonardo reported and I found the same issue, is that after the maintenance update from update in the ClouldSQL, regarding PostgresSQL, that happend on 08 of August, there was a substantial increase in memory consume (Leonardo's image 01 and Victor's image 01).

Best regards,

Victor Correa

On Tuesday, August 10, 2021 at 1:50:09 PM UTC+2 delgad...@google.com wrote:
Hi there,

In future messages please use English  as it is our primary language for Google Groups and our ability to help in a foreign language is limited.

Thank you for your understanding.

On Tuesday, August 10, 2021 at 1:47:32 PM UTC+2 victor...@intereast.se wrote:
Opa Leonardo,

Identificamos o mesmo problema por aqui apos a manutencao. O grafico quase exatamente igual ao seu, so mudando a escala.
Qual eh a frenquencia da mutencao de sua instancia?
Aqui a ultima tinha sido em 25 the abril entao foram quase 10 features entrando de vez e estamos tentando identificar qual ou quais podem estar causando isso.

So identificamos porque configuramos um alerta e por acaso, o overload ultrapassou ele. Eu chutaria que muitos devem ter tido o aumento no uso de memoria mas nao identificado ainda...

Agradeco por sua atencao.

Victor Correa

On Monday, August 9, 2021 at 3:10:42 PM UTC+2 Leonardo Rocha wrote:
Bom dia,

Após a atualização do CloudSQL, para PostgreSQL, houve aumento no consumo de memória RAM, sendo que após reiniciar a instancia, ela está consumindo o dobro de memória RAM, conforme print em anexo.

Somente eu estou com esse problema?

No aguardo.

--
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/6e5b0238-ce6e-4f02-9591-a0718f86c214n%40googlegroups.com.

[google-cloud-sql-discuss] Re: Consumo de Memória RAM em Dobro após atualização CloudSQL PostgreSQL

Hi,

I will write the menssage in english.

The instance of Postgres, that usually uses 900MB of memory RAM, are using 1,8GB after do upgrade (maintance) this sunday. I tried manually restart the instance, but when i powered on it was already using 1,8GB again. The snapshot of the last mensage show this case.

Can we downgrade the version or what we can do?
Em terça-feira, 10 de agosto de 2021 às 08:50:09 UTC-3, delgad...@google.com escreveu:
Hi there,

In future messages please use English  as it is our primary language for Google Groups and our ability to help in a foreign language is limited.

Thank you for your understanding.

On Tuesday, August 10, 2021 at 1:47:32 PM UTC+2 victor...@intereast.se wrote:
Opa Leonardo,

Identificamos o mesmo problema por aqui apos a manutencao. O grafico quase exatamente igual ao seu, so mudando a escala.
Qual eh a frenquencia da mutencao de sua instancia?
Aqui a ultima tinha sido em 25 the abril entao foram quase 10 features entrando de vez e estamos tentando identificar qual ou quais podem estar causando isso.

So identificamos porque configuramos um alerta e por acaso, o overload ultrapassou ele. Eu chutaria que muitos devem ter tido o aumento no uso de memoria mas nao identificado ainda...

Agradeco por sua atencao.

Victor Correa

On Monday, August 9, 2021 at 3:10:42 PM UTC+2 Leonardo Rocha wrote:
Bom dia,

Após a atualização do CloudSQL, para PostgreSQL, houve aumento no consumo de memória RAM, sendo que após reiniciar a instancia, ela está consumindo o dobro de memória RAM, conforme print em anexo.

Somente eu estou com esse problema?

No aguardo.

--
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/107ccef7-306f-4919-be8b-7da282e0dc39n%40googlegroups.com.

[google-cloud-sql-discuss] Re: Consumo de Memória RAM em Dobro após atualização CloudSQL PostgreSQL

Hi there,

In future messages please use English  as it is our primary language for Google Groups and our ability to help in a foreign language is limited.

Thank you for your understanding.

On Tuesday, August 10, 2021 at 1:47:32 PM UTC+2 victor...@intereast.se wrote:
Opa Leonardo,

Identificamos o mesmo problema por aqui apos a manutencao. O grafico quase exatamente igual ao seu, so mudando a escala.
Qual eh a frenquencia da mutencao de sua instancia?
Aqui a ultima tinha sido em 25 the abril entao foram quase 10 features entrando de vez e estamos tentando identificar qual ou quais podem estar causando isso.

So identificamos porque configuramos um alerta e por acaso, o overload ultrapassou ele. Eu chutaria que muitos devem ter tido o aumento no uso de memoria mas nao identificado ainda...

Agradeco por sua atencao.

Victor Correa

On Monday, August 9, 2021 at 3:10:42 PM UTC+2 Leonardo Rocha wrote:
Bom dia,

Após a atualização do CloudSQL, para PostgreSQL, houve aumento no consumo de memória RAM, sendo que após reiniciar a instancia, ela está consumindo o dobro de memória RAM, conforme print em anexo.

Somente eu estou com esse problema?

No aguardo.

--
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/41f52907-52a5-457d-8512-62203c31ed19n%40googlegroups.com.

[google-cloud-sql-discuss] Re: Consumo de Memória RAM em Dobro após atualização CloudSQL PostgreSQL

Opa Leonardo,

Identificamos o mesmo problema por aqui apos a manutencao. O grafico quase exatamente igual ao seu, so mudando a escala.
Qual eh a frenquencia da mutencao de sua instancia?
Aqui a ultima tinha sido em 25 the abril entao foram quase 10 features entrando de vez e estamos tentando identificar qual ou quais podem estar causando isso.

So identificamos porque configuramos um alerta e por acaso, o overload ultrapassou ele. Eu chutaria que muitos devem ter tido o aumento no uso de memoria mas nao identificado ainda...

Agradeco por sua atencao.

Victor Correa

On Monday, August 9, 2021 at 3:10:42 PM UTC+2 Leonardo Rocha wrote:
Bom dia,

Após a atualização do CloudSQL, para PostgreSQL, houve aumento no consumo de memória RAM, sendo que após reiniciar a instancia, ela está consumindo o dobro de memória RAM, conforme print em anexo.

Somente eu estou com esse problema?

No aguardo.

--
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/145ae280-b7c3-4e06-8ec7-bf5eb0396bc8n%40googlegroups.com.

Sunday, August 8, 2021

[google-cloud-sql-discuss] Consumo de Memória RAM em Dobro após atualização CloudSQL PostgreSQL

Bom dia,

Após a atualização do CloudSQL, para PostgreSQL, houve aumento no consumo de memória RAM, sendo que após reiniciar a instancia, ela está consumindo o dobro de memória RAM, conforme print em anexo.

Somente eu estou com esse problema?

No aguardo.

--
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/6fd49173-b1e9-4a01-a179-cd2462d1fcfdn%40googlegroups.com.

Tuesday, August 3, 2021

[google-cloud-sql-discuss] Facturación

Buenas, podrian darme una mano para saber que podria hacer?
Habilite la opcion de Cloud SQL, sin embargo no lo utilice y actualmente tengo una factura de USD550 que quisiera reclamar y cancelar.
Desde ya muy agradecido.

--
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/8beac44e-e42f-4559-afcf-98267547080an%40googlegroups.com.