Search Results
https://dev.mysql.com/doc/refman/8.4/en/multiple-data-directories.html
Windows MSI package installers create and set up the data directory that the installed server uses, but also create a pristine “template” data directory named data under the installation directory. After an installation has been performed using ... Each MySQL Instance on a machine should have its own data ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-operations.html
For ALGORITHM=COPY, the mysqld NDB Cluster handler performs the following actions: Tells the data nodes to create an empty copy of the table, and to make the required schema changes to this copy. For ALGORITHM=INPLACE, the NDB Cluster handler tells ... MySQL NDB Cluster supports online table schema changes using ALTER TABLE ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-options-system-variables.html
mysqlx_compression_algorithms Command-Line Format --mysqlx-compression-algorithms=value System Variable mysqlx_compression_algorithms Scope Global Dynamic Yes SET_VAR Hint Applies No Type Set Default Value deflate_stream,lz4_message,zstd_stream ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-genai-byo-embedding-tables.html
To define your natural-language query, set the @query variable: SET @query="AddYourQuery"; Replace AddYourQuery with your natural-language query. Provide the vector embedding of the input query: SET @query_embedding = ... GenAI lets you use tables ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-4.html
(Bug #37305289) Implemented the standards-compliant my_char_traits<unsigned char> for use as a drop-in replacement for std::char_traits<unsigned char>, which was deprecated in Clang 18 and removed in Clang 19. (Bug #37271715) InnoDB: It was possible ... Account Management Notes C API Notes Character Set Support Compilation Notes Component Notes Firewall Notes Installation Notes Optimizer Notes Performance Schema Notes Functionality Added or Changed Bugs Fixed Account Management Notes The database cache was not flushed properly following execution of DROP ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-parameters.html
innodb_checksum_algorithm Command-Line Format --innodb-checksum-algorithm=value System Variable innodb_checksum_algorithm Scope Global Dynamic Yes SET_VAR Hint Applies No Type Enumeration Default Value crc32 Valid Values ... InnoDB Startup Options ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-byo-embedding-tables.html
To define your natural-language query, set the @query variable: SET @query="AddYourQuery"; Replace AddYourQuery with your natural-language query. To define your natural-language query, set the @query variable: SET @query="AddYourQuery"; Replace ...
https://dev.mysql.com/doc/refman/8.4/en/glossary.html
adaptive flushing An algorithm for InnoDB tables that smooths out the I/O overhead introduced by checkpoints. The adaptive flushing algorithm extends this process by estimating the optimal rate to perform these periodic flushes, based on the rate of ... These terms are commonly used in information about the MySQL database ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-row-searches.html
The algorithm used to carry out this process uses one of the table's indexes to carry out the search as the first choice, and a hash table if there are no suitable indexes. The algorithm first assesses the available indexes in the table definition ... When a replica using row-based replication format applies an UPDATE or DELETE operation, it must search the relevant table for the matching ...
https://dev.mysql.com/doc/refman/8.4/en/change-replication-source-to.html
Important A replica set up with ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS on any channel cannot be promoted to replace the replication source server in the event that a failover is required, and a backup taken from the replica cannot be used to restore ...] CHANGE REPLICATION SOURCE TO changes the parameters that the replica server uses for connecting to the source and reading data from the ...