In-Memory database Memsql

1. In-memory database Memsql 1.1 Features

Memsql is a pure in-memory database developed by Facebook.

Characteristics:

1, all tables must have a primary key, such as the occurrence of data does not meet the requirements, you can use the self-increment primary key, type bigint.

2, all SQL, the first execution slow, will be compiled into binary, the second execution fast.

3, does not support the construction of temporary tables, does not support the CREATE table as

1.2 Installation Critical steps

Decompression Management End Memsql-ops-4.0.28.tar.gz

Start the management side

#安装目录为/data/server/memsql/memsql-ops, directory owner for mysql# start the management side su mysql-s/bin/bash-c ' memsql-ops start ' #注册安装包memsql-ops File-add-t memsql/data/server/memsql/memsqlbin_amd64.tar.gz #网页操作 #http://127.0.0.1:9000/#登入终端mysql-u root-h 127.0.0.1-p 3346--prompt= "memsql>" #授权GRANT all privileges on * * to ' root ' @ '% ' identified by ' test123 ' with GRANT OP Tion;flush privileges;

Enter terminal

Mysql-u root-h 172.16.2.40-p 3346--prompt= "memsql>"

After entering the same as MySQL

This article is from the "Intelligent Future _XFICC" blog, please be sure to keep this source http://xficc.blog.51cto.com/1189288/1683573

In-Memory database Memsql