Note: Use Docker for installation 1. Basic Preparation
a. 环境检查(必须,不然会有服务启动异常的问题)docker run --rm memsql/quickstart check-systemb. 启动docker run -d -p 3306:3306 -p 9000:9000 --name memsqlcontainer memsql/quickstart启动的时候也可以使用数据卷docker create --name memsqldata memsql/quickstart /bin/truedocker run -d -p 3306:3306 -p 9000:9000 --name memsqlcontainer --volumes-from memsqldata memsql/quickstart
2. Basic use
浏览器打开 http://127.0.0.1:9000
Reference Interface 3. Basic use
a. 链接创建数据库docker exec -it memsqlcontainer memsql // 或者直接链接 3306 端口 root 用户 无密码 create database test;use test;CREATE TABLE test_table (id BIGINT PRIMARY KEY AUTO_INCREMENT, c INT);INSERT INTO test_table (c) VALUES (1);INSERT INTO test_table (c) SELECT c*2 FROM test_table;INSERT INTO test_table (c) SELECT c*2 FROM test_table;INSERT INTO test_table (c) SELECT c*2 FROM test_table;INSERT INTO test_table (c) SELECT c*2 FROM test_table;INSERT INTO test_table (c) SELECT c*2 FROM test_table;SELECT SUM(c) FROM test_table;+--------+| SUM(c) |+--------+| 243 |+--------+1 row in set (0.00 sec)
4. Multi-threaded query test
docker exec -it memsqlcontainer simple-benchmark
The interface can see query 5. Resources
https://docs.memsql.com/
Memsql Basic Installation Trial