Memsql Basic Installation Trial

Source: Internet
Author: User
Tags docker run memsql

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.