MySQL 5.6 features not supported by AnalyticDB for MySQL

  • Database management
    • Plug-ins and user-defined functions
    • SET
  • Compound query
  • Data replication
  • Stored objects
  • Transactional and locking statements
  • User-defined functions

Character sets and collations

AnalyticDB for MySQL supports only UTF-8.

mysql> SHOW CHARACTER SET;
+---------+---------------+-------------------+--------+
| Charset | Description   | Default collation | Maxlen |
+---------+---------------+-------------------+--------+
| utf8    | UTF-8 Unicode | utf8_general_ci   | 3      |
+---------+---------------+-------------------+--------+
1 row in set (0.00 sec)
mysql> SHOW COLLATION;
+-----------------+---------+------+---------+----------+---------+
| Collation       | Charset | Id   | Default | Compiled | Sortlen |
+-----------------+---------+------+---------+----------+---------+
| utf8_general_ci | utf8    |   33 | Yes     | Yes      | 1       |
| binary          | binary  |   63 | Yes     | Yes      | 1       |
+-----------------+---------+------+---------+----------+---------+
2 rows in set (0.00 sec)

Case sensitivity

Data is case-sensitive in AnalyticDB for MySQL but not in MySQL.

Database management

Category MySQL AnalyticDB for MySQL Definition
Account management ALTER USER Not supported Modifies a user.
CREATE USER Supported. For more information, see CREATE USER. Creates a user.
DROP USER Supported. For more information, see DROP USER. Deletes one or more users and their permissions.
GRANT Supported. For more information, see GRANT. Grants a permission to a user.
RENAME USER Supported. For more information, see RENAME USER. Renames an existing user.
REVOKE Supported. For more information, see REVOKE. Enables system administrators to revoke permissions from users.
Table maintenance ANALYZE TABLE Supported. The collected statistics are different, but users do not perceive the difference. Analyzes the key distribution and stores the distribution of named tables.
CHECK TABLE Not supported Checks one or more tables for errors.
CHECKSUM TABLE Not supported Returns the checksum of the table content.
OPTIMIZE TABLE Supported Re-organizes the physical storage of table data and associated index data to reduce storage space and improve I/O efficiency when you access tables.
REPAIR TABLE Not supported Fixes a table that may be damaged. This statement can be used only for a specific storage engine.
SHOW SHOW AUTHORS Not supported Shows the developer information.
SHOW BINARY LOGS Not supported Shows binary log files on the server.
SHOW BINLOG EVENTS Not supported Shows events in binary logs.
SHOW CHARACTER Supported Shows all available character sets.
SHOW COLLATION Supported Shows the collation supported by the server.
SHOW COLUMNS FROM Supported
Note AnalyticDB for MySQL V3.0 does not support filter conditions. The execution result of SHOW COLUMNS FROM shows all columns.
Shows the information about columns in a specified table. This parameter can be also used for views.
SHOW CONTRIBUTORS Not supported Shows participants.
SHOW CREATE DATABASE Not supported Shows the statements that are used to create databases.
SHOW CREATE EVENT Not supported Shows the statements that are used to create events.
SHOW CREATE FUNCTION Not supported Shows the statements that are used to create functions.
SHOW CREATE PROCEDURE Not supported Shows the statements that are used to create stored procedures.
SHOW CREATE TABLE Supported Shows the statements that are used to create tables.
SHOW CREATE TRIGGER Not supported Shows the statements that are used to create triggers.
SHOW CREATE VIEW Supported Shows the statements that are used to create views.
SHOW DATABASES Supported Shows the databases on the server.
SHOW ENGINE Not supported Shows the logs or status information of storage engines.
SHOW ENGINES Not supported Shows the storage engines supported by the server.
SHOW ERRORS Not supported Shows the error message generated by the last statement executed.
SHOW EVENTS Not supported Shows the information about events in the default database.
SHOW FUNCTION CODE Not supported Shows the representation process of the internal implementation of a specified storage. It is used for internal debugging on the server.
SHOW FUNCTION STATUS Not supported Shows the stored function information. You must create a stored function first.
SHOW GRANTS Supported Shows the access permissions of a specified user.
SHOW INDEX Supported Shows the index information for a specified database.
SHOW MASTER STATUS Not supported Shows the status information about binary log files of the source server.
SHOW OPEN TABLES Not supported Shows a list of non-temporary tables that are registered in the cache and are open.
SHOW PLUGINS Not supported Shows the plug-in information.
SHOW PRIVILEGES Not supported Shows the permissions that can be granted and their definitions.
SHOW PROCEDURE CODE Not supported Shows the representation process of the internal implementation of a specified storage. It is used for internal debugging on the server.
SHOW PROCEDURE STATUS Not supported Shows the stored procedure information. You must create a stored procedure first.
SHOW PROCESSLIST Supported. For more information, see SHOW PROCESSLIST. Shows the information about server activities that are being executed.
SHOW PROFILE Not supported Shows the resource usage of the statement executed in the session.
SHOW PROFILES Not supported Shows the resource usage of the statements executed in the session.
SHOW RELAYLOG EVENTS Not supported Shows the relaylog event information. Replication between the source and replica servers is made first.
SHOW SLAVE HOSTS Not supported Shows a list of replica servers registered with the source server. Replication between the source and replica servers is made first.
SHOW SLAVE STATUS Not supported Shows the status information of replica servers. Replication between the source and replica servers is made first.
SHOW STATUS Not supported Shows the MySQL status information.
SHOW TABLE STATUS Not supported Shows the table property information.
SHOW TABLES Supported Shows the names of all tables in the database.
SHOW TRIGGERS Not supported Shows the trigger information. You must create a trigger first.
SHOW VARIABLES Not supported Shows the variable information.
SHOW WARNINGS Not supported Shows the warning information generated by the last statement executed.
Others BINLOG Not supported A statement for internal use.
CACHE INDEX Not supported Assigns table indexes to a specified key cache.
FLUSH Supported Clears or reloads various internal caches, refreshes tables, or obtains locks. It has multiple variants.
KILL Supported. For more information, see KILL PROCESS. Terminates an ongoing process.
LOAD INDEX INTO CACHE Not supported Preloads the table index to a key-value high-speed cache that is assigned by the CACHE INDEX statement. Otherwise, the table index is preloaded to the default key-value high-speed cache.
RESET Not supported Clears the status of various server operations.

Public statements

MySQL AnalyticDB for MySQL Definition
DESCRIBE and EXPLAIN EXPLAIN is supported. The DESCRIBE and EXPLAIN statements are both used to obtain information about table schemas or query execution plans.
HELP Not supported Returns the online help information from MySQL references.
USE Supported Uses a named database as the default (current) database for subsequent statements. This statement requires permissions on the database or its objects.