where is the cloudsql.googleapis.com/mysql-general.log

44 views
Skip to first unread message

Zhao Ximing

unread,
Mar 17, 2022, 12:14:29 PM3/17/22
to Google Cloud SQL discuss
Hi,

We have configured the cloud SQL instance tag 

log_out FILE
slow_query_log on
general_log on

It is promised in this [document](https://cloud.google.com/sql/docs/mysql/logging) that there should be a file "cloudsql.googleapis.com/mysql-general.log" that could be found in the log explorer that should record all queries, but we can't find it!

loreasanchez

unread,
Mar 17, 2022, 5:55:17 PM3/17/22
to Google Cloud SQL discuss

Please be sure your database has the correct flags configuration. In this page you will find how to see if the flags were applied correctly by checking the Current values of the database flags and Determine what database flags have been set for an instance. Once confirming the flags are correct, you might want to check the Storing, viewing, and managing logs.

I also want to mention that the flag `log_out` should be `log_output`. Please check all the configuration is done properly and correct the typo and provide more information according to this documentation, please.

Reply all
Reply to author
Forward
0 new messages