Re:Vector Search in open-source MySQL
by deesix on Wednesday September 16, 2026 @03:10PM
(#49731528)
Code to create HNSW index:
CREATE TABLE demo_vectors (
id INT PRIMARY KEY,
embedding SVECTOR(3) NOT NULL,
INDEX idx_embedding (embedding hnsw_l2) USING EXTENDED(hnsw)
) ENGINE=InnoDB;
CREATE TABLE demo_vectors ( id INT PRIMARY KEY, embedding SVECTOR(3) NOT NULL, INDEX idx_embedding (embedding hnsw_l2) USING EXTENDED(hnsw) ) ENGINE=InnoDB;