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 a 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 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 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 about 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 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 user. | |
SHOW INDEX | Supported | Shows the index information for a 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 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 statements 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 about 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 | 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 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 | Supported | Obtains information about table schemas. |
EXPLAIN | Supported | Queries execution plans. Note
|
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 objects of the database. |