# Off-Topic

**URL:** https://www.singlestore.com/forum/c/random/42.md

[Latest](https://www.singlestore.com/forum/latest.md) · [Categories](https://www.singlestore.com/forum/categories.md) · [Tags](https://www.singlestore.com/forum/tags.md)

---

## [About the Off-Topic category](https://www.singlestore.com/forum/t/about-the-off-topic-category/3821)

<div class="topic-metadata">

**Author:** [@wfaulkner](https://www.singlestore.com/forum/u/wfaulkner)\
**Replies:** 1\
**Last updated:** [March 8, 2022, 6:56am UTC](https://www.singlestore.com/forum/t/about-the-off-topic-category/3821 "2022-03-08T06:56:07Z")

</div>

Have something to share but don’t know where to put it? This category is for all topics that don’t need a category and/or don’t fit into the other existing categories. Share a meme, a joke, an upcoming event or something…

---

## [Are there any SingleStore User Groups or Meetups?](https://www.singlestore.com/forum/t/are-there-any-singlestore-user-groups-or-meetups/8718)

<div class="topic-metadata">

**Author:** [@alau](https://www.singlestore.com/forum/u/alau)\
**Replies:** 1\
**Last updated:** [October 6, 2026, 4:47pm UTC](https://www.singlestore.com/forum/t/are-there-any-singlestore-user-groups-or-meetups/8718 "2026-10-06T16:47:05Z")

</div>

Are there any SingleStore User Groups or Meetups?

---

## [What CPU is the best to use? Is IBM a possibility?](https://www.singlestore.com/forum/t/what-cpu-is-the-best-to-use-is-ibm-a-possibility/2847)

<div class="topic-metadata">

**Author:** [@trent27on](https://www.singlestore.com/forum/u/trent27on)\
**Replies:** 5\
**Last updated:** [June 14, 2025, 12:52am UTC](https://www.singlestore.com/forum/t/what-cpu-is-the-best-to-use-is-ibm-a-possibility/2847 "2025-06-14T00:52:44Z")

</div>

When installing SingleStore, is there a specific CPU that is the best to use for max performance? Intel Extreme Edition? Xeon 2288G’s? Ryzen? Threadripper? It’s not too clear what CPU seems to do best with SingleStore, …

---

## [Bi-Directional Integration for Apache Iceberg](https://www.singlestore.com/forum/t/bi-directional-integration-for-apache-iceberg/8123)

<div class="topic-metadata">

**Author:** [@buituanh2002](https://www.singlestore.com/forum/u/buituanh2002)\
**Replies:** 3\
**Last updated:** [February 20, 2025, 3:07am UTC](https://www.singlestore.com/forum/t/bi-directional-integration-for-apache-iceberg/8123 "2025-02-20T03:07:40Z")

</div>

Announcing: Bi-Directional Integration for Apache Iceberg I found this quite interesting—being able to write to Iceberg tables. But when will the things mentioned in that blog become reality? Can’t wait for that

---

## [Memory consumption - something is using all the available memory](https://www.singlestore.com/forum/t/memory-consumption-something-is-using-all-the-available-memory/3413)

<div class="topic-metadata">

**Author:** [@moralez.rodrigo](https://www.singlestore.com/forum/u/moralez.rodrigo)\
**Replies:** 12\
**Last updated:** [August 28, 2024, 12:09pm UTC](https://www.singlestore.com/forum/t/memory-consumption-something-is-using-all-the-available-memory/3413 "2024-08-28T12:09:03Z")

</div>

I have a problem but with 7.3.12. I moved all the rowstore tables into a columnstore (was not the idea but I dont know what else to try) And still everything is randomly failing due to memory usage, event a simple creat…

---

## [Tool recommendations for connecting to SingleStore](https://www.singlestore.com/forum/t/tool-recommendations-for-connecting-to-singlestore/124)

<div class="topic-metadata">

**Author:** [@memsqlpubs](https://www.singlestore.com/forum/u/memsqlpubs)\
**Replies:** 13\
**Last updated:** [March 19, 2024, 10:58am UTC](https://www.singlestore.com/forum/t/tool-recommendations-for-connecting-to-singlestore/124 "2024-03-19T10:58:43Z")

</div>

(Ported from memsql-public-chat Slack channel) Amir \[12:26 PM\] Hi guys, What is the best tool you recommend for connecting to MemSQL 6.0. I tried MySQL Workbench 8.0 and I receive a handshake error. MySQL Workbench 6.…

---

## [I create procedure but i have problem on executing](https://www.singlestore.com/forum/t/i-create-procedure-but-i-have-problem-on-executing/1840)

<div class="topic-metadata">

**Author:** [@brahimbatoir](https://www.singlestore.com/forum/u/brahimbatoir)\
**Replies:** 3\
**Last updated:** [March 15, 2024, 4:36pm UTC](https://www.singlestore.com/forum/t/i-create-procedure-but-i-have-problem-on-executing/1840 "2024-03-15T16:36:42Z")

</div>

here is the procedure : DELIMITER $$ CREATE PROCEDURE addcategorie ( nom varchar(50), parent integer ) BEGIN DECLARE cat integer; SELECT MAX(oc\_category.category\_id) + 1 INTO cat FROM oc\_category; INSERT INTO oc…

---

## [Kafka Pipelines - configure kafka consumer](https://www.singlestore.com/forum/t/kafka-pipelines-configure-kafka-consumer/1142)

<div class="topic-metadata">

**Author:** [@dtroyan](https://www.singlestore.com/forum/u/dtroyan)\
**Replies:** 9\
**Last updated:** [March 15, 2024, 4:36pm UTC](https://www.singlestore.com/forum/t/kafka-pipelines-configure-kafka-consumer/1142 "2024-03-15T16:36:05Z")

</div>

Hi everyone! I am very eager to try out the Pipelines functionality in MemSQL to load some JSON-formatted data from Kafka. However, it is quite important to me to be able to configure Kafka consumer roperties. E.g. def…

---

## [SELECT INTO S3 - file format](https://www.singlestore.com/forum/t/select-into-s3-file-format/2001)

<div class="topic-metadata">

**Author:** [@ido](https://www.singlestore.com/forum/u/ido)\
**Replies:** 6\
**Last updated:** [November 30, 2023, 5:01pm UTC](https://www.singlestore.com/forum/t/select-into-s3-file-format/2001 "2023-11-30T17:01:35Z")

</div>

Hello, I managed to successfully load data from mem to S3 bucket. But the format is something I cannot use. Can i make it JSON or CSV? SELECT \* FROM table WHERE time \> '2020-05-20 00:00:00' INTO S3 'bucket/file' CON…

---

## [How do you change a column from NULL to NOT NULL in memSQL](https://www.singlestore.com/forum/t/how-do-you-change-a-column-from-null-to-not-null-in-memsql/1728)

<div class="topic-metadata">

**Author:** [@rjsv](https://www.singlestore.com/forum/u/rjsv)\
**Replies:** 10\
**Last updated:** [November 28, 2023, 8:14pm UTC](https://www.singlestore.com/forum/t/how-do-you-change-a-column-from-null-to-not-null-in-memsql/1728 "2023-11-28T20:14:10Z")

</div>

How do you change a column from NULL to NOT NULL in memSQL. I have created the table as below. create table t\_tinyint1(c TINYINT,c2 VARCHAR(100), key() USING CLUSTERED COLUMNSTORE); Trying to alter but no luck ALTER …

---

## [Tmpdir measurement and location](https://www.singlestore.com/forum/t/tmpdir-measurement-and-location/7211)

<div class="topic-metadata">

**Author:** [@nlello](https://www.singlestore.com/forum/u/nlello)\
**Replies:** 2\
**Last updated:** [October 13, 2023, 2:33pm UTC](https://www.singlestore.com/forum/t/tmpdir-measurement-and-location/7211 "2023-10-13T14:33:45Z")

</div>

Has anyone experimented with changing the tmpdir engine variable from it’s default of /tmp to a tmpfs filesystem to speed things up ? I’m curious to figure out if this would help Singlestore on queries with large datase…

---

## [Could not update the safe ts for database XX: Not found](https://www.singlestore.com/forum/t/could-not-update-the-safe-ts-for-database-xx-not-found/7212)

<div class="topic-metadata">

**Author:** [@sebaZ](https://www.singlestore.com/forum/u/sebaZ)\
**Replies:** 2\
**Last updated:** [October 12, 2023, 7:54pm UTC](https://www.singlestore.com/forum/t/could-not-update-the-safe-ts-for-database-xx-not-found/7212 "2023-10-12T19:54:58Z")

</div>

Hi guys! After update from 7.3.3 to 8.2.1 I started getting this error, someone can help?

---

## [SingleStoreDB - Cluster related](https://www.singlestore.com/forum/t/singlestoredb-cluster-related/6720)

<div class="topic-metadata">

**Author:** [@anish](https://www.singlestore.com/forum/u/anish)\
**Replies:** 1\
**Last updated:** [September 19, 2023, 5:55pm UTC](https://www.singlestore.com/forum/t/singlestoredb-cluster-related/6720 "2023-09-19T17:55:20Z")

</div>

727536828118 2023-04-25 23:26:46.325 ERROR: Thread 114969 (ntid 5164, conn id -1): MoveOneStep: XXX\_3 log: Slave data read failed with error 104 (Connection reset by peer) while in state x\_streaming. and Application is…

---

## [The operating system failed to allocate memory (MemSQL memory use 25576.12 Mb). The request was not processed](https://www.singlestore.com/forum/t/the-operating-system-failed-to-allocate-memory-memsql-memory-use-25576-12-mb-the-request-was-not-processed/1576)

<div class="topic-metadata">

**Author:** [@rjsv](https://www.singlestore.com/forum/u/rjsv)\
**Replies:** 5\
**Last updated:** [August 19, 2023, 1:36pm UTC](https://www.singlestore.com/forum/t/the-operating-system-failed-to-allocate-memory-memsql-memory-use-25576-12-mb-the-request-was-not-processed/1576 "2023-08-19T13:36:22Z")

</div>

We are receiving below error. Why it is coming. Error occurred during SQL script execution Reason: SQL Error \[1712\] \[HY000\]: Leaf Error (10.100.0.18:3306): The operating system failed to allocate memory (MemSQL memory…

---

## [Replication Monitoring](https://www.singlestore.com/forum/t/replication-monitoring/6985)

<div class="topic-metadata">

**Author:** [@tchaitanya](https://www.singlestore.com/forum/u/tchaitanya)\
**Replies:** 2\
**Last updated:** [July 21, 2023, 2:58am UTC](https://www.singlestore.com/forum/t/replication-monitoring/6985 "2023-07-21T02:58:00Z")

</div>

Hi Team, How do we monitor the replication status between two cross data center clusters.? Do we have any table/veiw which actually stores the current replication status of the database I know we have tables where we h…

---

## [Implementing clone and share feature in memsql](https://www.singlestore.com/forum/t/implementing-clone-and-share-feature-in-memsql/6952)

<div class="topic-metadata">

**Author:** [@sid2sarkar](https://www.singlestore.com/forum/u/sid2sarkar)\
**Replies:** 2\
**Last updated:** [July 6, 2023, 4:24pm UTC](https://www.singlestore.com/forum/t/implementing-clone-and-share-feature-in-memsql/6952 "2023-07-06T16:24:17Z")

</div>

While looking into snowflake data warehouse tool, I came across data cloning and data sharing. This is a great feature for any RDBMS. Can these be implemented in singlestore also? Thanks.

---

## [Instructional Webinar for SS Devs](https://www.singlestore.com/forum/t/instructional-webinar-for-ss-devs/6956)

<div class="topic-metadata">

**Author:** [@ksmith](https://www.singlestore.com/forum/u/ksmith)\
**Replies:** 0\
**Last updated:** [July 6, 2023, 3:45pm UTC](https://www.singlestore.com/forum/t/instructional-webinar-for-ss-devs/6956 "2023-07-06T15:45:08Z")

</div>

Instructional webinar for SingleStore Developers- integrating a SSDB with an Agile Digital Twin: free sign up at: https://hopara.io/singlestore-and-hopara/

---

## [Mark training course complete](https://www.singlestore.com/forum/t/mark-training-course-complete/3601)

<div class="topic-metadata">

**Author:** [@DPuscasu](https://www.singlestore.com/forum/u/DPuscasu)\
**Replies:** 2\
**Last updated:** [July 1, 2023, 3:50pm UTC](https://www.singlestore.com/forum/t/mark-training-course-complete/3601 "2023-07-01T15:50:00Z")

</div>

Hi, I cannot mark course complete Procedural SQL ID: E-1GLN9V all three Labs. I did all of labs on my dev environment, passed through all steps in the cource and every step dad been marcked but averall result is not …

---

## [Learn MemSQL at training.memsql.com](https://www.singlestore.com/forum/t/learn-memsql-at-training-memsql-com/128)

<div class="topic-metadata">

**Author:** [@Seth](https://www.singlestore.com/forum/u/Seth)\
**Replies:** 1\
**Last updated:** [July 1, 2023, 3:34pm UTC](https://www.singlestore.com/forum/t/learn-memsql-at-training-memsql-com/128 "2023-07-01T15:34:48Z")

</div>

Visit training.memsql.com for onsite, virtual, and self-paced training.

---

## [Agile Digital Twins and ChatGPT](https://www.singlestore.com/forum/t/agile-digital-twins-and-chatgpt/6854)

<div class="topic-metadata">

**Author:** [@ksmith](https://www.singlestore.com/forum/u/ksmith)\
**Replies:** 0\
**Last updated:** [June 6, 2023, 6:21pm UTC](https://www.singlestore.com/forum/t/agile-digital-twins-and-chatgpt/6854 "2023-06-06T18:21:53Z")

</div>

If anyone is interested, we have a direct connection with SingleStore and are on SingleStore Connect. We’re hosting a live webinar: How to create an Agile Digital Twin in under 30m using ChatGPT and Hopara. If you’re i…

---

## [V8.1.1 JSON 100x faster](https://www.singlestore.com/forum/t/v8-1-1-json-100x-faster/6777)

<div class="topic-metadata">

**Author:** [@gtbenedict](https://www.singlestore.com/forum/u/gtbenedict)\
**Replies:** 2\
**Last updated:** [May 12, 2023, 9:34pm UTC](https://www.singlestore.com/forum/t/v8-1-1-json-100x-faster/6777 "2023-05-12T21:34:11Z")

</div>

I’m doing some work with nested json pipelines into a procedure. I see that the new release is capable of faster json analytics. My question is: does this apply to data ingestion? I bring the data into table/column fo…

---

## [Setup and Change high availability flag](https://www.singlestore.com/forum/t/setup-and-change-high-availability-flag/6620)

<div class="topic-metadata">

**Author:** [@naresh.ragi](https://www.singlestore.com/forum/u/naresh.ragi)\
**Replies:** 1\
**Last updated:** [March 20, 2023, 7:39pm UTC](https://www.singlestore.com/forum/t/setup-and-change-high-availability-flag/6620 "2023-03-20T19:39:35Z")

</div>

Hello, i was trying same as per Change high availability flag this ticket But for its not working can u please let me know what is the issue here? \[root@vm\_1 memsql\]# memsql-deploy setup-cluster --high-availability=fal…

---

## [Fire and forget data api](https://www.singlestore.com/forum/t/fire-and-forget-data-api/6550)

<div class="topic-metadata">

**Author:** [@madhuri.kotha](https://www.singlestore.com/forum/u/madhuri.kotha)\
**Replies:** 1\
**Last updated:** [February 23, 2023, 7:27pm UTC](https://www.singlestore.com/forum/t/fire-and-forget-data-api/6550 "2023-02-23T19:27:14Z")

</div>

Hi, We are trying to call a stored procedure using data APIs from a java application. The stored procedure will take some time to execute and we don’t want to wait until the stored procedure execution is done. Is there …

---

## [Change high availability flag](https://www.singlestore.com/forum/t/change-high-availability-flag/1134)

<div class="topic-metadata">

**Author:** [@arshakfm](https://www.singlestore.com/forum/u/arshakfm)\
**Replies:** 3\
**Last updated:** [February 23, 2023, 3:18pm UTC](https://www.singlestore.com/forum/t/change-high-availability-flag/1134 "2023-02-23T15:18:23Z")

</div>

Hello, I have created my MemSQL cluster with the help of following command (–high-availability=false) \`memsql-deploy setup-cluster --high-availability=false --license \<license\_key\> --master-host prod-node1.com --aggr…

---

## [Impact of High Availability on Partition count](https://www.singlestore.com/forum/t/impact-of-high-availability-on-partition-count/6472)

<div class="topic-metadata">

**Author:** [@varun.kushwah](https://www.singlestore.com/forum/u/varun.kushwah)\
**Replies:** 2\
**Last updated:** [February 6, 2023, 3:10am UTC](https://www.singlestore.com/forum/t/impact-of-high-availability-on-partition-count/6472 "2023-02-06T03:10:53Z")

</div>

I’m Having Total VM:5 , Master VM:1, Leaf VM:4 CPU Coes per VM: 16 My question is what should be the optimal number of partitions? And the Impact of High availability on partition count per VM.

---

## [Monitoring, Logging and Debugging of Pipelines](https://www.singlestore.com/forum/t/monitoring-logging-and-debugging-of-pipelines/1784)

<div class="topic-metadata">

**Author:** [@henryshi2007](https://www.singlestore.com/forum/u/henryshi2007)\
**Replies:** 3\
**Last updated:** [January 20, 2023, 9:49am UTC](https://www.singlestore.com/forum/t/monitoring-logging-and-debugging-of-pipelines/1784 "2023-01-20T09:49:16Z")

</div>

Hi, I have a general question on how to monitor and debug memsql’s kafka pipelines. I understand I can create a pipeline and transform kafka messages using stored procedure or python scripts. And I can monitor the pipe…

---

## [Can we restore the completed and incomplete transactions from transation\_log when the system crashes in between write/update/delete operations?](https://www.singlestore.com/forum/t/can-we-restore-the-completed-and-incomplete-transactions-from-transation-log-when-the-system-crashes-in-between-write-update-delete-operations/6405)

<div class="topic-metadata">

**Author:** [@navin.tb](https://www.singlestore.com/forum/u/navin.tb)\
**Replies:** 1\
**Last updated:** [January 13, 2023, 6:00pm UTC](https://www.singlestore.com/forum/t/can-we-restore-the-completed-and-incomplete-transactions-from-transation-log-when-the-system-crashes-in-between-write-update-delete-operations/6405 "2023-01-13T18:00:18Z")

</div>

How to restore completed and incomplete transactions from transaction log when the system crashes. What is the strategy for backup in transaction failure or system failure back up?

---

## [SingleStoreDB 8.0 Release](https://www.singlestore.com/forum/t/singlestoredb-8-0-release/6264)

<div class="topic-metadata">

**Author:** [@anish](https://www.singlestore.com/forum/u/anish)\
**Replies:** 3\
**Last updated:** [December 11, 2022, 6:43am UTC](https://www.singlestore.com/forum/t/singlestoredb-8-0-release/6264 "2022-12-11T06:43:40Z")

</div>

Continuing the discussion from SingleStore High Availability and Storage Distribution on Node Fail over: thanks mmanthena for your detailed explanation . So my another observation is , one availability group is complet…

---

## [SingleStore High Availability and Storage Distribution on Node Fail over](https://www.singlestore.com/forum/t/singlestore-high-availability-and-storage-distribution-on-node-fail-over/6213)

<div class="topic-metadata">

**Author:** [@anish](https://www.singlestore.com/forum/u/anish)\
**Replies:** 2\
**Last updated:** [December 6, 2022, 7:57pm UTC](https://www.singlestore.com/forum/t/singlestore-high-availability-and-storage-distribution-on-node-fail-over/6213 "2022-12-06T19:57:21Z")

</div>

Need to understand more about the Leaf node fail over scenario and how the storage distribution is happening . For example , Total 8TB online storage created 4 leaf node with 2TB each . If one leaf node failure then how …

---

## [Question about licence keys for dev setup](https://www.singlestore.com/forum/t/question-about-licence-keys-for-dev-setup/1591)

<div class="topic-metadata">

**Author:** [@endijs](https://www.singlestore.com/forum/u/endijs)\
**Replies:** 2\
**Last updated:** [January 29, 2020, 7:10pm UTC](https://www.singlestore.com/forum/t/question-about-licence-keys-for-dev-setup/1591 "2020-01-29T19:10:52Z")

</div>

Hi! I’m trying to understand how full development setup should be done in regards of licence keys. In normal software development there should be at lest 3 instances: local instance on developers system (notebook, PC); d…

[Next page](https://www.singlestore.com/forum/c/random/42.md?page=1)
