We have a table that memsql studio says is in 5gb in size, though on disk we see approx 27gb in the data folder. After further analyzing it seems the data/logs is holding approx 16gb. Is this needed ? is there a way to clean it ?

when I go to memsqlOps > Explore > Query. I’m able to see query performance and active long running queries. What table or tables can I select from to get that same information?

I have a select query that uses a WHERE IN clause in a MemSQL database. The list of values searched in are a result of another select query. Before, I inserted the values for that clause as a string through a web service like so: (1,2,3..). Now I want to move the second query into a stored procedure, and have the values mentioned above be a part of the parameters for that procedure. Say I have a table: create table t (num int); Then when I try to create the sp: DELIMITER // CREATE PROCEDURE test (nums ARRAY(INT)) AS BEGIN ECHO SELECT * FROM t WHERE num IN nums; END // DELIMITER ; I get: ERROR 1064 (42000): Compilation error in function test near line 3: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'nums' So apparently it doesn't work that way. Is there way I can get this to recognize the data type I'm inserting? I want to avoid manipulating strings, but if there is no choice, would it require running the query as a string in the stored procedure?

Any [SingleStore] users out there? For enabling SSL encryption (only) for Kafka pipelines, we created the pipeline like below: CREATE PIPELINE kafka_ssl AS LOAD DATA KAFKA ':/test' CONFIG '{"security.protocol": "ssl" "ssl.ca.location": ""}'' INTO table ; from https://docs.memsql.com/v7.0/concepts/pipelines/kafka-kerberos-ssl/ 22 Please note that we’re not looking for Client authentication (mutual TLS connection). This requires us to manually copy the CA Cert into memsql nodes and provide that path. This works fine for standalone Kafka cluster. What is the recommended approach if we’re using AWS MSK? Following documentation points to the client configuration for SSL encryption for MSK clients. They use client truststore location as a property which is not an identified property for memsql pipeline config json https://docs.aws.amazon.com/msk/latest/developerguide/msk-encryption.html 10 https://docs.aws.amazon.com/msk/latest/developerguide/msk-authentication.html See others having the same issue in the SingleStore forums. Unable to create a pipeline from Singlestore in a box to AWS MSK.

I’m having trouble to execute immediate a SP inside a SP from a table. because i have a lot of SP stored in a table (as a data/string). in oracle we can use “select sp_1(:1,:2) from dual” and running it via execute immediate. how’s singlestore do that? i get error. please help, because we want to migrate from oracle to singlestore. i changed a lot of SP from oracle to singlestore. thanks.

Creating table in MemSQL and creating composite primary key. Lets create simple table with following structure: Table User Data Name userid Primary Key (userid) And assume application support case sensitive userid. So that following user id considered to be different: abc ABC Insert following data: 1) JOHN ABC b) ALEX abc Insert fails in MemSQL as it consider 'ABC' same as 'abc'. Please help me to understand if case sensitive primary key possible in MemSQL table or not.

below is the command that i am using, but when i create the kafka pipeline command i get the below error: ERROR 1933 ER_EXTRACTOR_EXTRACTOR_GET_LATEST_OFFSETS: Cannot get source metadata for pipeline. Failed to create consumer: ssl.ca.location failed: No further error information available Command used: CREATE PIPELINE ticketmaster_pipeline AS LOAD DATA KAFKA ‘b-3.etainmentnonprod.z2xjta.c25.kafka.us-east-1.amazonaws.com:9094,b-1.etainmentnonprod.z2xjta.c25.kafka.us-east-1.amazonaws.com:9094,b-2.etainmentnonprod.z2xjta.c25.kafka.us-east-1.amazonaws.com:9094/ticketmaster’ CONFIG '{“sasl.username”: “AWS_ACCESS_KEY”, "sasl.mechanism": "PLAIN", "security.protocol": "SASL_SSL", "ssl.ca.location": "/etc/pki/ca-trust/extracted/java/cacerts"}' CREDENTIALS ‘{“sasl.password”: “AWS_PSWD/Z”}’ INTO TABLE ticketmaster_kafka FORMAT JSON (event_url ← event_url,event_id ← event_id,timestamp ← timestamp,event_name ← event_name,venue ← venue,event_datetime ← event_datetime,city ← city,state ← state,section ← section,row ← row,qty ← qty,seat_ids ← seat_ids,seat_numbers ← seat_numbers,inventory_type ← inventory_type,price ← price); My kafka setup in on AWS MSK insatnce and i have data in the topic also

I’m having difficulty finding the exception no_data_found in **singlestore**. In **Oracle**, we use no_data_found exception. Is there any alternative solution in **singlestore** for the no_data_found exception?

an aspiring DBA Here. I'm trying to create a stored procedure for a query I'm running. It is a memsql server which is MySQL based. The procedure is as such: delimiter // CREATE PROCEDURE calc_campaign (IN usr VARCHAR(38)) BEGIN Awesome SELECT statement that uses a variable END // The error description is: ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN usr VARCHAR(38)) BEGIN my_statement; END' at line 1 The syntax I used seems to correspond with this: https://dev.mysql.com/doc/refman/8.0/en/create-procedure.html And with pretty much every other procedure I saw on Stack forums. What is it I'm missing here? Thanks for any help!