Corporate logotype
Corporate logotype
  • Introduction
    • SingleStore Documentation
    • How SingleStoreDB Works
      • Data Ingestion
      • Highly Compatible
      • Durable and Redundant
      • Deploy anywhere
      • Analyzing Data
      • High-Performance for OLTP and OLAP Workloads
    • Distributed Architecture
      • Design Principles
      • Cluster Components
        • Interaction of Cluster Components
          • Sharding
            • Distributed DML Query Execution
              • Distributed Joins
                • Write Queries
                  • Distributed SQL Surface Area
                  • High Availability
                • Unsupported MySQL Features
                  • Unsupported Feature List
                  • Behavior Differences
                • FAQs
                  • General
                    • What are license units and how do they apply to my cluster?
                    • What is the relationship between SingleStoreDB and MySQL?
                    • Why do I see the MemSQL version as 5.5.8, even though that’s not the version of MemSQL I installed?
                    • Is SingleStoreDB vulnerable to MySQL server security issues?
                    • Is SingleStoreDB a row-based or column-based store?
                    • How does SingleStoreDB’s in-memory lock-free storage engine work?
                    • What is the advantage of SingleStoreDB over traditional databases like Oracle, SQL Server or MySQL with data in a “ramdisk” or large buffer pools?
                    • What is the advantage of SingleStoreDB over other distributed databases?
                    • What is SingleStoreDB not for?
                  • Clustering
                    • How does SingleStoreDB shard tables?
                    • What are aggregator and leaf nodes?
                    • What is a “Master Aggregator”?
                    • What happens if the master aggregator crashes?
                    • How do I add nodes to SingleStoreDB?
                    • How many aggregator and leaf nodes do I need?
                    • Can I query the leaf nodes individually?
                    • After I ran a single host install, why are there 2 SingleStoreDB nodes (or 4 SingleStoreDB processes) running?
                  • Query Compilation
                    • Why does CREATE TABLE take so long in SingleStoreDB?
                    • Why do SingleStoreDB queries typically run faster the second time they are executed?
                    • How much can you change a query before it needs to be recompiled?
                  • Query Execution
                    • Can I JOIN multiple sharded tables in a query?
                    • Can I optimize a distributed join involving a small, static table?
                    • Why do I get errors about UNIQUE KEYs?
                  • Durability
                    • What is the durability guaranteed by SingleStoreDB?
                    • Can I configure SingleStoreDB to be fully durable?
                    • What isolation levels does SingleStoreDB provide?
                  • Deployment and Management
                    • How can I get a copy of SingleStoreDB?
                    • Does SingleStoreDB run in the cloud?
                    • Does SingleStoreDB run on Windows?
                    • What hardware is recommended for SingleStoreDB?
                    • On which Linux distribution does SingleStoreDB run best?
                    • How much disk space should I allocate for SingleStoreDB?
                    • What happens if I run out of memory?
                    • What happens if I run out of disk space?
                  • SingleStore Tools
                    • What are SingleStore Tools?
                    • How do I switch over from MemSQL Ops to SingleStore Tools?
                    • Can I still use MemSQL Ops?
                    • When do I have to switch to Tools?
                  • Import and Backup
                    • How can I backup a SingleStoreDB database?
                    • How can I import data from MySQL, Postgres, MS-SQL etc?
                    • How can I easily copy a table?
                    • How can I easily copy a database?
                    • Where are the important data files (recovery log, binary logs, snapshots, data files etc)?
                  • SingleStoreDB and Spark
                    • How are SingleStoreDB and Apache Spark related?
                    • What are the differences between SingleStoreDB and Spark SQL?
                    • SQL Push Down
                  • Miscellaneous
                    • Does SingleStoreDB support compression?
                    • Does SingleStoreDB perform random IO?
                    • What are the index types SingleStoreDB supports?
              • Deploy
                • Linux
                  • Kubernetes
                    • Introduction
                    • Prerequisites
                      • Kubernetes concepts
                      • kubectl
                      • Host requirements
                      • Host recommendations
                      • Docker Container Repository (Optional)
                    • Download the MemSQL Operator
                    • Create the Object Definition Files
                      • deployment.yaml
                      • rbac.yaml
                      • memsql-cluster-crd.yaml
                      • memsql-cluster.yaml
                    • Deploy a SingleStoreDB Cluster
                      • Connect to Your Cluster
                      • Scaling and managing your cluster
                      • Deleting your cluster
                    • Next Steps
                  • Cluster in a Box
                    • Introduction
                      • Before You Begin
                    • Run the Container
                      • Start the Container
                    • Connect to your Cluster
                      • SingleStoreDB Studio
                      • SingleStore client application
                      • Third-party client application
                      • Run Sample Queries
                    • Manage the Container
                      • Upgrade the SingleStoreDB Docker Image
                      • Stop, Restart, or Remove the Image
                      • Access the Built-in SingleStore Tools
                    • Next Steps
                • Connect to Your Cluster
                  • Client and Driver Downloads
                    • Connect with the SingleStore Client
                    • Connect to SingleStoreDB using TLS/SSL
                    • Connect with DBeaver
                    • Connect with DbVisualizer
                      • Connect with JetBrains DataGrip
                      • Connect with MySQL
                        • Connect with MySQL Client
                          • MySQL Command-Line Considerations
                          • Unsupported MySQL Features
                        • Connect with Any MySQL Compatible Tool to SingleStoreDB
                          • MariaDB Command-line Client from MariaDB Server Version 10.3.12 (GPLv2)
                          • Connect with MySQL Workbench
                        • Connect with SQL Developer
                        • Connect with the SQL Editor
                        • Connect with Sequel Pro
                        • Connect with SQL Workbench
                        • Connect with Data API
                        • Connect to Your Cluster - Related Topics
                      • Create Your Database
                        • Create a Database
                        • Physical Database Schema Design
                          • Concepts of Physical Database Schema Design
                            • Choosing a Table Storage Type
                            • Rowstore
                            • Columnstore
                            • Understanding Keys and Indexes in SingleStore
                            • Understanding Shard Key Selection
                            • Understanding Clustered Columnstore Key Selection
                            • Understanding How Datatype Can Affect Performance
                            • Other Schema Concepts
                          • Procedures for Physical Database Schema Design
                            • Creating a Columnstore Table
                            • Detecting and Resolving Data Skew
                            • Optimizing Table Data Structures
                            • Specifying Unenforced Unique Constraints
                            • Using JSON
                            • Using Persistent Computed Columns
                          • Configuring the Columnstore to Work Effectively
                        • Integrate with SingleStoreDB
                          • Load Data
                            • Load Data from a Data Source
                              • Load Data from Amazon Web Services (AWS)
                                • Load Data from AWS Glue
                                • Load Data from Amazon S3 using a Pipeline
                              • Load Data from Microsoft Azure
                                • Load Data from Azure Blobs using a Pipeline
                                • Load Data from Azure Data Factory (ADF)
                                • Load Data from Azure Event Hubs
                              • Load Data from Data Virtuality Pipes
                              • Load Data from the Filesystem using a Pipeline
                                • Filesystem Pipeline Quickstart
                                • Prerequisites
                                • Creating a SingleStoreDB Database and Filesystem Pipeline
                              • Load Data from Google Cloud Storage (GCS) using a Pipeline
                                • Prerequisites
                                • Part 1: Creating a GCS Bucket and Adding a File
                                • Part 2: Creating a SingleStoreDB Database and GCS Pipeline
                                • Next Steps
                              • Load Data from HDFS using a Pipeline
                                • Creating and Starting an HDFS Pipeline
                                • HDFS Pipeline Scenario
                                • Enabling Wire Encryption and Kerberos on HDFS Pipelines
                              • Load Data from HVR
                              • Load Data from Informatica
                                • Load Data from Informatica Cloud
                              • Load Data from Kafka
                                • Securely Connect to Kafka from SingleStoreDB
                                • Load Data from the Confluent Kafka Connector
                                • Load Data from Kafka Using a Pipeline
                                • Test your Kafka Cluster using kcat (formerly kafkacat)
                              • Load Data from MySQL
                              • Load Data from Qlik Replicate
                                • Using Qlik Replicate
                              • Load Data from Spark
                                • Getting Started
                                • Installation
                                • Configuration Settings
                                • Examples
                                • Supported Operations
                                • SQL Pushdown
                                • Connection Pooling Support
                                • Parallel Read Support
                                • Load Balancing Requests
                                • Data Type Conversions
                                • Security and Permissions
                                • Debugging
                                • Migrate between SingleStore Spark Connector Versions
                              • Load Data from StreamSets
                                • Prerequisites
                                • Connecting StreamSets to SingleStoreDB via Fast Loader
                                • SingleStoreDB Fast Loader vs the JDBC Connector
                                • Error and Logs
                                • Frequently Asked Questions
                              • Connect with Collibra Data Governance
                                • Prerequisites
                                • Connecting Collibra DGC to SingleStoreDB
                              • SingleStore Replicate
                                • Transform Data with dbt
                                • Load a Type of Data
                                  • Loading Geospatial Data into SingleStoreDB
                                  • Example: Loading TPC-H Data into SingleStoreDB
                                    • What is TPC-H?
                                    • Before You Begin
                                    • Create the Database
                                    • Load Data with Pipelines
                                    • Verify Pipeline Success
                                    • Run Queries on Data
                                • About Loading Data with Pipelines
                                  • Pipeline Concepts
                                    • Overview of Pipelines
                                    • Pipeline Data Sources and Formats
                                    • The Lifecycle of a Pipeline
                                    • Parallelized Data Extraction with Pipelines
                                    • Data Shaping with Pipelines
                                    • Avro Schema Evolution with Pipelines
                                  • Pipeline Procedures
                                    • Detect and Address Slow Performance and High Memory Usage of Pipelines
                                    • View and Handle Pipeline Errors
                                    • Writing a Transform to Use With a Pipeline
                                    • Writing Efficient Stored Procedures for Pipelines
                                • Load Data - Related Topics
                              • Query Data
                                • Connect with Analytics and BI Tools
                                  • Introduction
                                  • Connect with Dremio
                                    • Prerequisites
                                    • Configuring JARS and running Dremio
                                    • Connecting Dremio to SingleStoreDB
                                    • Data Reflection and Query Acceleration
                                    • Best practices guide
                                  • Connect with Looker
                                    • Prerequisites
                                    • Connecting Looker to SingleStoreDB
                                  • Connect with MicroStrategy
                                    • Connect with MicroStrategy
                                  • Connect with Power BI
                                    • Prerequisites
                                    • Data Connectivity Modes
                                    • Connect Power BI Desktop to SingleStoreDB
                                    • Connect Power BI Service to SingleStoreDB via Power BI Gateway
                                  • Connect with Sisense
                                    • Prerequisites
                                    • Connecting Sisense to SingleStoreDB using ElastiCube Model
                                    • Connecting Sisense to SingleStoreDB using Live Model
                                  • Connect with Tableau
                                    • Connect with Tableau Desktop
                                    • Connect with Tableau Prep
                                  • Connect with Tibco Spotfire
                                    • Prerequisites
                                    • Connect Tibco Spotfire to SingleStore
                                • Query Concepts
                                  • Code Generation
                                    • Row Locking
                                    • Query Procedures
                                      • Basic Query Examples
                                      • Example: Building a Sample Stock Trade Database
                                        • Step 1: Create the database
                                        • Step 2: Load company profile data
                                        • Step 3: Create data generator functionality
                                        • Step 4: Generate trade data
                                        • Step 5: Run analytic queries
                                        • Query 1
                                        • Query 2
                                        • Query 3
                                        • Query 4
                                      • Performing Upserts
                                        • Read Query Results in Parallel
                                        • Run UPDATEs and DELETEs as Distributed Transactions
                                          • Query Performance Tools
                                            • Query Tuning
                                              • Testing Your Queries and Performance
                                                • Troubleshooting Poorly Performing Queries
                                                • Statistics and Sampling
                                                  • Statistics and Sampling Concepts
                                                    • Statistics and Sampling Tasks
                                                  • Manage Data
                                                    • Local and Unlimited Database Storage Concepts
                                                      • Benefits of Unlimited Storage
                                                      • Combining Unlimited and Local Storage Databases
                                                        • Unlimited Data Storage
                                                          • Attach an Unlimited Storage Database Using Point-in-Time Recovery (PITR)
                                                            • Configure the Retention Period for an Unlimited Storage Database
                                                            • Offline Copy of an Unlimited Storage Database
                                                              • Migrate a Local Storage Database to an Unlimited Storage Database
                                                              • Backing Up and Restoring Data
                                                                • Back Up and Restore Data
                                                                • Backup Information Schema Tables
                                                                • Using Storage Repositories
                                                                  • Items Included in and Excluded from a Backup
                                                                  • Types of Backups
                                                                    • Full Backups
                                                                    • Incremental Backups on Columnstores
                                                                    • Clearing Backup History
                                                                    • Backup and Restore on Specific Systems
                                                                    • Verifying Full Backup Files
                                                                  • Lock-free Backups
                                                                    • Backups versus Snapshots
                                                                  • Exporting Data
                                                                    • Exporting a Single Database
                                                                    • Exporting All Databases
                                                                • Developer Resources
                                                                  • Migrate Existing Applications
                                                                    • How to connect to SingleStoreDB
                                                                    • Loading data into SingleStoreDB
                                                                    • Porting Tables to SingleStoreDB
                                                                      • Shard keys
                                                                      • Choosing a Shard Key
                                                                    • Transition from MySQL to SingleStoreDB
                                                                      • Migrating Data with mysqldump
                                                                      • Transitioning Your Application
                                                                  • Connect with Application Development Tools
                                                                    • Connect with C/C++
                                                                      • MariaDB Connector/C (C/C++) Version 3.0.9 (LGPLv2.1)
                                                                    • Connect with Go
                                                                      • Connect with Java/JDBC
                                                                        • The SingleStore JDBC Driver
                                                                        • MariaDB Connector/J (JDBC) Version 2.4.0 (LGPLv2.1)
                                                                        • JDBC Connector Setup Instructions With Optional GSSAPI
                                                                      • Connect with JavaScript
                                                                        • Connect with Node.js
                                                                        • Connect with Node.js using SSL
                                                                      • Connect with Laravel
                                                                      • Connect with .NET and .NET Core
                                                                        • Connect with ODBC
                                                                          • The SingleStore ODBC Driver
                                                                          • MariaDB Connector/ODBC Version 3.0.8 (LGPLv2.1)
                                                                          • MySQL Connector/ODBC Version 8.0.26 (GPLv2)
                                                                        • Connect with Perl
                                                                          • Connect with Perl
                                                                          • DBD-MariaDB Perl Library Version 1.11 (GPLv2)
                                                                        • Connect with PHP
                                                                        • Connect with Python
                                                                          • Connect using the SingleStoreDB Python Client
                                                                          • Python Client Library Setup Instructions
                                                                          • MySQL Connector/Python Version 2.1.7 (GPLv2)
                                                                          • MySQL Connector/Python Version 8.0.15 (GPLv2)
                                                                          • Connect with SQLAlchemy
                                                                        • Connect with Ruby
                                                                          • Connect with Standard Ruby
                                                                          • Connect with Ruby on Rails
                                                                        • Connect with Rust
                                                                        • Using Prepared Statements
                                                                      • Connect with Data API
                                                                      • Concurrent Multi-Insert Examples
                                                                        • Bash
                                                                        • C
                                                                        • C# / .NET Core
                                                                        • Java
                                                                        • Node.js
                                                                        • Python
                                                                      • Functional Extensions
                                                                        • Analyzing Time Series Data
                                                                          • Working with Full-Text Search
                                                                            • Working with Geospatial Features
                                                                              • Working with Window Functions
                                                                              • SQL Reference
                                                                                • SQL Reference Overview
                                                                              • Procedural Extensions
                                                                                • Performance
                                                                                • Control Flow
                                                                                • Additional Data Types
                                                                                • Stored Procedures
                                                                                • User-Defined Scalar-Valued Functions (UDFs)
                                                                                • User-Defined Table-Valued Functions (TVFs)
                                                                                • User-Defined Aggregate Functions (UDAFs)
                                                                                • Static Parameterized SQL
                                                                                • Dynamic SQL
                                                                                  • Example Dynamic SQL Use Cases
                                                                                  • Writing Dynamic SQL
                                                                                • Procedural Extensions Security
                                                                                  • Application-Based User Security in Stored Procedures
                                                                                  • Definer Security Model
                                                                                • Procedural SQL Reference
                                                                                • See Also
                                                                              • Procedural SQL Reference
                                                                              • Get Started Using SingleStoreDB for Free
                                                                                • Sign Up for SingleStoreDB
                                                                                • Install Docker Desktop
                                                                                • Create a Docker Compose File
                                                                                • Start the SingleStoreDB Cluster
                                                                                • Start SingleStoreDB Studio
                                                                                • Next Steps
                                                                                • See Also
                                                                              • User and Cluster Administration
                                                                                • SingleStoreDB User Management
                                                                                  • Configuring SingleStoreDB user accounts
                                                                                    • Securing the initial SingleStoreDB user accounts
                                                                                    • Adding a User
                                                                                    • Changing a Password for a User
                                                                                    • Removing a User
                                                                                    • Inspecting Permissions
                                                                                    • Setting a Failed Login Attempt Lockout Policy
                                                                                  • Synchronizing LDAP Users
                                                                                    • LDAP Operations
                                                                                    • Synchronization Rules
                                                                                    • Using the LDAP Tool
                                                                                    • Communication with LDAP Server
                                                                                    • Processing LDAP Search Results
                                                                                  • Role-Based Access Control (RBAC) Guide
                                                                                    • Role-based Operations
                                                                                    • Role Creation
                                                                                    • Account Creation
                                                                                    • Enable Strict Mode
                                                                                    • Set Strict Mode without Management Tools
                                                                                    • Remove Default and Low-level Accounts
                                                                                    • Appendix: Role-Based Access Control Command Reference
                                                                                • Cluster Health and Performance
                                                                                  • Workload Profiling Overview
                                                                                    • Background
                                                                                    • Enable Advanced Counters
                                                                                    • Concepts
                                                                                  • Monitoring
                                                                                    • Components to Monitor
                                                                                    • Configure Alerts
                                                                                    • Configure Monitoring
                                                                                    • Configure Monitoring with Datadog
                                                                                • High Availability and Disaster Recovery
                                                                                  • Replication and Durability Concepts
                                                                                    • Replication
                                                                                    • Durability
                                                                                    • Using Synchronous Replication and Synchronous Durability Together
                                                                                    • Using Asynchronous Replication with Synchronous Durability is not Allowed
                                                                                    • Replication and Durability Configuration
                                                                                    • Replication and Durability Error Handling
                                                                                  • Managing High Availability
                                                                                    • High Availability Architecture
                                                                                    • Enabling High Availability
                                                                                    • Disabling High Availability
                                                                                    • High Availability Commands
                                                                                  • Transaction Logs and Snapshots
                                                                                    • Usage
                                                                                    • Replay Configuration
                                                                                    • Storage Location
                                                                                    • Configuration
                                                                                    • Managing Disk Space Used by Transaction Logs
                                                                                    • Error Handling
                                                                                  • Replicating Data Across Clusters
                                                                                    • Replication Compatibility Between Different Cluster Versions
                                                                                    • Setting Up Replication
                                                                                    • Cluster Topology
                                                                                    • Pausing and Stopping Replication
                                                                                    • Cluster Failover
                                                                                    • Aggregator Failover
                                                                                    • Calculating Memory Allocation per Host in a Cluster
                                                                                    • Upgrading a Primary and Secondary Cluster
                                                                                    • Monitoring Replication
                                                                                    • Extracting Metadata From a Secondary Database
                                                                                  • Replicate an Unlimited Storage Database
                                                                                    • High Availability (HA)and Disaster Recovery (DR) FAQs
                                                                                  • Maintain Your Cluster
                                                                                    • Administering a Cluster
                                                                                      • Cluster Administration Commands
                                                                                      • Setting the Redundancy Level
                                                                                    • Changing an IP Address in a Rolling Fashion (no downtime for reads)
                                                                                    • Setting or Replacing a License
                                                                                      • Setting a license
                                                                                      • Determining capacity and usage for your license
                                                                                    • Managing Memory
                                                                                      • maximum_memory
                                                                                      • maximum_table_memory
                                                                                      • buffer_manager_cached_memory
                                                                                      • Addressing the “Maximum Table Memory” Error
                                                                                      • Out of Memory on Linux
                                                                                      • Freeing Table Memory
                                                                                      • Managing Plancache Memory Usage
                                                                                      • Changing SingleStoreDB's Memory Limits After Modifying System Memory Capacity
                                                                                      • Changing the Memory Limit for Each Node After Installation
                                                                                    • Setting the Time Zone
                                                                                      • Setting the Time Zone on the Host (Linux OS)
                                                                                      • Setting the Time Zone in SingleStoreDB
                                                                                      • Time Zone Engine Variables
                                                                                    • Rolling Restart in a Cluster
                                                                                    • Taking Leaves Offline without Cluster Downtime
                                                                                      • FAQs
                                                                                    • Taking Leaves Offline with Cluster Downtime
                                                                                    • Changing Leaf Nodes Pairing
                                                                                    • Changing the Default Data Directory Post Installation for a Leaf Node
                                                                                    • Startup Sequence and Process in a Cluster
                                                                                    • Resize Your Cluster
                                                                                      • Cluster Downsizing Steps
                                                                                        • Cluster Downsizing Steps
                                                                                      • Cluster Expansion Steps
                                                                                      • Upgrade or Uninstall SingleStoreDB
                                                                                        • Upgrade SingleStoreDB
                                                                                          • Upgrade to SingleStoreDB 7.5
                                                                                            • Upgrade to SingleStoreDB 7.6
                                                                                              • Uninstall SingleStoreDB
                                                                                                • Select a method to uninstall SingleStoreDB
                                                                                            • Transition from MySQL to SingleStoreDB
                                                                                              • Migrating Data with mysqldump
                                                                                              • Transitioning Your Application
                                                                                            • Troubleshooting
                                                                                              • Introduction
                                                                                                • 1. Identifying Expensive Queries
                                                                                                  • 2. Investigating Expensive Queries
                                                                                                    • 3. Are any queries waiting on something?
                                                                                                      • 4. Are key resources being overused?
                                                                                                        • 5. Are there other ongoing operational activities?
                                                                                                          • 6. Checking Node, Partition, and Overall Database Health
                                                                                                            • 7. Checking Partition Number and Data Skew
                                                                                                              • 8. Checking for System Changes and Log Hints
                                                                                                              • Use the Workload Manager and Set Resource Limits
                                                                                                                • Setting Resource Limits
                                                                                                                  • Creating a New Resource Pool
                                                                                                                  • Modifying an Existing Resource Pool
                                                                                                                  • The Built-in Resource Pools
                                                                                                                  • Setting the resource_pool Value
                                                                                                                  • Finding the Current resource_pool Value
                                                                                                                  • MV_RESOURCE_POOL_STATUS
                                                                                                                  • Query Execution Behavior
                                                                                                                  • Setting the Default Resource Pool for a User
                                                                                                                  • Changing the default resource pool for a user
                                                                                                                  • Selecting a Resource Pool Dynamically
                                                                                                                • Using the Workload Manager
                                                                                                                  • Configuring Workload Management
                                                                                                                  • Query Classification
                                                                                                                  • Queueing Policy
                                                                                                                  • Errors and Warnings
                                                                                                                  • Observing the Status of Workload Management
                                                                                                                • FAQs
                                                                                                              • Migrate from Ops to Tools
                                                                                                                • sudo
                                                                                                                  • Introduction
                                                                                                                  • Install SingleStore Tools
                                                                                                                  • Migrate Cluster
                                                                                                                  • Next Steps
                                                                                                                • non-sudo
                                                                                                                  • Introduction
                                                                                                                  • Install SingleStore Tools
                                                                                                                  • Migrate Cluster
                                                                                                                  • Next Steps
                                                                                                              • Cluster Management with Tools
                                                                                                                • SingleStore Tools Overview
                                                                                                                  • SingleStore Tools Installation
                                                                                                                    • SingleStoreDB Toolbox Installation
                                                                                                                    • SingleStoreDB Studio Installation
                                                                                                                    • SingleStore Client Installation
                                                                                                                  • SingleStoreDB Toolbox
                                                                                                                    • SingleStoreDB Toolbox Command Auto-Completion
                                                                                                                    • sdb-toolbox-config
                                                                                                                    • sdb-deploy
                                                                                                                    • sdb-admin
                                                                                                                    • sdb-report
                                                                                                                    • memsqlctl
                                                                                                                  • SingleStoreDB Studio Overview
                                                                                                                    • SingleStoreDB Studio Installation
                                                                                                                    • SingleStoreDB Studio Upgrade
                                                                                                                    • SingleStoreDB Studio Architecture
                                                                                                                    • SingleStoreDB Studio CLI
                                                                                                                    • SingleStoreDB Studio Security
                                                                                                                    • SingleStoreDB Studio Workload Monitoring
                                                                                                                    • SingleStoreDB Studio SQL Editor
                                                                                                                    • SingleStoreDB Studio Visual Explain
                                                                                                                    • SingleStoreDB Studio WebSocket Proxy
                                                                                                                    • SingleStoreDB Studio Log Rotation
                                                                                                                  • SingleStore Client
                                                                                                                • Dedicated Admin Connections
                                                                                                                • Changing the Root Password
                                                                                                                • Recovering from Loss of Root Credentials
                                                                                                              • Reference
                                                                                                                • Configuration Reference
                                                                                                                  • Configuration Reference Overview
                                                                                                                  • Cluster Configuration
                                                                                                                    • Overview
                                                                                                                    • System Requirements and Recommendations
                                                                                                                    • Configuring SingleStoreDB for NUMA
                                                                                                                    • AVX2 Instruction Set Verification
                                                                                                                    • AWS EC2 Best Practices
                                                                                                                    • Enable AWS CloudTrail Logs for extending the retention of logs
                                                                                                                    • Create a IAM Role
                                                                                                                    • Recommended Configurations to Tolerate Failure of a Cloud AZ or Nearby Data Center
                                                                                                                    • Feedback
                                                                                                                  • System Limits
                                                                                                                    • Cluster-Level Limits
                                                                                                                    • Database-Level Limits
                                                                                                                    • Table-Level Limits
                                                                                                                    • Naming Constraints
                                                                                                                  • Engine Variables
                                                                                                                    • Engine Variables
                                                                                                                    • List of Engine Variables
                                                                                                                    • memsql.cnf
                                                                                                                  • SingleStoreDB Directory Layout
                                                                                                                  • SingleStoreDB Server and memsqld
                                                                                                                    • memsqlctl
                                                                                                                      • Memsqlctl
                                                                                                                      • Memsqlctl Config File (memsqlctl.hcl)
                                                                                                                      • Memsqlctl State File (nodes.hcl)
                                                                                                                    • Toolbox
                                                                                                                      • Toolbox
                                                                                                                      • Toolbox Config File (toolbox.hcl)
                                                                                                                      • Toolbox State File (toolbox-state.hcl)
                                                                                                                      • SingleStoreDB Toolbox and memsqlctl Differences
                                                                                                                  • MemSQL Operator Reference
                                                                                                                    • MemSQL Operator Reference Overview
                                                                                                                    • Additional Deployment Methods
                                                                                                                      • Helm Chart for IBM Cloud Pak for Data
                                                                                                                    • Advanced Service Configuration
                                                                                                                    • Apply Changes to a Cluster
                                                                                                                    • Backups
                                                                                                                      • Change the Admin Password
                                                                                                                        • Configure Core Dumps
                                                                                                                          • Enable Core Dumps
                                                                                                                          • Generate Core Dumps
                                                                                                                          • Core Dump Location
                                                                                                                        • Configure Liveness and Readiness Probes
                                                                                                                        • Configure TLS/SSL/WebSocket
                                                                                                                        • Delete the Cluster or Operator
                                                                                                                          • Disaster Recovery
                                                                                                                          • Generate Cluster Reports
                                                                                                                            • Global Variables
                                                                                                                            • MemSQL Pod Scheduling
                                                                                                                            • Monitor the Cluster
                                                                                                                              • Upload Metrics to Kafka
                                                                                                                            • Mount Additional ConfigMaps/Secrets
                                                                                                                              • Perform an Upgrade
                                                                                                                                • Upgrade the Operator
                                                                                                                                • Upgrade the SingleStoreDB Engine
                                                                                                                              • Pull Images from a Private Registry
                                                                                                                              • Scale a Cluster
                                                                                                                                • Horizontal Scaling
                                                                                                                                • Vertical Scaling
                                                                                                                              • Set System Requirements
                                                                                                                              • Update Exporter CPU and Memory Limits
                                                                                                                              • Verify Cluster Stability
                                                                                                                                • View the Operator Logs
                                                                                                                              • SingleStore Tools Reference
                                                                                                                                • SingleStore Tools Reference
                                                                                                                                • Common Tools Commands
                                                                                                                                  • Common Tool Reference
                                                                                                                                  • env
                                                                                                                                  • help
                                                                                                                                  • version
                                                                                                                                • sdb-admin Commands
                                                                                                                                  • sdb-admin reference
                                                                                                                                  • add-aggregator
                                                                                                                                  • add-leaf
                                                                                                                                  • bootstrap-aggregator
                                                                                                                                  • change-root-password
                                                                                                                                  • configure-monitoring
                                                                                                                                  • create-backup
                                                                                                                                  • create-node
                                                                                                                                  • delete-backup
                                                                                                                                  • delete-node
                                                                                                                                  • describe-node
                                                                                                                                  • disable-nodes-autostart
                                                                                                                                  • dump
                                                                                                                                  • enable-high-availability
                                                                                                                                  • enable-http-api
                                                                                                                                  • enable-nodes-autostart
                                                                                                                                  • enable-systemd-client
                                                                                                                                  • list-backups
                                                                                                                                  • list-nodes
                                                                                                                                  • optimize
                                                                                                                                  • put-file
                                                                                                                                  • query
                                                                                                                                  • register-node
                                                                                                                                  • remove-aggregator
                                                                                                                                  • remove-leaf
                                                                                                                                  • restart-node
                                                                                                                                  • restore-backup
                                                                                                                                  • set-license
                                                                                                                                  • show-aggregators
                                                                                                                                  • show-cluster
                                                                                                                                  • show-leaves
                                                                                                                                  • show-license
                                                                                                                                  • snapshot-database
                                                                                                                                  • start-monitoring
                                                                                                                                  • start-node
                                                                                                                                  • state
                                                                                                                                  • stop-monitoring
                                                                                                                                  • stop-node
                                                                                                                                  • summarize-backups
                                                                                                                                  • sync-ldap
                                                                                                                                  • unregister-node
                                                                                                                                  • update-config
                                                                                                                                  • update-node-basedir
                                                                                                                                  • validate-backup
                                                                                                                                • sdb-deploy Commands
                                                                                                                                  • sdb-deploy Reference
                                                                                                                                  • cluster-in-a-box
                                                                                                                                  • destroy-cluster
                                                                                                                                  • generate-cluster-file
                                                                                                                                  • install
                                                                                                                                  • list-versions
                                                                                                                                  • setup-cluster
                                                                                                                                  • state
                                                                                                                                  • ui
                                                                                                                                  • uninstall
                                                                                                                                  • upgrade
                                                                                                                                • sdb-report Commands
                                                                                                                                  • sdb-report Reference
                                                                                                                                  • calibrate
                                                                                                                                  • calibrate-blob-storage
                                                                                                                                  • check
                                                                                                                                  • collect
                                                                                                                                  • collect-and-check
                                                                                                                                  • collect-kube
                                                                                                                                  • collect-local
                                                                                                                                  • send-alert
                                                                                                                                  • state
                                                                                                                                • sdb-toolbox-config Commands
                                                                                                                                  • sdb-toolbox-config Reference
                                                                                                                                  • describe-host
                                                                                                                                  • list-hosts
                                                                                                                                  • register-host
                                                                                                                                  • state
                                                                                                                                  • unregister-host
                                                                                                                                • memsqlctl Commands
                                                                                                                                  • memsqlctl Reference
                                                                                                                                  • add-aggregator
                                                                                                                                  • add-leaf
                                                                                                                                  • bootstrap-aggregator
                                                                                                                                  • change-root-password
                                                                                                                                  • collect-garbage
                                                                                                                                  • create-node
                                                                                                                                  • delete-node
                                                                                                                                  • describe-node
                                                                                                                                  • enable-high-availability
                                                                                                                                  • list-nodes
                                                                                                                                  • optimize
                                                                                                                                  • query
                                                                                                                                  • register-node
                                                                                                                                  • remove-aggregator
                                                                                                                                  • remove-leaf
                                                                                                                                  • restart-node
                                                                                                                                  • set-license
                                                                                                                                  • show-aggregators
                                                                                                                                  • show-cluster
                                                                                                                                  • show-leaves
                                                                                                                                  • show-license
                                                                                                                                  • start-node
                                                                                                                                  • stop-node
                                                                                                                                  • unregister-node
                                                                                                                                  • update-config
                                                                                                                                  • update-node-basedir
                                                                                                                              • SQL Reference
                                                                                                                                • SQL Reference Overview
                                                                                                                                • Comparison Operators and Functions
                                                                                                                                  • BETWEEN, NOT BETWEEN
                                                                                                                                  • NULL Handling
                                                                                                                                  • LIKE, NOT LIKE
                                                                                                                                  • IN(), NOT IN()
                                                                                                                                  • strcmp()
                                                                                                                                  • Where operators can be used
                                                                                                                                  • Using Comparison Operators with Date and Time Functions
                                                                                                                                • Database Object Case-Sensitivity
                                                                                                                                • Data Types
                                                                                                                                  • Integer Numbers
                                                                                                                                  • Real Numbers
                                                                                                                                  • Time and Date
                                                                                                                                  • String Types
                                                                                                                                  • BLOB Types
                                                                                                                                  • JSON Type
                                                                                                                                  • Geospatial Types
                                                                                                                                  • SingleStoreDB (MemSQL) Procedural SQL (MPSQL) Types
                                                                                                                                  • Other Types
                                                                                                                                  • Comparing mismatched datatypes
                                                                                                                                  • Data Type Conversion
                                                                                                                                • Character Encoding
                                                                                                                                  • Working with Character Sets and Collations
                                                                                                                                  • Character Sets Supported
                                                                                                                                  • Collations Supported
                                                                                                                                  • Default Character Set and Collation
                                                                                                                                  • Specifying Character Set and Collation Cluster-Wide
                                                                                                                                  • Character Set and Collation Override
                                                                                                                                  • Implicit Collation in Special Cases
                                                                                                                                • Operations that Take Either a Database or a Cluster Lock
                                                                                                                                  • Database Locks
                                                                                                                                  • Cluster Locks
                                                                                                                                  • Operations that Take Database Locks
                                                                                                                                  • Operations that Take Cluster Locks
                                                                                                                                • User-Defined Variables
                                                                                                                                  • SELECT ... INTO User Defined Variable
                                                                                                                                • Restricted Keywords
                                                                                                                                  • Escaping Restricted Keywords
                                                                                                                                  • List of Restricted Keywords
                                                                                                                                • Aggregate Functions
                                                                                                                                  • Aggregate Functions
                                                                                                                                  • ANY_VALUE
                                                                                                                                  • APPROX_PERCENTILE
                                                                                                                                  • AVG
                                                                                                                                  • BIT_AND
                                                                                                                                  • BIT_OR
                                                                                                                                  • BIT_XOR
                                                                                                                                  • COUNT
                                                                                                                                  • GROUP_CONCAT
                                                                                                                                  • MAX
                                                                                                                                  • MEDIAN
                                                                                                                                  • MIN
                                                                                                                                  • MOD
                                                                                                                                  • STD
                                                                                                                                  • STDDEV_SAMP
                                                                                                                                  • SUM
                                                                                                                                  • VARIANCE
                                                                                                                                  • VAR_SAMP
                                                                                                                                • Cluster Management Commands
                                                                                                                                  • Cluster Management Commands
                                                                                                                                  • Node Requirements for SingleStoreDB Commands
                                                                                                                                  • Leaf States
                                                                                                                                  • ADD AGGREGATOR
                                                                                                                                  • ADD LEAF
                                                                                                                                  • AGGREGATOR SET AS MASTER
                                                                                                                                  • ATTACH LEAF
                                                                                                                                  • ATTACH LEAF ALL
                                                                                                                                  • BOOTSTRAP AGGREGATOR
                                                                                                                                  • DETACH LEAF
                                                                                                                                  • EXPLAIN REBALANCE ALL DATABASES
                                                                                                                                  • EXPLAIN REBALANCE PARTITIONS
                                                                                                                                  • EXPLAIN RESTORE REDUNDANCY
                                                                                                                                  • FILL and FLUSH CONNECTION POOLS
                                                                                                                                  • FLUSH HOSTS
                                                                                                                                  • PROMOTE AGGREGATOR … TO MASTER
                                                                                                                                  • REBALANCE ALL DATABASES
                                                                                                                                  • REBALANCE PARTITIONS
                                                                                                                                  • REMOVE AGGREGATOR
                                                                                                                                  • REMOVE LEAF
                                                                                                                                  • RESTORE REDUNDANCY
                                                                                                                                  • SHOW AGGREGATORS
                                                                                                                                  • SHOW LEAVES
                                                                                                                                  • SHOW CLUSTER STATUS
                                                                                                                                  • SHOW REBALANCE ALL DATABASES STATUS
                                                                                                                                  • SHOW REBALANCE STATUS
                                                                                                                                  • TRIGGER GC
                                                                                                                                • Code Generation Functions
                                                                                                                                  • NOPARAM
                                                                                                                                • Conditional Functions
                                                                                                                                  • Conditional Functions
                                                                                                                                  • CASE
                                                                                                                                  • COALESCE
                                                                                                                                  • CAST or CONVERT
                                                                                                                                  • DECODE
                                                                                                                                  • ELT
                                                                                                                                  • GREATEST
                                                                                                                                  • IF
                                                                                                                                  • ISNULL
                                                                                                                                  • LEAST
                                                                                                                                  • NULLIF
                                                                                                                                  • NVL and IFNULL
                                                                                                                                  • SLEEP
                                                                                                                                • Data Definition Language DDL
                                                                                                                                  • Data Definition Language DDL
                                                                                                                                  • ALTER DATABASE
                                                                                                                                  • ALTER TABLE
                                                                                                                                  • ALTER VIEW
                                                                                                                                  • ATTACH DATABASE
                                                                                                                                  • CREATE DATABASE
                                                                                                                                  • CREATE INDEX
                                                                                                                                  • CREATE MILESTONE
                                                                                                                                  • CREATE VIEW
                                                                                                                                  • CREATE TABLE
                                                                                                                                  • DESCRIBE
                                                                                                                                  • DETACH DATABASE
                                                                                                                                  • DROP DATABASE
                                                                                                                                  • DROP INDEX
                                                                                                                                  • DROP … FROM PLANCACHE
                                                                                                                                  • DROP RESULT TABLE
                                                                                                                                  • DROP TABLE
                                                                                                                                  • DROP VIEW
                                                                                                                                  • FLUSH TABLES
                                                                                                                                  • OPTIMIZE TABLE
                                                                                                                                  • TRUNCATE
                                                                                                                                  • UNLOCK TABLES
                                                                                                                                • Data Manipulation Language DML
                                                                                                                                  • Data Manipulation Language DML
                                                                                                                                  • AGGREGATOR SYNC AUTO_INCREMENT
                                                                                                                                  • BEGIN
                                                                                                                                  • CLEAR LOAD ERRORS
                                                                                                                                  • COMMIT
                                                                                                                                  • CUBE and ROLLUP
                                                                                                                                  • DELETE
                                                                                                                                  • EXCEPT and MINUS
                                                                                                                                  • EXISTS AND NOT EXISTS
                                                                                                                                  • EXPLAIN
                                                                                                                                  • INSERT
                                                                                                                                  • INTERSECT
                                                                                                                                  • LOAD DATA
                                                                                                                                  • PROFILE
                                                                                                                                  • PIVOT
                                                                                                                                  • REPLACE
                                                                                                                                  • ROLLBACK
                                                                                                                                  • SELECT
                                                                                                                                  • TABLE
                                                                                                                                  • UNION
                                                                                                                                  • UPDATE
                                                                                                                                  • USE
                                                                                                                                  • WITH (Common Table Expressions)
                                                                                                                                  • Materializing Common Table Expressions
                                                                                                                                  • Query Plan Operations
                                                                                                                                • Date and Time Functions
                                                                                                                                  • Date and Time Functions
                                                                                                                                  • ADDTIME
                                                                                                                                  • CONVERT_TZ
                                                                                                                                  • CURRENT_DATE And CURDATE
                                                                                                                                  • CURRENT_TIME And CURTIME
                                                                                                                                  • 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
                                                                                                                                  • MICROSECOND
                                                                                                                                  • MINUTE
                                                                                                                                  • MONTH
                                                                                                                                  • MONTHNAME
                                                                                                                                  • MONTHS_BETWEEN
                                                                                                                                  • NOW
                                                                                                                                  • QUARTER
                                                                                                                                  • SECOND
                                                                                                                                  • SEC_TO_TIME
                                                                                                                                  • STR_TO_DATE
                                                                                                                                  • TIME
                                                                                                                                  • TIMEDIFF
                                                                                                                                  • TIMESTAMP
                                                                                                                                  • TIMESTAMPADD
                                                                                                                                  • TIMESTAMPDIFF
                                                                                                                                  • TIME_FORMAT
                                                                                                                                  • TIME_TO_SEC
                                                                                                                                  • TO_CHAR
                                                                                                                                  • TO_DATE
                                                                                                                                  • TO_DAYS
                                                                                                                                  • TO_SECONDS
                                                                                                                                  • TO_TIMESTAMP
                                                                                                                                  • TRUNC
                                                                                                                                  • UNIX_TIMESTAMP
                                                                                                                                  • UTC_DATE
                                                                                                                                  • UTC_TIME
                                                                                                                                  • UTC_TIMESTAMP
                                                                                                                                  • WEEK
                                                                                                                                  • WEEKDAY
                                                                                                                                  • YEAR
                                                                                                                                • Distinct Count Estimation Functions
                                                                                                                                  • Distinct Count Estimation Functions
                                                                                                                                  • APPROX_COUNT_DISTINCT
                                                                                                                                  • APPROX_COUNT_DISTINCT_ACCUMULATE
                                                                                                                                  • APPROX_COUNT_DISTINCT_COMBINE
                                                                                                                                  • APPROX_COUNT_DISTINCT_ESTIMATE
                                                                                                                                • Full-Text Search Functions
                                                                                                                                  • Full-Text Search Functions
                                                                                                                                  • HIGHLIGHT
                                                                                                                                  • MATCH
                                                                                                                                • Geospatial Functions
                                                                                                                                  • Geospatial Functions
                                                                                                                                  • APPROX_GEOGRAPHY_INTERSECTS
                                                                                                                                  • GEOGRAPHY_AREA
                                                                                                                                  • GEOGRAPHY_CONTAINS
                                                                                                                                  • GEOGRAPHY_DISTANCE
                                                                                                                                  • GEOGRAPHY_INTERSECTS
                                                                                                                                  • GEOGRAPHY_LATITUDE
                                                                                                                                  • GEOGRAPHY_LENGTH
                                                                                                                                  • GEOGRAPHY_LONGITUDE
                                                                                                                                  • GEOGRAPHY_POINT
                                                                                                                                  • GEOGRAPHY_WITHIN_DISTANCE
                                                                                                                                • Identifier Generation Functions
                                                                                                                                  • SYS_GUID and UUID
                                                                                                                                • Information Functions
                                                                                                                                  • Information Functions
                                                                                                                                  • CONNECTION_ID
                                                                                                                                  • DATABASE
                                                                                                                                  • ESTIMATED_QUERY_LEAF_MEMORY
                                                                                                                                  • ESTIMATED_QUERY_RUNTIME
                                                                                                                                  • FOUND_ROWS
                                                                                                                                  • LAST_INSERT_ID
                                                                                                                                  • ROW_COUNT
                                                                                                                                  • USER
                                                                                                                                • JSON Functions
                                                                                                                                  • JSON Functions
                                                                                                                                  • JSON_AGG
                                                                                                                                  • JSON_ARRAY_CONTAINS_<type>
                                                                                                                                  • JSON_ARRAY_PUSH_<type>
                                                                                                                                  • JSON_BUILD_OBJECT
                                                                                                                                  • JSON_DELETE_KEY
                                                                                                                                  • JSON_EXTRACT_<type>
                                                                                                                                  • JSON_GET_TYPE
                                                                                                                                  • JSON Keypaths
                                                                                                                                  • JSON_LENGTH
                                                                                                                                  • JSON_PRETTY
                                                                                                                                  • JSON_SET_<type>
                                                                                                                                  • JSON_SPLICE_<type>
                                                                                                                                  • JSON_TO_ARRAY
                                                                                                                                  • TO_JSON
                                                                                                                                • Numeric Functions
                                                                                                                                  • Numeric Functions
                                                                                                                                  • 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
                                                                                                                                  • SIGMOID
                                                                                                                                  • SIN
                                                                                                                                  • SQRT
                                                                                                                                  • TAN
                                                                                                                                  • TO_NUMBER
                                                                                                                                  • TRUNC
                                                                                                                                  • TRUNCATE
                                                                                                                                • Operational Commands
                                                                                                                                  • Operational Commands
                                                                                                                                  • ANALYZE
                                                                                                                                  • ATTACH DATABASE
                                                                                                                                  • BACKUP DATABASE
                                                                                                                                  • CHECK BLOB CHECKSUM
                                                                                                                                  • CHECK BOTTOMLESS CHECKSUM
                                                                                                                                  • CLEAR ORPHAN DATABASES
                                                                                                                                  • CONTINUE REPLICATING
                                                                                                                                  • DETACH DATABASE
                                                                                                                                  • KILL CONNECTION
                                                                                                                                  • KILLALL QUERIES
                                                                                                                                  • PAUSE REPLICATING
                                                                                                                                  • REPAIR DATABASE
                                                                                                                                  • REPLICATE DATABASE
                                                                                                                                  • RESTORE DATABASE
                                                                                                                                  • SELECT GLOBAL
                                                                                                                                  • SET AGGREGATOR
                                                                                                                                  • SET and SET SESSION
                                                                                                                                  • SET CLUSTER
                                                                                                                                  • SET GLOBAL
                                                                                                                                  • SET LEAF
                                                                                                                                  • SHOW REPLICATION STATUS
                                                                                                                                  • SNAPSHOT DATABASE
                                                                                                                                  • STOP REPLICATING
                                                                                                                                  • Replication Distribution Tree
                                                                                                                                • Pipelines Commands
                                                                                                                                  • Pipelines Commands
                                                                                                                                  • ALTER PIPELINE
                                                                                                                                  • CREATE PIPELINE
                                                                                                                                  • CREATE PIPELINE ... WITH TRANSFORM
                                                                                                                                  • CREATE PIPELINE ... INTO PROCEDURE
                                                                                                                                  • Additional CREATE PIPELINE Examples
                                                                                                                                  • DETACH PIPELINE
                                                                                                                                  • DROP PIPELINE
                                                                                                                                  • EXTRACT PIPELINE … INTO OUTFILE
                                                                                                                                  • PROFILE PIPELINE
                                                                                                                                  • START PIPELINE
                                                                                                                                  • STOP PIPELINE
                                                                                                                                  • TEST PIPELINE
                                                                                                                                • Procedural SQL Reference
                                                                                                                                  • Procedural SQL Reference
                                                                                                                                  • Anonymous Code Blocks
                                                                                                                                  • Control Flow Statements
                                                                                                                                  • Exceptions and Exception Handling
                                                                                                                                  • MySQL Client Delimiters
                                                                                                                                  • Transactions in Stored Procedures
                                                                                                                                  • CREATE AGGREGATE
                                                                                                                                  • CREATE FUNCTION (UDF)
                                                                                                                                  • CREATE FUNCTION (TVF)
                                                                                                                                  • CREATE PROCEDURE
                                                                                                                                  • CREATE [OR REPLACE] TEMPORARY PROCEDURE …
                                                                                                                                  • DROP FUNCTION
                                                                                                                                  • DROP PROCEDURE
                                                                                                                                  • DROP AGGREGATE
                                                                                                                                  • SHOW AGGREGATES
                                                                                                                                  • SHOW CREATE FUNCTION
                                                                                                                                  • SHOW CREATE AGGREGATE
                                                                                                                                  • SHOW FUNCTIONS
                                                                                                                                  • SHOW PROCEDURES
                                                                                                                                  • ARRAY
                                                                                                                                  • CALL
                                                                                                                                  • CREATE_ARRAY
                                                                                                                                  • COLLECT
                                                                                                                                  • ECHO
                                                                                                                                  • ECHO SELECT
                                                                                                                                  • EXECUTE IMMEDIATE
                                                                                                                                  • INSERT_ALL
                                                                                                                                  • RECORD
                                                                                                                                  • ROW
                                                                                                                                  • QUERY
                                                                                                                                  • SCALAR
                                                                                                                                  • TO_QUERY
                                                                                                                                • Regular Expression Functions
                                                                                                                                  • Regular Expression Commands
                                                                                                                                  • REGEXP_INSTR
                                                                                                                                  • REGEXP_REPLACE
                                                                                                                                  • REGEXP_SUBSTR
                                                                                                                                  • RLIKE and REGEXP
                                                                                                                                • Resource Pool Commands
                                                                                                                                  • Resource Pool Commands and Functions
                                                                                                                                  • ALTER RESOURCE POOL
                                                                                                                                  • CREATE RESOURCE POOL
                                                                                                                                  • DROP RESOURCE POOL
                                                                                                                                  • SHOW RESOURCE POOLS
                                                                                                                                • Security Management Commands
                                                                                                                                  • Security Management Commands
                                                                                                                                  • ALTER USER
                                                                                                                                  • CREATE GROUP
                                                                                                                                  • CREATE LINK
                                                                                                                                  • CREATE ROLE
                                                                                                                                  • CREATE USER
                                                                                                                                  • CURRENT_SECURITY_GROUPS
                                                                                                                                  • CURRENT_SECURITY_ROLES
                                                                                                                                  • CURRENT_USER
                                                                                                                                  • DROP GROUP
                                                                                                                                  • DROP LINK
                                                                                                                                  • DROP ROLE
                                                                                                                                  • DROP USER
                                                                                                                                  • GRANT
                                                                                                                                  • GRANT GROUP
                                                                                                                                  • GRANT ROLE
                                                                                                                                  • REVOKE
                                                                                                                                  • REVOKE GROUP
                                                                                                                                  • REVOKE ROLE
                                                                                                                                  • SECURITY_LISTS_INTERSECT
                                                                                                                                  • SET PASSWORD
                                                                                                                                  • SHOW GRANTS
                                                                                                                                  • SHOW GROUPS
                                                                                                                                  • SHOW GROUPS FOR ROLE
                                                                                                                                  • SHOW GROUPS FOR USER
                                                                                                                                  • SHOW LINKS
                                                                                                                                  • 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
                                                                                                                                  • SHOW Commands
                                                                                                                                  • SHOW CREATE PIPELINE
                                                                                                                                  • SHOW COLUMNS
                                                                                                                                  • SHOW CREATE TABLE
                                                                                                                                  • SHOW CREATE VIEW
                                                                                                                                  • SHOW DATABASES
                                                                                                                                  • SHOW DATABASE STATUS
                                                                                                                                  • SHOW ERRORS
                                                                                                                                  • SHOW GLOBAL STATUS
                                                                                                                                  • SHOW INDEX, SHOW INDEXES, SHOW KEYS
                                                                                                                                  • SHOW INDEXES
                                                                                                                                  • SHOW KEYS
                                                                                                                                  • SHOW LOAD ERRORS
                                                                                                                                  • SHOW LOAD WARNINGS
                                                                                                                                  • SHOW PARTITIONS
                                                                                                                                  • SHOW PIPELINES
                                                                                                                                  • SHOW PLAN
                                                                                                                                  • SHOW PLANCACHE
                                                                                                                                  • SHOW PROCESSLIST
                                                                                                                                  • SHOW REPRODUCTION
                                                                                                                                  • SHOW SCHEMAS
                                                                                                                                  • SHOW SESSION STATUS
                                                                                                                                  • SHOW STATUS EXTENDED
                                                                                                                                  • SHOW TABLE STATUS
                                                                                                                                  • SHOW TABLES
                                                                                                                                  • SHOW VARIABLES
                                                                                                                                  • SHOW WARNINGS
                                                                                                                                  • System Status
                                                                                                                                • String Functions
                                                                                                                                  • String Functions
                                                                                                                                  • AES_DECRYPT
                                                                                                                                  • AES_ENCRYPT
                                                                                                                                  • ASCII
                                                                                                                                  • BIN
                                                                                                                                  • BINARY
                                                                                                                                  • CHAR
                                                                                                                                  • CHARACTER_LENGTH
                                                                                                                                  • CHARSET
                                                                                                                                  • CONCAT
                                                                                                                                  • CONCAT_WS
                                                                                                                                  • CRC32
                                                                                                                                  • FIELD
                                                                                                                                  • FORMAT
                                                                                                                                  • FROM_BASE64
                                                                                                                                  • QUOTE
                                                                                                                                  • HEX
                                                                                                                                  • INET_ATON
                                                                                                                                  • INET_NTOA
                                                                                                                                  • INET6_ATON
                                                                                                                                  • INET6_NTOA
                                                                                                                                  • INITCAP
                                                                                                                                  • INSTR
                                                                                                                                  • LCASE
                                                                                                                                  • LEFT
                                                                                                                                  • LENGTH
                                                                                                                                  • LOCATE
                                                                                                                                  • LPAD
                                                                                                                                  • LTRIM
                                                                                                                                  • MD5
                                                                                                                                  • REPLACE
                                                                                                                                  • RIGHT
                                                                                                                                  • RPAD
                                                                                                                                  • RTRIM
                                                                                                                                  • SHA1
                                                                                                                                  • SHA2
                                                                                                                                  • SPLIT
                                                                                                                                  • STRING_BYTES
                                                                                                                                  • SUBSTRING
                                                                                                                                  • SUBSTRING_INDEX
                                                                                                                                  • TO_BASE64
                                                                                                                                  • TRIM
                                                                                                                                  • UCASE
                                                                                                                                  • UNHEX
                                                                                                                                • Time Series Functions
                                                                                                                                  • Time Series Functions
                                                                                                                                  • FIRST
                                                                                                                                  • LAST
                                                                                                                                  • TIME_BUCKET
                                                                                                                                • Vector Functions
                                                                                                                                  • Vector Functions
                                                                                                                                  • DOT_PRODUCT
                                                                                                                                  • EUCLIDEAN_DISTANCE
                                                                                                                                  • JSON_ARRAY_PACK
                                                                                                                                  • VECTOR_SUB
                                                                                                                                  • VECTOR_SUM
                                                                                                                                • Window Functions
                                                                                                                                  • Window Functions
                                                                                                                                  • DENSE_RANK
                                                                                                                                  • FIRST_VALUE
                                                                                                                                  • LAG
                                                                                                                                  • LAST_VALUE
                                                                                                                                  • LEAD
                                                                                                                                  • NTH_VALUE
                                                                                                                                  • NTILE
                                                                                                                                  • PERCENT_RANK
                                                                                                                                  • PERCENTILE_CONT and MEDIAN
                                                                                                                                  • PERCENTILE_DISC
                                                                                                                                  • RANK
                                                                                                                                  • ROW_NUMBER
                                                                                                                              • Troubleshooting Reference
                                                                                                                                • Troubleshooting Overview
                                                                                                                                • Counting Partitions by Role
                                                                                                                                • Capacity Limit Error
                                                                                                                                  • ERROR 2350: Leaf node could not be added because you are using the SingleStoreDB free license which has a limit of 4 license units and after adding the node you would be using XX license units.
                                                                                                                                  • ERROR 2349: Code generation for new statements is disabled because the total number of license units of capacity used on all leaf nodes is XX, which is above the limit of 4 for the SingleStoreDB free license.
                                                                                                                                  • WARN: The ready queue has not decreased (currently <num> elements, <num> pops) for <num> seconds. This workload needs more threads.
                                                                                                                                  • Leaf Error (HOST:PORT): Unable to connect to leaf @HOST:PORT with user USER, using password YES/NO: [1040] Too many connections.
                                                                                                                                • Dealing with Cluster Failures
                                                                                                                                  • Assess the Situation
                                                                                                                                  • Tools: Leaf Node Failures
                                                                                                                                  • Tools: Aggregator Failures
                                                                                                                                  • Leaf Node Recovery Failed Scenario
                                                                                                                                • How Failover is Triggered in HA
                                                                                                                                • Disk Capacity Errors
                                                                                                                                  • ERROR: “Available disk space is below the value of minimal_disk_space global variable (512 MB). This query cannot be executed.”
                                                                                                                                • Diagnosing a Performance Issue Using Workload Profiling
                                                                                                                                  • Use Case: Disk Bottleneck
                                                                                                                                  • Use Case: Memory Usage by a Query
                                                                                                                                • Generating a Cluster Report
                                                                                                                                  • Generating the Report
                                                                                                                                  • Submitting the Report to SingleStore Support
                                                                                                                                • Identifying and Reducing Memory Usage
                                                                                                                                  • Summary variables
                                                                                                                                  • Other variables
                                                                                                                                  • Row store variables
                                                                                                                                  • Deleting Row Store Table Data When at the Memory Limit
                                                                                                                                  • Reducing Memory Use by Row Store Tables
                                                                                                                                  • Columnstore Table Considerations
                                                                                                                                  • Understanding Memory and Disk Usage with Studio
                                                                                                                                • Memory Errors
                                                                                                                                  • ERROR 2350: Leaf or aggregator node could not be added because you are using the SingleStoreDB free license which has a total memory limit of 128.00 GB
                                                                                                                                  • ERROR 2349: Code generation for new statements is disabled because the total of maximum_memory on all nodes (used_cluster_capacity) is XXX.00 GB which is above the limit of 128.00 GB for the SingleStoreDB free license.
                                                                                                                                  • Failed to allocate XXXXX bytes of memory from the operating system (Error 12: Cannot allocate memory). This is usually due to a misconfigured operating system or virtualization technology.
                                                                                                                                  • ERROR 1712: Not enough memory available to complete the current request. The request was not processed.
                                                                                                                                  • ERROR: 1720 - “Memory usage by SingleStoreDB for tables (XXXXX MB) has reached the value of ‘maximum_table_memory’ global variable (YYYYY MB). This query cannot be executed.”
                                                                                                                                  • ERROR: "Nonfatal buffer manager memory allocation failure. The maximum_memory parameter (XXXXX MB) has been reached.
                                                                                                                                • SingleStore Tools Issues
                                                                                                                                  • ISSUE: Getting prompted for user’s sudo password
                                                                                                                                  • ISSUE: We were unable to check whether this is an official version
                                                                                                                                  • ISSUE: Failed to add user to the memsql group.
                                                                                                                                  • ISSUE: memsqlctl is configured to require that users be in the “memsql” group for read access
                                                                                                                                • Network Errors
                                                                                                                                  • ERROR 1158 (08S01): Leaf Error (): Error reading packet ### from the connection socket (): Connection timed out
                                                                                                                                  • ERROR 1735: Unable to connect … Timed out reading from socket
                                                                                                                                  • ERROR 1970 (HY000): Subprocess /var/lib/memsql/master-3306/extractors/kafka-extract –get-offsets –kafka-version=0.8.2.2 timed out
                                                                                                                                  • ERROR 2002 (HY000): Can’t connect to local MySQL server through socket “/var/run/mysqld/mysqld.sock”
                                                                                                                                  • ERROR 2026 (HY000): SSL connection error: SSL_CTX_set_default_verify_paths failed
                                                                                                                                  • ERROR 2026 (HY000): SSL connection error: SSL is required but the server doesn’t support it
                                                                                                                                  • ERROR: Distributed Join Error. Leaf X cannot connect to Leaf Y.
                                                                                                                                • Operations Errors
                                                                                                                                  • ERROR 1218 (08S01): Error connecting to master: master is running an incompatible version of MemSQL
                                                                                                                                  • ERROR 1795: Cannot SHOW PARTITIONS. Database memsql is not sharded.
                                                                                                                                  • ERROR 1832 (HY000): Restoring partitions on %s. Couldn’t find backup file for partition # of database X (there are ### partitions without backup files).
                                                                                                                                  • ERROR: Partition’s table metadata are out of sync for table
                                                                                                                                  • Transform for pipeline <pipeline_name> exited with “FAILURE”. Truncated stderr:
                                                                                                                                • Query Errors
                                                                                                                                  • ISSUE: Inconsistent Query Run Times
                                                                                                                                  • ISSUE: Long Running Queries Blocking DDL Operations and Workload
                                                                                                                                  • ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
                                                                                                                                  • ERROR 1706 (HY000): Feature “Multi-table UPDATE/DELETE with a reference table as target table” is not supported by MemSQL
                                                                                                                                  • ERROR 1706 (HY000): Leaf Error (127.0.0.1:3307): Feature “INSERT IGNORE … ON DUPLICATE KEY UPDATE” is not supported by MemSQL
                                                                                                                                  • ERROR 2408 (HY000): ER_COMPILATION_TIMEOUT: Query compilation timed out and cannot be executed
                                                                                                                                  • ERROR 1064 ER_PARSE_ERROR: Unhandled exception Type: ER_PARSE_ERROR (1064)
                                                                                                                                  • ERROR 1956 ER_PARAMETER_CAPACITY_EXCEEDED: Query cannot be completed because the parameter array capacity of 1048576 was exceeded.
                                                                                                                                  • Error: "Query execution memory use (XXX MB) has reached the maximum memory for its resource pool 'xxx' (XX%). “
                                                                                                                                • Trace Log
                                                                                                                                  • Location and Management
                                                                                                                                  • Log Rotation
                                                                                                                                  • Deleting Trace Log
                                                                                                                                  • Logging Queries
                                                                                                                                • Pipeline Errors
                                                                                                                                  • Detect and Address Slow Performance and High Memory Usage of Pipelines
                                                                                                                                  • View and Handle Pipeline Errors
                                                                                                                                  • S3 Authentication Errors
                                                                                                                                • Understanding Orphaned Partitions
                                                                                                                                  • Identifying Orphaned Partitions
                                                                                                                                  • Addressing Orphans by Attaching New Partitions
                                                                                                                                  • Removing Orphaned Partitions that are not Needed
                                                                                                                              • System Databases
                                                                                                                              • Information Schema Reference
                                                                                                                                • Information Schema
                                                                                                                                  • Introduction
                                                                                                                                  • Accessing the Information Schema
                                                                                                                                  • Examples
                                                                                                                                • Cluster Component Tables
                                                                                                                                  • information_schema.AGGREGATORS
                                                                                                                                  • information_schema.MV_BLOB_CACHE_EVENTS
                                                                                                                                  • information_schema.MV_CACHED_BLOBS
                                                                                                                                  • information_schema.CHARACTER_SETS
                                                                                                                                  • information_schema.COLLATIONS
                                                                                                                                  • information_schema.COLLATION_CHARACTER_SET_APPLICABILITY
                                                                                                                                  • information_schema.COLUMNS
                                                                                                                                  • information_schema.DISTRIBUTED_DATABASES
                                                                                                                                  • information_schema.DISTRIBUTED_PARTITIONS
                                                                                                                                  • information_schema.LEAVES
                                                                                                                                  • information_schema.MV_CLUSTER_STATUS
                                                                                                                                  • information_schema.MV_DISTRIBUTED_DATABASES_STATUS
                                                                                                                                  • information_schema.MV_EVENTS
                                                                                                                                  • information_schema.MV_HOSTS_INFORMATION
                                                                                                                                  • information_schema.PARAMETERS
                                                                                                                                  • information_schema.ROUTINES
                                                                                                                                  • information_schema.SCHEMATA
                                                                                                                                  • information_schema.SITES
                                                                                                                                  • information_schema.TABLES
                                                                                                                                  • information_schema.TABLE_CONSTRAINTS
                                                                                                                                  • information_schema.VIEWS
                                                                                                                                • Management Tables
                                                                                                                                  • Concepts and Terminology
                                                                                                                                  • mv_activities
                                                                                                                                  • mv_activities_extended
                                                                                                                                  • mv_activities_cumulative
                                                                                                                                  • mv_activities_extended_cumulative
                                                                                                                                  • mv_aggregated_column_usage
                                                                                                                                  • mv_aggregated_replication_status
                                                                                                                                  • mv_blocked_queries
                                                                                                                                  • mv_collected_row_change_counts
                                                                                                                                  • mv_finished_tasks
                                                                                                                                  • mv_global_status
                                                                                                                                  • mv_global_variables
                                                                                                                                  • mv_nodes
                                                                                                                                  • mv_queries
                                                                                                                                  • mv_query_activities
                                                                                                                                  • mv_query_activities_extended_cumulative
                                                                                                                                  • mv_query_column_usage
                                                                                                                                  • lmv_replication_status
                                                                                                                                  • mv_replication_status
                                                                                                                                  • mv_row_change_counts
                                                                                                                                  • mv_sysinfo_cpu
                                                                                                                                  • mv_sysinfo_cpulist
                                                                                                                                  • mv_sysinfo_disk
                                                                                                                                  • mv_sysinfo_mem
                                                                                                                                  • mv_sysinfo_net
                                                                                                                                  • mv_tasks
                                                                                                                                • Management Statistics Reference
                                                                                                                                  • Extended Statistics
                                                                                                                                  • Simplified Statistics
                                                                                                                                  • Statistics Availability
                                                                                                                                  • Advanced Statistics
                                                                                                                                  • Understanding memory_bs
                                                                                                                                • Query Performance, Workload Management, and Statistics Tables
                                                                                                                                  • information_schema.ADVANCED_HISTOGRAMS
                                                                                                                                  • information_schema.AGGREGATE_FUNCTIONS
                                                                                                                                  • information_schema.COLUMN_STATISTICS
                                                                                                                                  • information_schema.INDEX_STATISTICS
                                                                                                                                  • information_schema.LMV_JOIN_OPTIMIZATION_RESULTS
                                                                                                                                  • information_schema.LMV_PROFILE_STATS
                                                                                                                                  • information_schema.MV_BACKUP_HISTORY
                                                                                                                                  • information_schema.MV_BACKUP_STATUS
                                                                                                                                  • information_schema.MV_BT
                                                                                                                                  • information_schema.MV_PLANCACHE
                                                                                                                                  • information_schema.MV_PROCESSLIST
                                                                                                                                  • information_schema.MV_PROSPECTIVE_HISTOGRAMS
                                                                                                                                  • information_schema.MV_QUERY_PROSPECTIVE_HISTOGRAMS
                                                                                                                                  • information_schema.MV_WORKLOAD_MANAGEMENT_STATUS
                                                                                                                                  • information_schema.OPTIMIZER_STATISTICS
                                                                                                                                  • information_schema.PLANCACHE
                                                                                                                                  • information_schema.RANGE_STATISTICS
                                                                                                                                  • information_schema.STATISTICS
                                                                                                                                  • information_schema.TABLE_STATISTICS
                                                                                                                                  • information_schema.USER_VARIABLES
                                                                                                                                • Pipelines Tables
                                                                                                                                  • PIPELINES
                                                                                                                                  • PIPELINES_BATCHES_SUMMARY
                                                                                                                                  • PIPELINES_BATCHES
                                                                                                                                  • PIPELINES_ERRORS
                                                                                                                                  • PIPELINES_CURSORS
                                                                                                                                  • PIPELINES_FILES
                                                                                                                                • Resource and User Management Tables
                                                                                                                                  • information_schema.AVAILABILITY_GROUPS
                                                                                                                                  • information_schema.CURRENT_USER_GROUPS
                                                                                                                                  • information_schema.CURRENT_USER_ROLES
                                                                                                                                  • information_schema.GROUP_PRIVILEGES
                                                                                                                                  • information_schema.GROUPS_ROLES
                                                                                                                                  • information_schema.MV_RESOURCE_POOL_STATUS
                                                                                                                                  • information_schema.RESOURCE_POOLS
                                                                                                                                  • information_schema.ROLE_PRIVILEGES
                                                                                                                                  • information_schema.SCHEMA_PRIVILEGES
                                                                                                                                  • information_schema.TABLE_PRIVILEGES
                                                                                                                                  • information_schema.USER_PRIVILEGES
                                                                                                                                  • information_schema.USERS
                                                                                                                                  • information_schema.USERS_GROUPS
                                                                                                                                • Segment, Column, and Merge Status Tables
                                                                                                                                  • information_schema.COLUMNAR_SEGMENTS
                                                                                                                                  • information_schema.IND_CS_PARTITION_ROW_SEGMENT_GROUPS
                                                                                                                                  • information_schema.KEY_COLUMN_USAGE
                                                                                                                                  • information_schema.MV_COLUMNAR_SEGMENT_INDEX
                                                                                                                                  • information_schema.MV_COLUMNSTORE_FILES
                                                                                                                                  • information_schema.MV_COLUMNSTORE_MERGE_STATUS
                                                                                                                                  • information_schema.MV_REBALANCE_STATUS
                                                                                                                                  • MV_ROW_CHANGE_COUNTS
                                                                                                                                • Unlimited Storage Tables
                                                                                                                              • Data API
                                                                                                                                • Data API Authentication
                                                                                                                                • Access the Data API
                                                                                                                                • Enable the Data API
                                                                                                                                  • Data API Data Type Conversion
                                                                                                                                    • Data API Error Handling
                                                                                                                                    • Data API Endpoint Reference
                                                                                                                                      • exec
                                                                                                                                      • ping
                                                                                                                                      • query/rows
                                                                                                                                      • query/tuples
                                                                                                                                      • spec
                                                                                                                                • Security
                                                                                                                                  • Overview
                                                                                                                                    • Configuring SingleStoreDB user accounts
                                                                                                                                      • Securing the initial SingleStoreDB user accounts
                                                                                                                                      • Adding a User
                                                                                                                                      • Changing a Password for a User
                                                                                                                                      • Removing a User
                                                                                                                                      • Inspecting Permissions
                                                                                                                                      • Setting a Failed Login Attempt Lockout Policy
                                                                                                                                    • Configuring Host-Based Security
                                                                                                                                    • Configuring SSL
                                                                                                                                    • Setting SECURE_FILE_PRIV
                                                                                                                                  • Authentication
                                                                                                                                    • Introduction
                                                                                                                                    • Configuring a Password Policy
                                                                                                                                      • Password Expiration
                                                                                                                                      • Password Reuse
                                                                                                                                      • Password Complexity
                                                                                                                                    • Configuring and Using Connection Links
                                                                                                                                      • User Advantages
                                                                                                                                      • Using a Connection Link
                                                                                                                                      • Example
                                                                                                                                    • Kerberos Authentication
                                                                                                                                      • Assumptions and Prerequisites
                                                                                                                                      • Configuring the KDC
                                                                                                                                      • Configuring SingleStoreDB for Kerberos Authentication
                                                                                                                                      • Troubleshooting
                                                                                                                                    • PAM Authentication
                                                                                                                                      • Background
                                                                                                                                      • PAM and SingleStoreDB (connection with MySQL Client)
                                                                                                                                      • GRANT Syntax using PAM
                                                                                                                                    • SAML Authentication
                                                                                                                                      • Configuring SAML Global Variables
                                                                                                                                      • Creating a New User
                                                                                                                                      • Troubleshooting SAML Authentication
                                                                                                                                  • Administration
                                                                                                                                    • Introduction
                                                                                                                                    • Role-Based Access Control (RBAC) Guide
                                                                                                                                      • Role-based Operations
                                                                                                                                      • Role Creation
                                                                                                                                      • Account Creation
                                                                                                                                      • Enable Strict Mode
                                                                                                                                      • Appendix: Role-Based Access Control Command Reference
                                                                                                                                    • Row-Level Security (RLS) Deployment Guide
                                                                                                                                      • Synchronizing Permissions Across Your Cluster
                                                                                                                                        • sync_permissions variable
                                                                                                                                        • Enabling sync permissions
                                                                                                                                        • Understanding sync users
                                                                                                                                        • Root user behavior
                                                                                                                                    • Audit Logging
                                                                                                                                      • Introduction
                                                                                                                                      • Audit Logging
                                                                                                                                        • Prerequisites
                                                                                                                                        • Next Steps
                                                                                                                                      • Configuring Audit Logging
                                                                                                                                        • Audit Logging Configuration Variables
                                                                                                                                        • How to Enable and Configure Audit Logging
                                                                                                                                      • Audit Logging Levels
                                                                                                                                        • OFF
                                                                                                                                        • LOGINS-ONLY
                                                                                                                                        • ADMIN-ONLY and ADMIN-ONLY-INCLUDING-PARSE-FAILS
                                                                                                                                        • WRITES-ONLY and WRITES-ONLY-INCLUDING-PARSE-FAILS
                                                                                                                                        • ALL-QUERIES and ALL-QUERIES-INCLUDING-PARSE-FAILS
                                                                                                                                        • ALL-QUERIES-PLAINTEXT and ALL-QUERIES-PLAINTEXT-INCLUDING-PARSE-FAILS
                                                                                                                                        • ALL-RESULTS and ALL-RESULTS-INCLUDING-PARSE-FAILS
                                                                                                                                      • Audit Log File Format
                                                                                                                                        • Log Entry File Schemas
                                                                                                                                        • General Log Entry Schema
                                                                                                                                        • Log Entry Schema for LOGINS-ONLY Level
                                                                                                                                        • Disabling Audit Logging
                                                                                                                                      • Troubleshooting Audit Logging
                                                                                                                                        • Configuration Issues
                                                                                                                                        • Failed to Write Audit Log Record
                                                                                                                                    • Encryption
                                                                                                                                      • SSL Secure Connections
                                                                                                                                        • Generating SSL Certificates
                                                                                                                                        • Configuring SingleStoreDB for Secure Connections
                                                                                                                                        • Specifying the TLS Version
                                                                                                                                        • Server Configuration for Secure Client Connections
                                                                                                                                        • Server Configuration for Secure Client and Intra-Cluster Connections
                                                                                                                                        • Server Configuration to Require Secure Client Connections
                                                                                                                                        • Configuring SingleStore Tools for Secure Connections
                                                                                                                                        • Client Configuration for Secure Client Connections
                                                                                                                                      • Encryption at Rest
                                                                                                                                        • Example Setup Process
                                                                                                                                        • How to Use LUKS With Different Versions of Linux
                                                                                                                                      • Securing Data at Rest with IBM Guardium Data Encryption
                                                                                                                                        • Getting Started
                                                                                                                                        • Process Overview
                                                                                                                                      • Securing Data at Rest with CipherTrust Transparent Encryption
                                                                                                                                        • Getting Started
                                                                                                                                        • Setting up CTE Components and a SingleStoreDB Cluster
                                                                                                                                        • Protect Directories in SingleStore Using CTE
                                                                                                                                  • Release Notes
                                                                                                                                    • SingleStoreDB/MemSQL
                                                                                                                                      • 7.5 Release Notes
                                                                                                                                        • Maintenance Release Changelog
                                                                                                                                      • 7.3 Release Notes
                                                                                                                                        • 7.3 Release Highlights
                                                                                                                                        • Maintenance Release Changelog
                                                                                                                                      • 7.1 Release Notes
                                                                                                                                        • Release Highlights
                                                                                                                                        • Additional Features and Improvements in this Release
                                                                                                                                        • Maintenance Release Changelog
                                                                                                                                      • 7.0 Release Notes
                                                                                                                                        • Release Highlights
                                                                                                                                        • Query Execution
                                                                                                                                        • Query Optimization
                                                                                                                                        • Data Storage, Loading, and Backup
                                                                                                                                        • System Management
                                                                                                                                        • Functional Extensions
                                                                                                                                        • Maintenance Release Changelog
                                                                                                                                    • SingleStoreDB Studio Release Notes
                                                                                                                                      • SingleStoreDB Toolbox Release Notes
                                                                                                                                        • MemSQL Kubernetes Operator Release Notes
                                                                                                                                          • Documentation Changelog
                                                                                                                                            • 2022-04-01
                                                                                                                                            • 2021-10-01
                                                                                                                                            • 2021-07-01
                                                                                                                                            • 2021-03-01
                                                                                                                                            • 2021-02-01
                                                                                                                                            • 2021-01-19
                                                                                                                                        • Support
                                                                                                                                          • FAQs
                                                                                                                                            • Supported Versions Matrix
                                                                                                                                              • What is the End of Life (EOL) Policy for SingleStore Software?
                                                                                                                                            • How Support Works
                                                                                                                                              • Who is eligible to receive Support?
                                                                                                                                              • What are the different Support Tiers available?
                                                                                                                                              • Can I upgrade my Support Tier?
                                                                                                                                              • Where can I go for help if I do not have access to paid support?
                                                                                                                                              • When should I use SingleStore Support?
                                                                                                                                              • How do I sign up for an account on SingleStore’s Support Portal?
                                                                                                                                              • How do I file a support ticket?
                                                                                                                                              • What does each ticket severity level mean?
                                                                                                                                              • What should I include in my Support ticket?
                                                                                                                                              • How do I share files with SingleStore Support?
                                                                                                                                              • When can I expect a response to my Support ticket?
                                                                                                                                              • Why am I not getting emails from SingleStore Support?
                                                                                                                                          • Obtain Help and Support
                                                                                                                                            • Enterprise Customers, SingleStoreDB Cloud, SingleStoreDB On-Premises
                                                                                                                                        print
                                                                                                                                        • SingleStoreDB
                                                                                                                                        • Introduction
                                                                                                                                        • FAQs
                                                                                                                                        • Deployment and Management
                                                                                                                                        • What hardware is recommended for SingleStoreDB?
                                                                                                                                        • Prev
                                                                                                                                        • Next

                                                                                                                                        SingleStoreDB v7.5

                                                                                                                                        What hardware is recommended for SingleStoreDB?

                                                                                                                                        See System Requirements and Recommendations.

                                                                                                                                        In this section:

                                                                                                                                        Search results

                                                                                                                                          No results found

                                                                                                                                          Was this helpful?

                                                                                                                                          Would you like to provide feedback? Just click here to suggest edits.

                                                                                                                                          • Prev
                                                                                                                                          • Next
                                                                                                                                          © 2022 SingleStore
                                                                                                                                          Last modified: June 22, 2022
                                                                                                                                          Publication date: