offline model installation for KNN

General Discussions - English
1

Is it possible to manually install models for KNN to a computer that normally has no internet connection? I created a KNN column on a computer with internet connection, then copied over the model to the computer without internet connnection, but was not able to create the same column. It seems like it requires a connection even if the model is in the cache directory.

2

It should work without the internet, as shown here: https://www.youtube.com/watch?v=sUvmDw3DC-c

3 
mysql> drop table if exists products; CREATE TABLE products (     title TEXT,     description TEXT,     embedding_vector FLOAT_VECTOR KNN_TYPE='hnsw' HNSW_SIMILARITY='l2'     MODEL_NAME='Xenova/all-MiniLM-L6-v2' FROM='title' );
Query OK, 0 rows affected (0.005 sec)

Query OK, 0 rows affected (0.002 sec)

also works for me without the internet when the model is cached.

4

Thanks Sergey, could you include how you transferred the model to the machine without internet?