Questions tagged [singlestore]
For database related questions relating to the use of Singlestore (formerly known as MemSQL), which is a distributed SQL database. Add an additional version-specific tag like [singlestore-7.8] if that context is relevant.
9
questions
0
votes
1
answer
13
views
How to change transaction logs size in singlestore
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 ? ...
- 143
0
votes
1
answer
17
views
'Query Performance plan' query in singlestore
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?
- 143
1
vote
1
answer
26
views
SingleStore: Sign Up Log In Cannot get source metadata for pipeline. Failed to create consumer: ssl.ca.location failed: No further error info
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. ...
- 49
1
vote
1
answer
20
views
SingleStore Execute Immediate a SP/Func inside SP from a query table
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 ...
- 49
1
vote
1
answer
59
views
SingleStore exception no_data_found
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?
- 49
1
vote
1
answer
43
views
SSL Encryption for Kafka Pipelines
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 '<kafka-host>:<...
- 49
1
vote
2
answers
150
views
Primary Key issue in MemSQL doesn't support case sensitive
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 ...
- 21
2
votes
1
answer
193
views
WEHRE IN array values using stored procedure
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 ...
- 123
0
votes
1
answer
1k
views
MySQL syntax error 1064 near IN stored procedure
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 ...
- 123