📣
TiDB Cloud Premium is now in public preview. Unlimited growth, instant elasticity, advanced security for enterprise workloads. Try it out →
​
Sign InStart for Free
AI
Developer
Best Practices
API
​
Sign InStart for Free

Limited SQL features on TiDB Cloud Dedicated

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

Statements

Placement and range management

StatementTiDB Cloud Dedicated
ALTER PLACEMENT POLICYSupported
CREATE PLACEMENT POLICYSupported
DROP PLACEMENT POLICYSupported
SHOW CREATE PLACEMENT POLICYSupported
SHOW PLACEMENTSupported
SHOW PLACEMENT FORSupported
SHOW PLACEMENT LABELSSupported
SHOW TABLE REGIONSSupported
SPLIT REGIONSupported

Resource groups

StatementTiDB Cloud Dedicated
ALTER RESOURCE GROUPSupported
CALIBRATE RESOURCENot supported
CREATE RESOURCE GROUPSupported
DROP RESOURCE GROUPSupported
SET RESOURCE GROUPSupported
SHOW CREATE RESOURCE GROUPSupported

Others

StatementTiDB Cloud Dedicated
BACKUPSupported
SHOW BACKUPSSupported
RESTORESupported
SHOW RESTORESSupported
ADMIN RESET TELEMETRY_IDSupported
ADMIN SHOW TELEMETRYNot supported 1
ADMIN SHOW SLOWSupported
ADMIN PLUGINS ENABLESupported
ADMIN PLUGINS DISABLESupported
ALTER INSTANCE RELOAD TLSSupported
LOAD DATA INFILESupports LOAD DATA LOCAL INFILE, and LOAD DATA INFILE from Amazon S3 or Google Cloud Storage
CHANGE DRAINERNot supported 2
CHANGE PUMPNot supported 2
FLASHBACK CLUSTERSupported
LOAD STATSSupported
SELECT ... INTO OUTFILENot supported 1
SET CONFIGNot supported 1
SHOW CONFIGNot supported 1
SHOW DRAINER STATUSNot supported 2
SHOW PLUGINSSupported
SHOW PUMP STATUSNot supported 2
SHUTDOWNNot supported 1
PLAN REPLAYERSupported

Functions and operators

Function and operatorTiDB Cloud Dedicated
SLEEPNo limitation

System tables

DatabaseTableTiDB Cloud Dedicated
information_schemaATTRIBUTESSupported
information_schemaCLUSTER_CONFIGNot supported 1
information_schemaCLUSTER_HARDWARENot supported 1
information_schemaCLUSTER_INFOSupported
information_schemaCLUSTER_LOADNot supported 1
information_schemaCLUSTER_LOGNot supported 1
information_schemaCLUSTER_SLOW_QUERYSupported
information_schemaCLUSTER_STATEMENTS_SUMMARYSupported
information_schemaCLUSTER_STATEMENTS_SUMMARY_EVICTEDSupported
information_schemaCLUSTER_STATEMENTS_SUMMARY_HISTORYSupported
information_schemaCLUSTER_SYSTEMINFONot supported 1
information_schemaINSPECTION_RESULTNot supported 1
information_schemaINSPECTION_RULESNot supported 1
information_schemaINSPECTION_SUMMARYNot supported 1
information_schemaMETRICS_SUMMARYNot supported 1
information_schemaMETRICS_SUMMARY_BY_LABELNot supported 1
information_schemaMETRICS_TABLESNot supported 1
information_schemaPLACEMENT_POLICIESSupported
information_schemaRESOURCE_GROUPSSupported
information_schemaSLOW_QUERYSupported
information_schemaSTATEMENTS_SUMMARYSupported
information_schemaSTATEMENTS_SUMMARY_EVICTEDSupported
information_schemaTIDB_HOT_REGIONSNot supported 1
information_schemaTIDB_HOT_REGIONS_HISTORYSupported
information_schemaTIDB_SERVERS_INFOSupported
information_schemaTIKV_REGION_PEERSSupported
information_schemaTIKV_REGION_STATUSSupported
information_schemaTIKV_STORE_STATUSSupported
performance_schemapd_profile_allocsNot supported 1
performance_schemapd_profile_blockNot supported 1
performance_schemapd_profile_cpuNot supported 1
performance_schemapd_profile_goroutinesNot supported 1
performance_schemapd_profile_memoryNot supported 1
performance_schemapd_profile_mutexNot supported 1
performance_schematidb_profile_allocsNot supported 1
performance_schematidb_profile_blockNot supported 1
performance_schematidb_profile_cpuNot supported 1
performance_schematidb_profile_goroutinesNot supported 1
performance_schematidb_profile_memoryNot supported 1
performance_schematidb_profile_mutexNot supported 1
performance_schematikv_profile_cpuNot supported 1
mysqlexpr_pushdown_blacklistNot supported 1
mysqlgc_delete_rangeNot supported 1
mysqlgc_delete_range_doneNot supported 1
mysqlopt_rule_blacklistNot supported 1
mysqltidbNot supported 1

System variables

VariableTiDB Cloud Dedicated
datadirNo limitation
interactive_timeoutNo limitation
max_allowed_packetNo limitation
plugin_dirNo limitation
plugin_loadNo limitation
require_secure_transportNot supported 3
skip_name_resolveNo limitation
sql_log_binNo limitation
tidb_analyze_skip_column_typesNo limitation
tidb_cdc_write_sourceNo limitation
tidb_check_mb4_value_in_utf8Not supported 1
tidb_configNot supported 1
tidb_ddl_disk_quotaNo limitation
tidb_ddl_enable_fast_reorgNo limitation
tidb_ddl_error_count_limitNo limitation
tidb_ddl_flashback_concurrencyNo limitation
tidb_ddl_reorg_batch_sizeNo limitation
tidb_ddl_reorg_priorityNo limitation
tidb_ddl_reorg_worker_cntNo limitation
tidb_dml_typeNo limitation
tidb_enable_1pcNo limitation
tidb_enable_async_commitNo limitation
tidb_enable_auto_analyzeNo limitation
tidb_enable_collect_execution_infoNot supported 1
tidb_enable_ddlNo limitation
tidb_enable_gc_aware_memory_trackNo limitation
tidb_enable_gogc_tunerNo limitation
tidb_enable_local_txnNo limitation
tidb_enable_resource_controlNo limitation
tidb_enable_slow_logNot supported 1
tidb_enable_stmt_summaryNo limitation
tidb_enable_telemetryNot supported 1
tidb_enable_top_sqlNo limitation
tidb_enable_tso_follower_proxyNo limitation
tidb_expensive_query_time_thresholdNot supported 1
tidb_force_priorityNot supported 1
tidb_gc_concurrencyNo limitation
tidb_gc_enableNo limitation
tidb_gc_max_wait_timeNo limitation
tidb_gc_run_intervalNo limitation
tidb_gc_scan_lock_modeNo limitation
tidb_general_logNot supported 1
tidb_generate_binary_planNo limitation
tidb_gogc_tuner_thresholdNo limitation
tidb_guarantee_linearizabilityNo limitation
tidb_isolation_read_enginesNo limitation
tidb_log_file_max_daysNo limitation
tidb_memory_usage_alarm_ratioNot supported 1
tidb_metric_query_range_durationNot supported 1
tidb_metric_query_stepNot supported 1
tidb_opt_write_row_idNot supported 1
tidb_placement_modeNo limitation
tidb_pprof_sql_cpuNot supported 1
tidb_record_plan_in_slow_logNot supported 1
tidb_redact_logNot supported 1
tidb_replica_readNo limitation
tidb_restricted_read_onlyNot supported 1
tidb_row_format_versionNot supported 1
tidb_scatter_regionNo limitation
tidb_server_memory_limitNo limitation
tidb_server_memory_limit_gc_triggerNo limitation
tidb_server_memory_limit_sess_min_sizeNo limitation
tidb_simplified_metricsNo limitation
tidb_slow_query_fileNot supported 1
tidb_slow_log_thresholdNot supported 1
tidb_slow_txn_log_thresholdNot supported 1
tidb_stats_load_sync_waitNo limitation
tidb_stmt_summary_history_sizeNo limitation
tidb_stmt_summary_internal_queryNo limitation
tidb_stmt_summary_max_sql_lengthNo limitation
tidb_stmt_summary_max_stmt_countNo limitation
tidb_stmt_summary_refresh_intervalNo limitation
tidb_sysproc_scan_concurrencyNo limitation
tidb_top_sql_max_meta_countNot supported 1
tidb_top_sql_max_time_series_countNot supported 1
tidb_tso_client_batch_max_wait_timeNo limitation
tidb_ttl_delete_batch_sizeNo limitation
tidb_ttl_delete_rate_limitNo limitation
tidb_ttl_delete_worker_countNo limitation
tidb_ttl_job_schedule_window_end_timeNo limitation
tidb_ttl_job_schedule_window_start_timeNo limitation
tidb_ttl_running_tasksNo limitation
tidb_ttl_scan_batch_sizeNo limitation
tidb_ttl_scan_worker_countNo limitation
tidb_txn_modeNo limitation
tidb_wait_split_region_finishNo limitation
tidb_wait_split_region_timeoutNo limitation
txn_scopeNo limitation
validate_password.enableNo limitation
validate_password.lengthNo limitation
validate_password.mixed_case_countNo limitation
validate_password.number_countNo limitation
validate_password.policyNo limitation
validate_password.special_char_countNo limitation
wait_timeoutNo limitation
  1. The feature is unavailable in Security Enhanced Mode (SEM).↩
  2. Drainer and Pump are not supported on TiDB Cloud.↩
  3. Not supported. Enabling require_secure_transport for TiDB Cloud Dedicated clusters will result in SQL client connection failures.↩

Was this page helpful?