Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-vector-store-overview.html
About Vector Processing To create vector embeddings, MySQL HeatWave GenAI uses in-database embedding models, which are encoders that converts sequence of words and sentences from documents into numerical representations. Then, it segments the parsed ... This section describes the Vector Store functionality available in MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/drop-function-loadable.html
(DROP FUNCTION is also used to drop stored functions; see Section 15.1.29, “DROP PROCEDURE and DROP FUNCTION Statements”.) DROP FUNCTION is the complement of CREATE FUNCTION. During the normal startup sequence, the server loads functions ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locking.html
For such cases, InnoDB creates a hidden clustered index and uses this index for record locking. Client A creates a table containing two index records (90 and 102) and then starts a transaction that places an exclusive lock on index records with an ...Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks AUTO-INC Locks Predicate Locks for Spatial Indexes Shared and Exclusive Locks InnoDB implements standard row-level locking where there are two types of locks, shared (S) locks and exclusive (X) ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-migration.html
To move databases in a binary format from Unix to Windows or from Windows to Unix, create all databases and tables using lowercase names. In addition, MySQL Enterprise Backup can create compressed backup files, and back up subsets of tables. The ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-backups.html
Create any databases on the replica cluster that are present on the source cluster and that are to be replicated. Important A CREATE DATABASE (or CREATE SCHEMA) statement corresponding to each database to be replicated must be executed on each SQL ... This section discusses making backups and restoring from them using NDB Cluster ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-issues.html
Note Every NDB table is implicitly partitioned by key when it is created. Restarting the cluster with the --initial option causes the sequence of GCI and epoch numbers to start over from 0. This section discusses known problems or issues when using ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-configurator-cli.html
open_win_firewall N/A open-windows-firewall, openfirewall bool true, false true configure, reconfigure enable-tcp-ip=true Creates Windows Firewall rules for TCP/IP connections for both the port and mysqlx-port options. The binary log is a sequence ... MySQL Configurator supports GUI (default) and CLI (by passing in --console) modes using the mysql_configurator.exe ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-functions.html
For this reason, if you select from the replica's copy of mytable after the CREATE TABLE and INSERT statements just shown have been replicated, you might expect mycol to contain the value 2009-09-01 18:00:00. Certain functions do not replicate well ...
https://dev.mysql.com/doc/refman/8.4/en/security-guidelines.html
A passphrase containing multiple words is easy to create, remember, and reproduce, and is much more secure than a typical user-selected password consisting of a single modified word or a predictable sequence of characters. To create a secure ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-binary-package.html
If not, the server creates them in the data directory, populates them with metadata, and then proceeds with its normal startup sequence. Important If you have tables that contain generated columns, use the mysqldump utility provided with MySQL 5.7.9 ... This section describes how to upgrade MySQL binary and package-based installations on ...