tencent cloud

Feedback

Use Limits

Last updated: 2022-10-21 15:06:30

    Feature Limits

    • Custom functions, events, and tablespaces are not supported
    • Views, stored procedures, triggers, and cursors are not supported
    • Foreign keys and self-built partitions are not supported
    • Compound statements such as BEGIN END,and LOOP are not supported
    • SQL syntax related to master/slave sync is not supported

    Limits on small syntax

    DDL

    • CREATE TABLE ... SELECT is not supported
    • CREATE TEMPORARY TABLE is not supported
    • CREATE/DROP/ALTER SERVER/LOGFILE GROUP are not supported
    • ALTER is not supported for renaming shardkey, but it can be used to change the type

    DML

    • SELECT INTO OUTFILE/INTO DUMPFILE/INTO var_name are not supported
    • query_expression_options is not supported, such as HIGH_PRIORITY/STRAIGHT_JOIN/SQL_SMALL_RESULT/SQL_BIG_RESULT/SQL_BUFFER_RESULT/SQL_CACHE/SQL_NO_CACHE/SQL_CALC_FOUND_ROWS
    • INSERT/REPLACE without column name are not supported
    • ORDER BY/LIMIT cannot be used for global DELETE/UPDATE (Version greater than or equal to 1.14.4 can be supported)
    • UPDATE/DELETE without WHERE condition are not supported
    • LOAD DATA/XML are not supported
    • DELAYED/LOW_PRIORITY cannot be used in SQL statements
    • INSERT ... SELECT is not supported (Version greater than or equal to 1.14.4 can be supported)
    • References and operations on variables in SQL are not supported, such as SET @c=1, @d=@c+1; SELECT @c, @d
    • index_hint is not supported
    • HANDLER/DO are not supported

    SQL management

    • ANALYZE/CHECK/CHECKSUM/OPTIMIZE/REPAIR TABLE are not supported, which should be performed with passthrough syntax
    • CACHE INDEX are not supported
    • FLUSH is not supported
    • KILL is not supported
    • LOAD INDEX INTO CACHE is not supported
    • RESET is not supported
    • SHUTDOWN is not supported
    • SHOW BINARY LOGS/BINLOG EVENTS is not supported
    • The combination of SHOW WARNINGS/ERRORS and LIMIT/COUNT is not supported

    Other limits

    Up to 5,000 tables can be created by default. If you need to create more tables, please submit a ticket.

    Contact Us

    Contact our sales team or business advisors to help your business.

    Technical Support

    Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

    7x24 Phone Support