What are the characteristics of the Memory storage engine in mysql?

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

16 columns per index, and a key length of 500 bytes.

2. The storage engine executes HASH and BTREE micronization.

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;

The above is the detailed content of What are the characteristics of the Memory storage engine in mysql?. For more information, please follow other related articles on the PHP Chinese website!