What can we help you with?
Documentation
From basic FAQs to in-depth techdocs.
Read Docs
Forums
Get help from the SingleStore community.
Visit Forums
Support
Enterprise licensed customers can get help from our Support team.
Contact Support
ANNOUNCEMENTS
- SingleStore 7.8 Release Announcement
- Apache Log4j2 (CVE-2021-44228) Security Alert
- SingleStore 7.6 Release Announcement
- SingleStore 7.5 release announcement
- End-of-Life for SingleStore 6.8
- MemSQL is now SingleStore
FAQ
- Disable SSL in a SingleStore cluster
- DATABASE REPLICATION - ERROR 1037 (HY001): Out of memory; please try the operation again
- Recommended Linux Distributions
- Locking database user account in SingleStore
- Old log files in the /data dir
- Creating stored procedure with the desired definer
CLUSTER
- YAML file for cluster migration
- A "distributed" user
- Default password for root user when SingleStore cluster is installed
- Configuring toolbox on a Child Aggregator
- Checking if node auto-restart is enabled/disabled on reboot or not
- Disabling SingleStore node auto restart after host reboot
REPLICATION
- Leaf Error (127.0.0.1:3307): Unknown database 'testdb_2'
- Lag in database replication
- Paired leaf replication in High Availability vs. Load Balanced leaf replication
- Replication between clusters is not healthy
- Snapshots and Transaction logs used in replication
- What Is Reprovisioning?
ENGINE
- Disk space got exhausted - the "logs" directory is taking too much space
- Thread launch delays
- Resource Pool: HARD CPU Limit, SOFT CPU Limit and default_pool
- Why there are old transaction log files in my data dir
- Maximum_memory error on Query execution (ERROR 1712 ER_MEMSQL_OOM)
- Queries logging
SQL
- ON DUPLICATE KEY UPDATE
- Data sorting using GROUP_CONCAT in subquery
- Comparing two databases
- Understanding the number of rows affected with UPSERT operation
- Limit set by a client
- EXPLAIN plan output
STORAGE
- Estimating size for MySQL tables when migrating to SingleStore
- When to use reference tables
- Storage in SingleStore
- Understanding Disk Usage
- Storage reformatting from v6.x to v7.x
- OPTIMIZE TABLE usage between Rowstore and Columnstore table
BACKUP and RESTORE
- What causes backup to fail with the error "x509: certificate signed by unknown authority"
- What causes the "Attempting to get the size of the backup target failed. Forbidden: Forbidden status code: 403" error during backups/restore
- Create a Backup in Azure Blobs using "sdb-admin create-backup" and "BACKUP DATABASE"
- Selectively deleting entires in mv_backup_history table
- ERROR 1832 (HY000): Restoring partitions on `<DB_NAME>`. Couldn't find backup file for partition 0 of database
- Restore an automatic Backup in Singlestore Managed Services
MISCELLANEOUS
- Disable THP (Transparent Hugepages)
- Effect of host timezone on data
- memsqld and memsqld_safe processes
- Running a procedure as background process
- Cant open file 'blobs' (errno: 24)
- Can I use secure private key certificate with WebSocket?
K8S & OPERATOR
- View Node (and Exporter) Logs in a Kubernetes Environment (SingleStore Operator)
- Configuring SingleStore operator to create internal ELB / NLB rather than internet facing LBs
- Collect a Kubernetes (SingleStore Operator) Cluster Report
- DDL and DML endpoints of the Kubernetes Operator
- Enabling HTTP API in a SingleStore Kubernetes Operator cluster
SingleStoreDB Cloud
- HTTP API on SingleStoreDB Cloud
- User names with type 'JWT' in SingleStoreDB Cloud
- Securing SingleStoreDB Cloud Clusters outbound connections via TLS/SSL?
- Resource Pool on SingleStoreDB Cloud Cluster
- Setting up Azure PrivateLink in SingleStoreDB Cloud
- Setting up Google Private Service Connect in SingleStoreDB Cloud