Chevron Left Icon
Bars Icon
Product
Managed Service
Cloud Database-as-a-service
Database Software
Deploy SingleStore anywhere
Stream Icon
Ingest Data
Tools Icon
Tools and Monitoring
Lock Icon
Security
Sync Icon
Replace MySQL
Solutions
Use Cases
How SingleStore is used
Customers
Learn who uses SingleStore
Briefcase Icon
Professional Services
Industry Icon
Industries
Sitemap Icon
Architectures
Check Icon
Comparisons
Docs
Documentation
Set up and use SingleStore's products and tools
How SingleStore Works
A concise overview of SingleStore
Life Ring Icon
Support
Comments Icon
Forums
List Icon
Release Notes
Learn
Developer Hub
Begin building faster data applications
Resources
Whitepapers, ebooks, videos and more
Calendar Icon
Events
Rss Icon
Blog
Newspaper Icon
News
Presentation Icon
Training
Video Icon
Product Demo
Pricing
Envelope Icon
Envelope Icon
User Circle Icon
Laptop Icon
Portal
Access Managed Service & Licenses
Comments Icon
Forums
Ask the Community
Users Class Icon
Training
Self-Paced Learning
Life Ring Icon
Enterprise Support
Submit a Ticket
Start Free
Bars Icon
Chevron Left Icon
Bars Icon
Database Icon
Product
Analytics Icon
Solutions
Code Icon
Docs
Book Icon
Learn
Dollar Sign Icon
Pricing
User Circle Icon
Sign In
Arrow Right Icon
Start Free
Cloud Icon
Managed Service
Cloud Database-as-a-service
Database Icon
Database Software
Deploy SingleStore anywhere
Stream Icon
Ingest Data
Tools Icon
Tools and Monitoring
Lock Icon
Security
Sync Icon
Replace MySQL
Lightbulb Icon
Use Cases
How SingleStore is used
Users Icon
Customers
Learn who uses SingleStore
Briefcase Icon
Professional Services
Industry Icon
Industries
Sitemap Icon
Architectures
Check Icon
Comparisons
Book Icon
Documentation
Set up and use SingleStore's products and tools
Database Icon
How SingleStore Works
A concise overview of SingleStore
Life Ring Icon
Support
Comments Icon
Forums
List Icon
Release Notes
Laptop Icon
Developer Hub
Begin building faster data applications
File Download Icon
Resources
Whitepapers, ebooks, videos and more
Calendar Icon
Events
Rss Icon
Blog
Newspaper Icon
News
Presentation Icon
Training
Video Icon
Product Demo
Laptop Icon
Portal
Access Managed Service & Licenses
Comments Icon
Forums
Ask the Community
Users Class Icon
Training
Self-Paced Learning
Life Ring Icon
Enterprise Support
Submit a Ticket
Contact Us
Back
Latest
v7.1
v7.0
v6.8
v6.7
v6.5
v6.0
v5.8
v5.7
v5.5
v5.1
v5.0
Introduction
Documentation Overview
How MemSQL Works
FAQs
MemSQL FAQ
Support FAQ
Guides
Overview
Deploy MemSQL
Data Ingest
Development
Cluster Management
Client and Application
Security
Concepts
Concepts Overview
Aggregator
Code Generation
Columnstore
Database
Data Skew
Distributed Architecture
Distributed SQL
Geospatial Guide
Indexes
Information Schema
JSON Guide
Leaf
Master Aggregator
Memory Management
MySQL Features Unsupported in MemSQL
Prepared Statements
Persistent Computed Columns
Queries
Rowstore
System Status
Table
Unenforced Unique Constraints
Understanding Operations on Encoded Data
Window Functions Guide
Workload Management
Procedural Extensions
Pipelines
Pipelines Overview
Extractors
Transforms
Pipelines System Variables
Pipelines Information Schema Tables
Kafka Pipelines Overview
Kafka Pipelines Quickstart
S3 Pipelines Overview
S3 Pipelines Quickstart
Azure Blob Pipelines Overview
Azure Blob Pipelines Quickstart
Filesystem Pipelines Overview
Filesystem Pipelines Quickstart
Workload Profiling
Workload Profiling
Workload Profiling Overview
Management View Reference
Management View Statistics Reference
Workload Profiling Scenario
Tools
MemSQL Ops
MemSQL Ops Overview
MemSQL Ops Architecture
MemSQL Ops Command Line Interface
Status Page
Cluster Page
Schema Explorer Page
Query Explorer Page
Data Import Page
Pipelines Management
MemSQL Replicate
Overview
Reference
Configuration Reference
memsql.cnf (MemSQL Configuration)
settings.conf (MemSQL Ops Configuration)
System Variables
How to Update System Variables
System Limits
MemSQL Ops CLI Reference
Overview
Local MemSQL Ops Agent Management
Overview
UNFOLLOW
STATUS
STOP
SSL-SET-CERT
SSL-DISABLE
API-TOKEN
AGENT-UPDATE-API-TOKEN
AGENT-ID
VERSION
UNINSTALL
START
FOLLOW
RESTART
CLUSTER-MANUAL-CONTROL
MemSQL Backup Management
Overview
DATABASE-BACKUP
AGENT-BACKUP
BACKUP-LIST
AGENT-RESTORE
DATABASE-RESTORE
BACKUP-DELETE
MemSQL License Management
Overview
LICENSE-LIST
LICENSE-ADD
MemSQL Node and Cluster Management
Overview
MEMSQL-ENABLE-HIGH-AVAILABILITY
MEMSQL-LIST
MEMSQL-OPTIMIZE
MEMSQL-PATH
MEMSQL-DEPLOY
MEMSQL-STOP
MEMSQL-UPGRADE
MEMSQL-UPDATE-ROOT-PASSWORD
MEMSQL-UPDATE-CONFIG
MEMSQL-DELETE
MEMSQL-MONITOR
MEMSQL-RESTART
MEMSQL-UNMONITOR
MEMSQL-START
MemSQL Ops File Management
Overview
FILE-DELETE
FILE-ADD
FILE-LIST
MemSQL Ops Job Management
Overview
JOB-INFO
JOB-LOGS
JOB-CANCEL
JOB-WAIT
JOB-LIST
MemSQL Ops Superuser Management
Overview
SUPERUSER-LIST
SUPERUSER-ADD
SUPERUSER-DELETE
MemSQL Ops Tools
Overview
REPORT
Remote MemSQL Ops Agent Management
Overview
AGENT-UPGRADE
AGENT-START
AGENT-UNINSTALL
AGENT-LIST
AGENT-SET-CREDENTIAL
AGENT-DEPLOY
AGENT-PUT
AGENT-SSH
AGENT-GET
AGENT-STOP
AGENT-MOVE-MEMSQL-INSTALLS-DIR
SQL Reference
Overview
Data Types
Aggregate Functions
Overview
ANY_VALUE
APPROX_COUNT_DISTINCT
AVG
COUNT
GROUP_CONCAT
MAX
MIN
MOD
STD
STDDEV_SAMP
SUM
VARIANCE
VAR_SAMP
Cluster Management Commands
Overview
Node Requirements for MemSQL Commands
ADD AGGREGATOR
ADD LEAF
AGGREGATOR SET AS MASTER
ATTACH LEAF
ATTACH LEAF ALL
BOOTSTRAP AGGREGATOR
DETACH LEAF
EXPLAIN REBALANCE PARTITIONS
EXPLAIN RESTORE REDUNDANCY
FILL and FLUSH CONNECTION POOLS
REBALANCE PARTITIONS
REMOVE AGGREGATOR
REMOVE LEAF
RESTORE REDUNDANCY
SHOW AGGREGATORS
SHOW LEAVES
SHOW CLUSTER STATUS
SHOW REBALANCE STATUS
TRIGGER GC
Conditional Functions
Overview
CASE
COALESCE
CONVERT
ELT
GREATEST
IF
IFNULL
ISNULL
LEAST
NULLIF
SLEEP
Data Definition Language (DDL)
Overview
ALTER TABLE
ALTER VIEW
CREATE DATABASE
CREATE INDEX
CREATE VIEW
CREATE TABLE
DESCRIBE
DROP DATABASE
DROP INDEX
DROP ... FROM PLANCACHE
DROP TABLE
DROP VIEW
FLUSH TABLES
OPTIMIZE TABLE
TRUNCATE
UNLOCK TABLES
Data Manipulation Language (DML)
Overview
AGGREGATOR SYNC AUTO_INCREMENT
BEGIN
COMMIT
DELETE
EXCEPT and MINUS
EXISTS and NOT EXISTS
EXPLAIN
LOAD DATA
INSERT
INTERSECT
PROFILE
REPLACE
ROLLBACK
SELECT
UNION
UPDATE
USE
WITH (Common Table Expressions)
Date and Time Functions
Overview
ADDTIME
CONVERT_TZ
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
DATE
DATEDIFF
DATE_ADD
DATE_FORMAT
DATE_SUB
DATE_TRUNC
DAY
DAYNAME
DAYOFWEEK
DAYOFYEAR
EXTRACT
FROM_DAYS
FROM_UNIXTIME
GET_FORMAT
HOUR
LAST_DAY
LOCALTIMESTAMP
MINUTE
MONTH
MONTHNAME
MONTHS_BETWEEN
QUARTER
SECOND
SEC_TO_TIME
STR_TO_DATE
TIME
TIMEDIFF
TIMESTAMP
TIMESTAMPADD
TIMESTAMPDIFF
TIME_FORMAT
TIME_TO_SEC
TO_DAYS
TO_SECONDS
UNIX_TIMESTAMP
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
WEEK
WEEKDAY
YEAR
Geospatial Functions
Overview
APPROX_GEOGRAPHY_INTERSECTS
GEOGRAPHY_AREA
GEOGRAPHY_CONTAINS
GEOGRAPHY_DISTANCE
GEOGRAPHY_INTERSECTS
GEOGRAPHY_LATITUDE
GEOGRAPHY_LENGTH
GEOGRAPHY_LONGITUDE
GEOGRAPHY_POINT
GEOGRAPHY_WITHIN_DISTANCE
Information Functions
Overview
LAST_INSERT_ID
ROW_COUNT
JSON Functions
Overview
JSON_ARRAY_CONTAINS_<type>
JSON_ARRAY_PUSH_<type>
JSON_DELETE_KEY
JSON_EXTRACT_<type>
JSON_GET_TYPE
JSON Keypaths
JSON_LENGTH
JSON_SET_<type>
JSON_SPLICE_<type>
Numeric Functions
Overview
ABS
SIGN
EXP
ACOS
ASIN
ATAN
ATAN2, ATAN
BIT_COUNT
bitwise AND (&)
bitwise NOT (~)
bitwise OR (|)
bitwise XOR (^)
bitwise left shift (<<)
bitwise right shift (>>)
CEIL
CONV
COS
COT
LN
LOG2
LOG10
DEGREES
FLOOR
LOG
PI
POW
RADIANS
RAND
ROUND
SIN
SQRT
TAN
TRUNCATE
Operational Commands
Overview
ANALYZE
BACKUP
CLEAR ORPHAN DATABASES
CONTINUE REPLICATING
KILL CONNECTION
KILLALL QUERIES
PAUSE REPLICATING
REPAIR DATABASE
REPLICATE DATABASE
RESTORE
SELECT GLOBAL
SET GLOBAL
SHOW REPLICATION STATUS
SNAPSHOT DATABASE
STOP REPLICATING
Pipelines Commands
Overview
ALTER PIPELINE
CREATE PIPELINE
DROP PIPELINE
START PIPELINE
STOP PIPELINE
TEST PIPELINE
Procedural SQL Reference
Overview
Control Flow Statements
Transactions in Stored Procedures
Exceptions and Exception Handling
CREATE FUNCTION (UDF)
CREATE FUNCTION (TVF)
CREATE PROCEDURE
CREATE AGGREGATE
DROP FUNCTION
DROP PROCEDURE
DROP AGGREGATE
SHOW CREATE FUNCTION
SHOW CREATE AGGREGATE
SHOW FUNCTIONS
SHOW AGGREGATES
CALL
ECHO
CREATE_ARRAY
COLLECT
SCALAR
ARRAY
RECORD
ROW
QUERY
Definer Security Model
Security Management Commands
Overview
CREATE GROUP
CREATE ROLE
CREATE USER
CURRENT_USER
DROP GROUP
DROP ROLE
DROP USER
GRANT
GRANT GROUP
GRANT ROLE
REVOKE
REVOKE GROUP
REVOKE ROLE
SET PASSWORD
SHOW GRANTS
SHOW GROUPS
SHOW GROUPS FOR ROLE
SHOW GROUPS FOR USER
SHOW ROLES
SHOW ROLES FOR GROUP
SHOW ROLES FOR USER
SHOW USERS
SHOW USERS FOR GROUP
SHOW USERS FOR ROLE
Permissions Matrix
Default Mode Permissions Changes
Strict Mode Permissions
SHOW Commands
Overview
SHOW CREATE PIPELINE
SHOW COLUMNS
SHOW CREATE TABLE
SHOW DATABASES
SHOW GLOBAL STATUS
SHOW GLOBAL VARIABLES
SHOW INDEX
SHOW INDEXES
SHOW KEYS
SHOW LOAD ERRORS
SHOW LOAD WARNINGS
SHOW PIPELINES
SHOW PLANCACHE
SHOW PROCESSLIST
SHOW SCHEMAS
SHOW SESSION STATUS
SHOW SESSION VARIABLES
SHOW STATUS [EXTENDED]
SHOW TABLE STATUS
SHOW TABLES
SHOW VARIABLES
SHOW WARNINGS
String Functions
Overview
AES_DECRYPT
AES_ENCRYPT
ASCII
BIN
BINARY
CHAR
CHARACTER_LENGTH
CONCAT
CONCAT_WS
FIELD
FORMAT
FROM_BASE64
HEX
INET_ATON
INET_NTOA
INSTR
LCASE
LEFT
LENGTH
LOCATE
LPAD
LTRIM
MD5
RIGHT
RLIKE
RPAD
RTRIM
SHA1
SHA2
SUBSTRING
SUBSTRING_INDEX
TO_BASE64
TRIM
UCASE
UNHEX
Vector Functions
Overview
DOT_PRODUCT
VECTOR_SUB
EUCLIDEAN_DISTANCE
JSON_ARRAY_PACK
Window Functions
Overview
DENSE_RANK
FIRST_VALUE
LAG
LAST_VALUE
LEAD
NTH_VALUE
NTILE
PERCENT_RANK
PERCENTILE_CONT and Median
PERCENTILE_DISC
RANK
ROW_NUMBER
Troubleshooting Reference
Overview
Capacity Limit Error
Memory Errors
MemSQL Tools Issues
Network Errors
Operations Errors
Query Errors
Release Notes
MemSQL
7.0 Release Notes
6.8 Release Notes
6.7 Release Notes
6.5 Release Notes
6.0 Release Notes
5.8 Release Notes
5.7 Release Notes
5.5 Release Notes
5.1 Release Notes
5.0 Release Notes
4.1 Release Notes
4.0 Release Notes
3.2 Release Notes
3.1 Release Notes
MemSQL Ops
MemSQL Deprecations
Outdated Version
You are viewing an older version of this section.
View current production version.
/
Deploy MemSQL
/
Deployment: Select one
Deployment: Self-Managed
/
Guide: Select one
Guide: MemSQL Ops
Guide: Cluster Configuration
Select a deployment guide
MemSQL Ops
10-30 min read
Deploy a MemSQL cluster using first-party tools directly.
Start Guide
Cluster Machine Configuration
10 min read
Learn how to configure the host machines in your MemSQL cluster.
Start Guide
Was this Article Helpful?
Thanks For Your Feedback!
Need help
or have suggestions
? Go to SingleStore Forums
Was this Article Helpful?
Thanks For Your Feedback!
Sorry About That
Can you give us a little more context about what we didn’t answer for you? We’ll get back to you as soon as we can.
Question or Feedback
Please enter a valid message
Email
(if you'd like us to respond to you)
Please enter a valid email
Submit
Server error. Please try again.
Sorry About That
Can you give us a little more context about what we didn’t answer for you? We’ll get back to you as soon as we can.
Question or Feedback
Please enter a valid message
Email
(if you'd like us to respond to you)
Please enter a valid email
Submit
Server error. Please try again.