Tuesday, April 26, 2016

Re: [google-cloud-sql-discuss] Is it possibile to view in StackDriver logging all sql queries that runs on Cloud SQL second generation?

If you want to view all queries that run, you must set general_log=TRUE and log_output=TABLE following https://cloud.google.com/sql/docs/mysql-flags. The output is stored in the mysql.general_log table, and is in CSV format.

As CSV is inefficient and can massively increase restart times, we strongly recommend you keep this table small by frequently truncating it. If you need to preserve the contents use INSERT ... SELECT. See https://cloud.google.com/sql/docs/mysql-flags#tips-general-log

On Tue, Apr 26, 2016 at 12:14 AM, Amina <aminadavg@gmail.com> wrote:


--
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/c8507cfc-bccf-41c3-9be2-590a4a99d699%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
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/CAJZK_bZLaXx_Ux560UaM4dn_XuaDK8OoY_OhJ5dQMCu0_A0v6Q%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment