Kode yang tidak dioptimasi di website dapat menyebabkan Anda mencapai limit max_user_connections. Untuk mengatasi ini, Anda dapat menghentikan koneksi secara manual dengan cara: Show
Kedua opsi di atas hanya dapat mengatasi error untuk sementara. Untuk menghilangkan error secara permanen, optimalkan kueri database atau upgrade paket Anda. Cloud SQL for MySQL is a fully-managed database service that makes it easy to set-up, maintain, manage and administer your relational MySQL databases on Cloud Platform. The Cloud SQL for MySQL connector allows you to access data from Cloud SQL for MySQL databases within Looker Studio. Supported versionsThe Cloud SQL for MySQL connector was tested on the following MySQL versions:
If you experience issues using a supported version, please let us know in the Looker Studio Help Community. You can add and vote on feature requests here. How to connect to Cloud SQL for MySQLA Looker Studio data source can connect to a single Cloud SQL for MySQL database table, or to a custom query you provide. To connect
In a moment, the data source fields list page appears. In the upper right, click CREATE REPORT or EXPLORE to start visualizing your data. NotesFind your instance connection nameThe instance connection name identifies your instance on Google Cloud. You can get it from the Cloud console, or by using the command line. Use the console
Use the command lineTo find the connection name using the Cloud command line interface, use the following command:
PermissionsYou must have at least Network connectivityThe Cloud SQL for MySQL connector supports connections to Cloud SQL for MySQL instances with public IP connectivity and private IP connectivity. You must configure public IP connectivity or private IP connectivity for your Cloud SQL for MySQL instance before using the Cloud SQL for MySQL connector. To allow Looker Studio to access data in Cloud SQL and make queries against this data over a private connection, select the Enable private path option under Google Cloud services authorization in your Cloud SQL for MySQL instance settings. Learn more.
Data typesLooker Studio maps your database's native data types to a unified set of data types. If Looker Studio encounters a column in your table or query of an unsupported type, it will not create a field for that column. |