Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-features-memory.html
When a replication source server shuts down and restarts, its MEMORY tables become empty. To replicate this effect to replicas, the first time that the source uses a given MEMORY table after startup, it logs an event that notifies replicas that the ...This generated event is identifiable by a comment in the binary log, and if GTIDs are in use on the server, it has a GTID ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-0.html
(WL #16221) Microsoft Windows: Third party DLL files on which MySQL plugins depend are located, when installed, in the same directory as the MySQL executables. The default Windows behavior is to look for dependences in the same directory as the ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-generate-table.html
The ML_GENERATE_TABLE routine runs multiple text generation or summarization queries in a batch, in parallel. Note In versions older than MySQL 9.2.1, to alter an existing table or create a new table, MySQL requires you to set the ...The output ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations.html
Tables employing user-defined partitioning do not preserve the SQL mode in effect at the time that they were created. Therefore, a change in the SQL mode at any time after the creation of partitioned tables may lead to major changes in the behavior ... This section discusses current restrictions and limitations on MySQL partitioning ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-sysschema-tablestatistics-category.html
Lists the Sys Schema Table Statistics metrics and provides a brief description of each. Table 6.42 Sys Schema Table Statistics Metrics NameDescriptionDelete Latency The total wait time of timed delete IO events for the table. Fetch Latency The ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-embed-table.html
The ML_EMBED_TABLE routine runs multiple embedding generations in a batch, in parallel. Note In versions older than MySQL 9.2.1, to alter an existing table or create a new table, MySQL requires you to set the sql-require-primary-key system variable ...The input column must already exist and must contain text or varchar ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlshow.html
The mysqlshow client can be used to quickly see which databases exist, their tables, or a table's columns or indexes. If no table is given, all matching tables in the database are shown. If no column is given, all matching columns and column types ...The same information can be obtained by using those statements ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-myisam-bulk-data-loading.html
For a MyISAM table, you can use concurrent inserts to add rows at the same time that SELECT statements are running, if there are no deleted rows in middle of the data file. With some extra work, it is possible to make LOAD DATA run even faster for a ... These performance tips supplement the general guidelines for fast inserts in Section 10.2.5.1, “Optimizing INSERT ...
https://dev.mysql.com/doc/refman/8.4/en/sys-table-exists.html
Tests whether a given table exists as a regular table, a TEMPORARY table, or a view. If both a temporary and a permanent table exist with the given name, TEMPORARY is returned. Parameters in_db VARCHAR(64): The name of the database in which to ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-benefits.html
InnoDB tables have the following benefits: If the server unexpectedly exits because of a hardware or software issue, regardless of what was happening in the database at the time, you don't need to do anything special after restarting the database.