Shulou(Shulou.com)05/31 Report--

This article focuses on "what are the features of Memory storage engine in mysql". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "what are the features of Memory storage engine in mysql"?

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

Each index has 16 columns and a 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; so far, I believe you have a deeper understanding of "what are the characteristics of Memory storage engine in mysql". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.