MySQL 5.6 features that are not supported by AnalyticDB MySQL

  • Database management
    • Plug-in and user-defined functions
    • SET
  • Compound query
  • Data replication
  • Stored objects
  • Transactional and locking
  • Self-managed functions

Character set and collation

AnalyticDB 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)

Database management

Item MySQL AnalyticDB MySQL Description
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, and the users do not perceive the difference. Analyzes the key distribution and stores the distribution of the named table.
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 Reorganizes 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 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 a binary log.
SHOW CHARACTER Supported Shows all available character sets.
SHOW COLLATION Supported Shows the collation supported by the server.
SHOW COLUMNS FROM Supported
Note AnalyticDB MySQL 3.0 does not support filter conditions such as show columns from xxx. The execution result of this statement shows all columns.
Shows information about the columns in a given table. This parameter also applies to 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 a stored procedure.
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 execution.
SHOW EVENTS Not supported Shows information about events in the default database.
SHOW FUNCTION CODE Not supported The internal debugging of the server, which displays the representation process of the internal implementation of the specified storage.
SHOW FUNCTION STATUS Not supported Shows the stored function information. You must create a stored function first.
SHOW GRANTS Supported Shows the access permissions that the specified user has.
SHOW INDEX Supported Shows index information for the specified database.
SHOW MASTER STATUS Not supported Shows the binary information that is used by master.
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 plug-in information.
SHOW PRIVILEGES Not supported Shows the permissions that can be granted and their definitions.
SHOW PROCEDURE CODE Not supported The internal debugging of the server, which displays the representation process of the internal implementation of the specified storage.
SHOW PROCEDURE STATUS Not supported Shows stored procedure information. You must create a stored function first.
SHOW PROCESSLIST Supported. For more information, see SHOW PROCESSLIST. Shows information about the server activities that are being executed.
SHOW PROFILE Not supported Shows the resource usage of the execution statement in the session.
SHOW PROFILES Not supported Shows the resource usage of the execution statement in the session.
SHOW RELAYLOG EVENTS Not supported Shows relaylog event information. Master-replica replication is required first.
SHOW SLAVE HOSTS Not supported Shows a list of replication hosts registered on the master host. Master-replica replication is required first.
SHOW SLAVE STATUS Not supported Shows the status information of the slave host. Master-replica replication is required first.
SHOW STATUS Not supported Shows 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 trigger information. You must create a trigger first.
SHOW VARIABLES Not supported Shows the variable information.
SHOW WARNINGS Not supported Shows warning information generated by the last statement executed.
Other information BINLOG Not supported BINLOG is an internally used statement.
CACHE INDEX Not supported Assigns a table index to the specific key-value high-speed cache.
FLUSH Supported The FLUSH statement has multiple variants and can clear or reload various internal caches, refresh tables, or obtain locks.
KILL Supported. For more information, see KILL PROCESS. Terminates an ongoing process.
LOAD INDEX INTO CACHE Not supported The LOAD INDEX INTO CACHE statement preloads the table index to a key-value high-speed cache that is assigned by the CACHE INDEX statement. Otherwise, the LOAD INDEX INTO CACHE statement is preloaded to the default key-value high-speed cache.
RESET Not supported Clears the status of various server operations.

Public

MySQL AnalyticDB MySQL Description
DESCRIBE/EXPLAIN Supports EXPLAIN The DESCRIBE and EXPLAIN statements have the same definition and are used to obtain information about table schemas or query execution plans.
HELP Not supported Returns 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.