21 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
1
answer
84
views
How to optimize SELECT * queries on wide tables?
I'm a MySQL DBA moving to PolarDB IMCI. I know we can force columnstore queries like:
SELECT /*+ SET_VAR(cost_threshold_for_imci=0) */ COUNT(*) FROM t1 WHERE a > 1;
or disable them:
SELECT /*+ ...
0
votes
1
answer
30
views
Can complex UPDATE statements leverage columnstore indices?
I'm migrating from standard MySQL to PolarDB MySQL with IMCI. I understand columnstore indexes only work on read-only nodes, while DML operations must run on the primary RW node. For INSERT INTO ...
Best practices
0
votes
0
replies
14
views
How to bulk insert Python list embeddings into PolarDB IMCI VECTOR column?
I am using mysql-connector-python to insert embeddings generated by OpenAI (text-embedding-3-small).
The embeddings are Python lists of 1536 floats.
My table schema:
CREATE TABLE embeddings_store (
...
Best practices
0
votes
0
replies
52
views
Integration of PolarDB IMCI Vector Store with LangChain for RAG pipeline
I'm trying to use PolarDB IMCI as a Vector Store for a Retrieval-Augmented Generation (RAG) application using LangChain (Python).
While there are standard integrations for Milvus and Pinecone, I'm ...
Best practices
1
vote
0
replies
43
views
Dictionary Encoding VS ENUM type
To meet certain data analysis requirements, I am migrating from a self-hosted local MySQL database to PolarDB. During the migration, I discovered that many data analysis tools offer a technique called ...
Advice
0
votes
4
replies
47
views
How to do EXPLAIN ANALYZE a query when query execute on PolarDB IMCI
I want to profiling slow query on PolarDB IMCI, but when I execute EXPLAIN ANALYZE statement, it just return explain result instead of actual profiling result.
Advice
0
votes
0
replies
21
views
How to have mutliple sort key in PolarDB IMCI
I have an ERP system that uses PolarDB IMCI for data analysis. Due to the massive data volume, I aim to accelerate query execution using a filtering approach similar to B+ tree indexes. However, IMCI ...
Best practices
0
votes
0
replies
21
views
How effective are columnstore indexes for fuzzy text searches like LIKE queries in PolarDB MySQL IMCI?
I've implemented PolarDB MySQL IMCI for our product catalog analytics and have been experimenting with columnstore indexes for various query patterns. I've read in the documentation that columnstore ...
Best practices
0
votes
0
replies
37
views
How to properly configure transaction isolation levels when using columnstore indexes in PolarDB MySQL IMCI?
I've been working with PolarDB MySQL IMCI for a few days now and have successfully implemented columnstore indexes on several analytical tables. I've read through the transaction isolation ...
1
vote
1
answer
42
views
How to solve error reported when using EMBEDDING? [closed]
I got Incorrect arguments to vector_distance error when I execute the following SQL:
set @value = EMBEDDING('ecs server', 'text-embedding-v4', 1024);
SELECT doc, DISTANCE(vec, @value, 'COSINE') as ...
1
vote
1
answer
50
views
Why does adding columns take so long after I added columnstore indexes? [closed]
I'm new to PolarDB MySQL and just started using IMCI to make my analytical queries faster. Everything was working great until I tried to add a new column to one of my tables.
Before I added the ...
Advice
0
votes
0
replies
36
views
How to properly configure PolarDB/MySQL as a VectorStore in LangChain?
I am trying to use my existing PolarDB/MySQL database as a vector store for a RAG (Retrieval-Augmented Generation) application built with LangChain (Python).
Please help to advise the detailed ...
Best practices
0
votes
4
replies
51
views
What are the hardware and configuration considerations for scaling MySQL for vector search workloads?
We have a prototype for a vector search application using PolarDB that works well with 100k vectors. We are now planning to scale this to 10-20 million vectors and need to provision the right hardware ...
Best practices
0
votes
0
replies
30
views
Advise of best practices for updating and deleting vectors in a large PolarDB table?
My application requires that vector embeddings are frequently updated or deleted. For example, when a user edits a blog post, its corresponding text embedding needs to be re-calculated and updated in ...
0
votes
0
answers
46
views
PolarDB vector database data import
I tried to import some MD files into PolarDB vector database. Some files hit errors like follow:
Failed file: monthly_2021_07_05.md
Log file: import_with_errors.log
Error context:
2025年10月28日 17:23:07,...