Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
MySQL | PostgreSQL | SQL Server
Halaman ini menjelaskan cara mengelola jumlah tabel sementara. Pemberi rekomendasi ini disebut Mengonfigurasi ulang setelan tabel sementara.
Setiap hari, pemberi rekomendasi ini menganalisis jumlah tabel sementara yang dibuat di disk dibandingkan dengan jumlah total tabel sementara. Jika jumlah tabel sementara yang dibuat di disk lebih dari 20% dari total jumlah tabel, pemberi rekomendasi ini akan menyarankan Anda untuk melakukan salah satu hal berikut:
Tingkatkan nilai flag tmp_table_size atau flag
max_heap_table_size, atau kedua flag.
Jika nilai max_heap_tmp_table_size dan tmp_table_size tidak sama,
maka tingkatkan nilai yang lebih kecil agar sama dengan nilai yang lebih besar.
Jika nilai max_heap_tmp_table_size dan tmp_table_size sama,
tingkatkan keduanya ke nilai yang lebih besar.
Untuk mengetahui informasi selengkapnya tentang cara meningkatkan nilai tmp_table_size, lihat
tmp_table_size.
Harga
Pemberi rekomendasi Mengonfigurasi ulang setelan tabel sementara berada dalam Tingkat harga pemberi rekomendasiStandar.
GET https://recommender.googleapis.com/v1/projects/PROJECT_ID/locations/LOCATION/recommenders/google.cloudsql.instance.PerformanceRecommender/recommendations
Ganti kode berikut:
PROJECT_ID: project ID Anda
LOCATION: region tempat instance Anda berada, seperti us-central1
Lihat insight dan rekomendasi mendetail
Untuk melihat insight dan rekomendasi mendetail, ikuti langkah-langkah berikut:
Konsol
Lakukan salah satu hal berikut:
Di halaman Rekomendasi Performa, klik kartu Rekomendasi performa, lalu klik Konfigurasi ulang setelan tabel sementara.
Panel rekomendasi akan muncul, yang berisi insight dan rekomendasi mendetail untuk instance tersebut.
Di halaman Instance, klik Konfigurasi ulang setelan tabel sementara. Daftar instance hanya menampilkan instance yang rekomendasi berlaku untuknya.
LOCATION: region tempat instance Anda berada, seperti
us-central1
INSIGHT_SUBTYPE: tetapkan parameter ini ke salah satu opsi berikut:
MYSQL_HIGH_NUMBER_OF_TMP_TABLE_ON_DISK_TMP_TABLE: menampilkan
insight untuk jumlah total tabel sementara di disk untuk instance Anda
MYSQL_HIGH_NUMBER_OF_TMP_TABLE_ON_DISK_MAX_HEAP: menampilkan
insight untuk jumlah total tabel sementara yang dibuat pengguna
di disk untuk instance Anda
GET https://recommender.googleapis.com/v1/projects/PROJECT_ID/locations/LOCATION/insightTypes/google.cloudsql.instance.PerformanceInsight/insights
Ganti kode berikut:
PROJECT_ID: project ID Anda
LOCATION: region tempat instance Anda berada, seperti us-central1
Menerapkan rekomendasi
Untuk menerapkan rekomendasi ini, lakukan salah satu hal berikut:
Jika nilai untuk tandamax_heap_tmp_table_size dan tmp_table_size tidak sama, tingkatkan nilai yang lebih kecil agar sama dengan nilai yang lebih besar.
Jika nilai untuk flag max_heap_tmp_table_size dan tmp_table_size sama, tingkatkan keduanya ke nilai yang lebih besar.
[[["Mudah dipahami","easyToUnderstand","thumb-up"],["Memecahkan masalah saya","solvedMyProblem","thumb-up"],["Lainnya","otherUp","thumb-up"]],[["Sulit dipahami","hardToUnderstand","thumb-down"],["Informasi atau kode contoh salah","incorrectInformationOrSampleCode","thumb-down"],["Informasi/contoh yang saya butuhkan tidak ada","missingTheInformationSamplesINeed","thumb-down"],["Masalah terjemahan","translationIssue","thumb-down"],["Lainnya","otherDown","thumb-down"]],["Terakhir diperbarui pada 2025-09-04 UTC."],[],[],null,["# Reconfigure temporary table settings\n\n\u003cbr /\u003e\n\nMySQL \\| PostgreSQL \\| SQL Server\n\n\u003cbr /\u003e\n\n|\n| **Preview**\n|\n|\n| This feature is subject to the \"Pre-GA Offerings Terms\" in the General Service Terms section\n| of the [Service Specific Terms](/terms/service-terms#1).\n|\n| You can process personal data for this feature as outlined in the\n| [Cloud Data Processing\n| Addendum](/terms/data-processing-addendum), subject to the obligations and restrictions described in the agreement under\n| which you access Google Cloud.\n|\n| Pre-GA features are available \"as is\" and might have limited support.\n|\n| For more information, see the\n| [launch stage descriptions](/products#product-launch-stages).\n\nThis page describes how to manage the number of temporary tables. This\n[recommender](/recommender/docs/recommenders) is called **Reconfigure temp table\nsettings**.\n\nEvery day, this recommender analyzes the number of temporary\ntables created on disk compared to the total number of temporary tables. If the\nnumber of temporary tables created on disk is more than 20% of the total\nnumber of tables, then this recommender advises you to do one of the following:\n\n- Increase the value of either the `tmp_table_size` flag or the\n `max_heap_table_size` flag, or both flags.\n\n- If the values for `max_heap_tmp_table_size` and `tmp_table_size` aren't equal,\n then increase the smaller value to match the larger value.\n\n- If the values for `max_heap_tmp_table_size` and `tmp_table_size` are the same,\n increase both of them to a larger value.\n\nFor more information on increasing the value of `tmp_table_size`, see\n[`tmp_table_size`](/sql/docs/mysql/flags#mysql-t).\n\nPricing\n-------\n\nThe **Reconfigure temp table settings** recommender is in the *Standard*\n[Recommender pricing tier](/recommender/pricing).\n\nBefore you begin\n----------------\n\n[Enable the Recommender API](/recommender/docs/enabling).\n\n### Required roles and permissions\n\nTo get the permissions to view and work with insights and recommendations,\nensure that you have the required [Identity and Access Management (IAM) roles](/sql/docs/mysql/project-access-control#roles).\n\nFor more information about IAM roles, see [IAM basic and predefined roles reference](/iam/docs/understanding-roles) and [Manage access to projects, folders, and organizations](/iam/docs/granting-changing-revoking-access).\n\n\u003cbr /\u003e\n\nList the recommendations\n------------------------\n\nTo list the recommendations, follow these steps: \n\n### Console\n\nTo list recommendations about instance performance, follow these steps:\n\n1. Go to the **Cloud SQL Instances** page.\n\n[Go to Cloud SQL Instances](https://console.cloud.google.com/sql/instances)\n\n1. On the **Improve instance health by investigating issues and acting on\n recommendations** banner, click **Expand Details** .\n\nAlternatively, follow these steps:\n\n1. Go to the **Recommendation Hub** . See also [Find and apply recommendations with the Recommendations](/recommender/docs/recommendation-hub/identify-configuration-problems).\n\n [Go to the Recommendation Hub](https://console.cloud.google.com/home/recommendations/)\n2. In the **All recommendations** card, click **Performance** .\n\n### gcloud\n\nRun the [`gcloud recommender recommendations list`](/sdk/gcloud/reference/recommender/recommendations/list) command as follows: \n\n```\ngcloud recommender recommendations list \\\n--project=PROJECT_ID \\\n--location=LOCATION \\\n--recommender=google.cloudsql.instance.PerformanceRecommender \\\n--filter=recommenderSubtype=MYSQL_RECONFIG_TMP_TABLES\n```\n\nReplace the following:\n\n- \u003cvar translate=\"no\"\u003ePROJECT_ID\u003c/var\u003e: your project ID\n- \u003cvar translate=\"no\"\u003eLOCATION\u003c/var\u003e: a region where your instances are located, such as `us-central1`\n\n### API\n\nCall the [`recommendations.list`](/recommender/docs/reference/rest/v1/projects.locations.recommenders.recommendations/list) method as follows: \n\n```\nGET https://recommender.googleapis.com/v1/projects/PROJECT_ID/locations/LOCATION/recommenders/google.cloudsql.instance.PerformanceRecommender/recommendations\n```\n\nReplace the following:\n\n- \u003cvar translate=\"no\"\u003ePROJECT_ID\u003c/var\u003e: your project ID\n- \u003cvar translate=\"no\"\u003eLOCATION\u003c/var\u003e: a region where your instances are located, such as `us-central1`\n\nView insights and detailed recommendations\n------------------------------------------\n\nTo view insights and detailed recommendations, follow these steps: \n\n### Console\n\nDo one of the following:\n\n- On the **Performance Recommendations** page, click the **Performance\n recommendations** card and then click **Reconfigure temp table settings**.\n The recommendation panel appears, which contains insights and detailed\n recommendations for the instance.\n\n- On the **Instances** page, click **Reconfigure temp table settings**. The\n list of instances displays only those instances for which the\n recommendation applies.\n\n### gcloud\n\nRun the [`gcloud recommender insights list`](/sdk/gcloud/reference/recommender/insights/list) command as follows: \n\n```\n\ngcloud recommender insights list \\\n--project=PROJECT_ID \\\n--location=LOCATION \\\n--insight-type=google.cloudsql.instance.PerformanceInsight \\\n--filter=insightSubtype=INSIGHT_SUBTYPE\n\n```\n\nReplace the following:\n\n- \u003cvar translate=\"no\"\u003ePROJECT_ID\u003c/var\u003e: your project ID\n- \u003cvar translate=\"no\"\u003eLOCATION\u003c/var\u003e: a region where your instances are located, such as `us-central1`\n- \u003cvar translate=\"no\"\u003eINSIGHT_SUBTYPE\u003c/var\u003e: set this parameter to one of the following:\n - `MYSQL_HIGH_NUMBER_OF_TMP_TABLE_ON_DISK_TMP_TABLE`: display insights for the total number of temporary tables on disk for your instance\n - `MYSQL_HIGH_NUMBER_OF_TMP_TABLE_ON_DISK_MAX_HEAP`: display insights for the total number of user-created temporary tables on disk for your instance\n\n### API\n\nCall the [`insights.list`](/recommender/docs/reference/rest/v1/projects.locations.insightTypes.insights/list) method as follows: \n\n```\n\nGET https://recommender.googleapis.com/v1/projects/PROJECT_ID/locations/LOCATION/insightTypes/google.cloudsql.instance.PerformanceInsight/insights\n\n```\n\nReplace the following:\n\n- \u003cvar translate=\"no\"\u003ePROJECT_ID\u003c/var\u003e: your project ID\n- \u003cvar translate=\"no\"\u003eLOCATION\u003c/var\u003e: a region where your instances are located, such as `us-central1`\n\nApply the recommendation\n------------------------\n\nTo implement this recommendation, do one of the following:\n\n- If the values for the`max_heap_tmp_table_size` and `tmp_table_size` flags are\n not equal, then increase the smaller value to match the larger value.\n\n- If the values for the`max_heap_tmp_table_size` and `tmp_table_size` flags are\n the same, increase both of them to larger values.\n\n| **Note:** Increasing `tmp_table_size` and `max_heap_tmp_table_size` requires more memory. After increasing these flags, monitor the memory usage.\n\nWhat's next\n-----------\n\n- [Google Cloud recommenders](/recommender/docs/recommenders)"]]
