7.9.3 Automatic Vector Index Creation

As of MySQL 9.5.0, MySQL HeatWave GenAI automatically creates vector indexes for frequenctly queried VECTOR columns in vector store and embedding tables using advanced index structures such as Hierarchical Navigable Small World (HNSW). This helps accelerate similarity search queries that use these columns.

Information about the created vector indexes are stored in the rpd_vector_indexes performance schema table.

Control Automatic Vector Index Creation and Usage

• To disable automatic index creation, use the rapid_auto_vector_index_enabled variable.

• To change the settings used for automatic vector index creation, use the following variables:

  • rapid_auto_vector_index_interval_seconds

  • rapid_auto_vector_index_server_memory_quota_pct

  • rapid_auto_vector_index_skip_quiet_check

  • rapid_auto_vector_index_build_timeout_seconds

• To change settings pertaining to usage of the created vector indexes, use the following variables:

  • rapid_hnsw_ef_search

  • rapid_hnsw_use_adaptive_accuracy_estimation

What's Next

Learn how to Start a Conversational Chat.