What are the characteristics of Memory storage engine in mysql

This article is about the features of the Memory storage engine in mysql. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

1. Each table of the Memory table can have up to 32 indexes.

Each index has 16 columns and a maximum key length of 500 bytes.

2. Storage engine executes HASH and BTREE miniature.

3. There can be non-unique key values in the table.

4. The table adopts a fixed record length format.

5. BLOB or TEXT columns are not supported.

Example

Mysql > CREATE TABLE lookup (id INT, INDEX USING HASH (id)) ENGINE = MEMORY; mysql > CREATE TABLE lookup (id INT, INDEX USING BTREE (id)) ENGINE = MEMORY; Thank you for reading! This is the end of this article on "what are the characteristics of the Memory storage engine in mysql?". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!