TiDBTiDB Docs Dash 2024

Jan 9 - Jan 12 (UTC)
Join us to improve docs and win a prize!
Sign InTry Free

Limited SQL features on TiDB Cloud

TiDB Cloud works with almost all workloads that TiDB supports, but there are some feature differences between TiDB Self-Hosted and TiDB Dedicated/Serverless. This document describes the limitations of SQL features on TiDB Cloud. We are constantly filling in the feature gaps between TiDB Self-Hosted and TiDB Dedicated/Serverless. If you require these features or capabilities in the gap, contact us for a feature request.

Statements

Placement and range management

StatementTiDB DedicatedTiDB Serverless
ALTER PLACEMENT POLICYSupportedNot supported 1
CREATE PLACEMENT POLICYSupportedNot supported 1
DROP PLACEMENT POLICYSupportedNot supported 1
SHOW CREATE PLACEMENT POLICYSupportedNot supported 1
SHOW PLACEMENTSupportedNot supported 1
SHOW PLACEMENT FORSupportedNot supported 1
SHOW PLACEMENT LABELSSupportedNot supported 1
SHOW TABLE REGIONSSupportedNot supported 1
SPLIT REGIONSupportedNot supported 1

Resource groups

StatementTiDB DedicatedTiDB Serverless
ALTER RESOURCE GROUPSupportedNot supported 2
CALIBRATE RESOURCENot supportedNot supported 2
CREATE RESOURCE GROUPSupportedNot supported 2
DROP RESOURCE GROUPSupportedNot supported 2
SET RESOURCE GROUPSupportedNot supported 2
SHOW CREATE RESOURCE GROUPSupportedNot supported 2

Others

StatementTiDB DedicatedTiDB Serverless
BACKUPSupportedNot supported 3
SHOW BACKUPSSupportedNot supported 3
RESTORESupportedNot supported 3
SHOW RESTORESSupportedNot supported 3
ADMIN RESET TELEMETRY_IDSupportedTelemetry is not supported on TiDB Serverless.
ADMIN SHOW TELEMETRYNot supported 4Not supported 4
ADMIN SHOW SLOWSupportedNot supported 5
ADMIN PLUGINS ENABLESupportedNot supported 8
ADMIN PLUGINS DISABLESupportedNot supported 8
ALTER INSTANCE RELOAD TLSSupportedTiDB Serverless automatically refreshes the TLS certificate.
LOAD DATA INFILEOnly supports LOAD DATA LOCAL INFILEOnly supports LOAD DATA LOCAL INFILE
CHANGE DRAINERNot supported 7Not supported 7
CHANGE PUMPNot supported 7Not supported 7
FLASHBACK CLUSTER TO TIMESTAMPSupportedNot supported 3
LOAD STATSSupportedNot supported
SELECT ... INTO OUTFILENot supported 4Not supported 4
SET CONFIGNot supported 4Not supported 4
SHOW CONFIGNot supported 4Not supported 4
SHOW DRAINER STATUSNot supported 7Not supported 7
SHOW PLUGINSSupportedNot supported 8
SHOW PUMP STATUSNot supported 7Not supported 7
SHUTDOWNNot supported 4Not supported 4
CREATE TABLE ... AUTO_ID_CACHESupportedNot supported 12

Functions and operators

Function and operatorTiDB DedicatedTiDB Serverless
SLEEPNo LimitationThe SLEEP() function has a limitation wherein it can only support a maximum sleep time of 300 seconds.

System tables

DatabaseTableTiDB DedicatedTiDB Serverless
information_schemaATTRIBUTESSupportedNot supported 1
information_schemaCLUSTER_CONFIGNot supported 4Not supported 4
information_schemaCLUSTER_HARDWARENot supported 4Not supported 4
information_schemaCLUSTER_INFOSupportedNot supported 1
information_schemaCLUSTER_LOADNot supported 4Not supported 4
information_schemaCLUSTER_LOGNot supported 4Not supported 4
information_schemaCLUSTER_SLOW_QUERYSupportedNot supported 5
information_schemaCLUSTER_STATEMENTS_SUMMARYSupportedNot supported 6
information_schemaCLUSTER_STATEMENTS_SUMMARY_EVICTEDSupportedNot supported 6
information_schemaCLUSTER_STATEMENTS_SUMMARY_HISTORYSupportedNot supported 6
information_schemaCLUSTER_SYSTEMINFONot supported 4Not supported 4
information_schemaINSPECTION_RESULTNot supported 4Not supported 4
information_schemaINSPECTION_RULESNot supported 4Not supported 4
information_schemaINSPECTION_SUMMARYNot supported 4Not supported 4
information_schemaMETRICS_SUMMARYNot supported 4Not supported 4
information_schemaMETRICS_SUMMARY_BY_LABELNot supported 4Not supported 4
information_schemaMETRICS_TABLESNot supported 4Not supported 4
information_schemaPLACEMENT_POLICIESSupportedNot supported 1
information_schemaRESOURCE_GROUPSSupportedNot supported 2
information_schemaSLOW_QUERYSupportedNot supported 5
information_schemaSTATEMENTS_SUMMARYSupportedNot supported 6
information_schemaSTATEMENTS_SUMMARY_EVICTEDSupportedNot supported 6
information_schemaSTATEMENTS_SUMMARY_HISTORYSupportedNot supported 6
information_schemaTIDB_HOT_REGIONSNot supported 4Not supported 4
information_schemaTIDB_HOT_REGIONS_HISTORYSupportedNot supported 1
information_schemaTIDB_SERVERS_INFOSupportedNot supported 1
information_schemaTIFLASH_SEGMENTSSupportedNot supported 1
information_schemaTIFLASH_TABLESSupportedNot supported 1
information_schemaTIKV_REGION_PEERSSupportedNot supported 1
information_schemaTIKV_REGION_STATUSSupportedNot supported 1
information_schemaTIKV_STORE_STATUSSupportedNot supported 1
performance_schemapd_profile_allocsNot supported 4Not supported 4
performance_schemapd_profile_blockNot supported 4Not supported 4
performance_schemapd_profile_cpuNot supported 4Not supported 4
performance_schemapd_profile_goroutinesNot supported 4Not supported 4
performance_schemapd_profile_memoryNot supported 4Not supported 4
performance_schemapd_profile_mutexNot supported 4Not supported 4
performance_schematidb_profile_allocsNot supported 4Not supported 4
performance_schematidb_profile_blockNot supported 4Not supported 4
performance_schematidb_profile_cpuNot supported 4Not supported 4
performance_schematidb_profile_goroutinesNot supported 4Not supported 4
performance_schematidb_profile_memoryNot supported 4Not supported 4
performance_schematidb_profile_mutexNot supported 4Not supported 4
performance_schematikv_profile_cpuNot supported 4Not supported 4
mysqlexpr_pushdown_blacklistNot supported 4Not supported 4
mysqlgc_delete_rangeNot supported 4Not supported 4
mysqlgc_delete_range_doneNot supported 4Not supported 4
mysqlopt_rule_blacklistNot supported 4Not supported 4
mysqltidbNot supported 4Not supported 4
mysqltidb_ttl_job_historySupportedNot supported 9
mysqltidb_ttl_table_statusSupportedNot supported 9
mysqltidb_ttl_taskSupportedNot supported 9

System variables

VariableTiDB DedicatedTiDB Serverless
datadirNo limitationNot supported 1
interactive_timeoutNo limitationRead-only 11
max_allowed_packetNo limitationRead-only 11
plugin_dirNo limitationNot supported 8
plugin_loadNo limitationNot supported 8
require_secure_transportNot supported 13Read-only 11
skip_name_resolveNo limitationRead-only 11
sql_log_binNo limitationRead-only 11
tidb_cdc_write_sourceNo limitationRead-only 11
tidb_check_mb4_value_in_utf8Not supported 4Not supported 4
tidb_configNot supported 4Not supported 4
tidb_ddl_disk_quotaNo limitationRead-only 11
tidb_ddl_enable_fast_reorgNo limitationRead-only 11
tidb_ddl_error_count_limitNo limitationRead-only 11
tidb_ddl_flashback_concurrencyNo limitationRead-only 11
tidb_ddl_reorg_batch_sizeNo limitationRead-only 11
tidb_ddl_reorg_priorityNo limitationRead-only 11
tidb_ddl_reorg_worker_cntNo limitationRead-only 11
tidb_enable_1pcNo limitationRead-only 11
tidb_enable_async_commitNo limitationRead-only 11
tidb_enable_auto_analyzeNo limitationRead-only 11
tidb_enable_collect_execution_infoNot supported 4Not supported 4
tidb_enable_ddlNo limitationRead-only 11
tidb_enable_gc_aware_memory_trackNo limitationRead-only 11
tidb_enable_gogc_tunerNo limitationRead-only 11
tidb_enable_local_txnNo limitationRead-only 11
tidb_enable_resource_controlNo limitationRead-only 11
tidb_enable_slow_logNot supported 4Not supported 4
tidb_enable_stmt_summaryNo limitationRead-only 11
tidb_enable_telemetryNot supported 4Not supported 4
tidb_enable_top_sqlNo limitationRead-only 11
tidb_enable_tso_follower_proxyNo limitationRead-only 11
tidb_expensive_query_time_thresholdNot supported 4Not supported 4
tidb_force_priorityNot supported 4Not supported 4
tidb_gc_concurrencyNo limitationRead-only 11
tidb_gc_enableNo limitationRead-only 11
tidb_gc_life_timeNo limitationRead-only 11
tidb_gc_max_wait_timeNo limitationRead-only 11
tidb_gc_run_intervalNo limitationRead-only 11
tidb_gc_scan_lock_modeNo limitationRead-only 11
tidb_general_logNot supported 4Not supported 4
tidb_generate_binary_planNo limitationRead-only 11
tidb_gogc_tuner_thresholdNo limitationRead-only 11
tidb_guarantee_linearizabilityNo limitationRead-only 11
tidb_isolation_read_enginesNo limitationRead-only 11
tidb_log_file_max_daysNo limitationRead-only 11
tidb_memory_usage_alarm_ratioNot supported 4Not supported 4
tidb_metric_query_range_durationNot supported 4Not supported 4
tidb_metric_query_stepNot supported 4Not supported 4
tidb_opt_write_row_idNot supported 4Not supported 4
tidb_placement_modeNo limitationRead-only 11
tidb_pprof_sql_cpuNot supported 4Not supported 4
tidb_record_plan_in_slow_logNot supported 4Not supported 4
tidb_redact_logNot supported 4Not supported 4
tidb_restricted_read_onlyNot supported 4Not supported 4
tidb_row_format_versionNot supported 4Not supported 4
tidb_scatter_regionNo limitationRead-only 11
tidb_server_memory_limitNo limitationRead-only 11
tidb_server_memory_limit_gc_triggerNo limitationRead-only 11
tidb_server_memory_limit_sess_min_sizeNo limitationRead-only 11
tidb_simplified_metricsNo limitationRead-only 11
tidb_slow_query_fileNot supported 4Not supported 4
tidb_slow_log_thresholdNot supported 4Not supported 4
tidb_slow_txn_log_thresholdNot supported 4Not supported 4
tidb_stats_load_sync_waitNo limitationRead-only 11
tidb_stmt_summary_history_sizeNo limitationRead-only 11
tidb_stmt_summary_internal_queryNo limitationRead-only 11
tidb_stmt_summary_max_sql_lengthNo limitationRead-only 11
tidb_stmt_summary_max_stmt_countNo limitationRead-only 11
tidb_stmt_summary_refresh_intervalNo limitationRead-only 11
tidb_sysproc_scan_concurrencyNo limitationRead-only 11
tidb_top_sql_max_meta_countNot supported 4Not supported 4
tidb_top_sql_max_time_series_countNot supported 4Not supported 4
tidb_tso_client_batch_max_wait_timeNo limitationRead-only 11
tidb_ttl_delete_batch_sizeNo limitationRead-only 9
tidb_ttl_delete_rate_limitNo limitationRead-only 9
tidb_ttl_delete_worker_countNo limitationRead-only 9
tidb_ttl_job_enableNo limitationRead-only 9
tidb_ttl_job_schedule_window_end_timeNo limitationRead-only 9
tidb_ttl_job_schedule_window_start_timeNo limitationRead-only 9
tidb_ttl_running_tasksNo limitationRead-only 9
tidb_ttl_scan_batch_sizeNo limitationRead-only 9
tidb_ttl_scan_worker_countNo limitationRead-only 9
tidb_txn_modeNo limitationRead-only 11
tidb_wait_split_region_finishNo limitationRead-only 11
tidb_wait_split_region_timeoutNo limitationRead-only 11
txn_scopeNo limitationRead-only 11
validate_password.enableNo limitationAlways enabled 10
validate_password.lengthNo limitationAt least 8 10
validate_password.mixed_case_countNo limitationAt least 1 10
validate_password.number_countNo limitationAt least 1 10
validate_password.policyNo limitationCan only be MEDIUM or STRONG 10
validate_password.special_char_countNo limitationAt least 1 10
wait_timeoutNo limitationRead-only 11

  1. Configuring data placement is not supported on TiDB Serverless.
  2. Configuring resource groups is not supported on TiDB Serverless.
  3. Customizing cache size using AUTO_ID_CACHE is temporarily unavailable on TiDB Serverless.
  4. The feature is unavailable in Security Enhanced Mode (SEM).
  5. Drainer and Pump are not supported on TiDB Cloud.
  6. Plugin is not supported on TiDB Serverless.
  7. To perform Back up and Restore operations on TiDB Serverless, you can use the TiDB Cloud console instead.
  8. To track Slow Query on TiDB Serverless, you can use the TiDB Cloud console instead.
  9. Time to live (TTL) is currently unavailable on TiDB Serverless.
  10. To perform Statement Analysis on TiDB Serverless, you can use the TiDB Cloud console instead.
  11. The variable is read-only on TiDB Serverless.
  12. TiDB Serverless enforces strong password policy.
  13. Not supported. Enabling require_secure_transport for TiDB Dedicated clusters will result in SQL client connection failures.

Was this page helpful?

Download PDFRequest docs changesAsk questions on Discord
Playground
New
One-stop & interactive experience of TiDB's capabilities WITHOUT registration.
Products
TiDB
TiDB Dedicated
TiDB Serverless
Pricing
Get Demo
Get Started
© 2024 PingCAP. All Rights Reserved.
Privacy Policy.