Search Results
https://dev.mysql.com/doc/refman/8.4/en/full-text-adding-collation.html
To add a collation for full-text indexing, use the following procedure. Warning User-defined collations are deprecated; you should expect support for them to be removed in a future version of MySQL. The server issues a warning for any use of ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-frequently-asked-questions.html
However, if the network drops packets, leading to re-transmissions and higher end-to-end latency, throughput and latency are both negatively affected. See Section 19.2.4.1, “The Relay Log” for a recovery procedure in this situation. What is the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-summary.html
The conflict resolution procedure states that the transaction that was ordered first commits on all servers, and the transaction ordered second aborts, and is therefore rolled back on the originating server and dropped by the other servers in the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-migration.html
If the floating-point formats differ but you have not used FLOAT or DOUBLE data types in your tables, then the procedure is the same: simply copy the relevant files. This section describes techniques for moving or copying some or all InnoDB tables ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-persistent-stats.html
When an index is added to an existing table, or when a column is added or dropped, index statistics are calculated and added to the innodb_index_stats table regardless of the value of innodb_stats_auto_recalc. These tables are set up automatically ... The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-system-tablespace.html
Unlike the system tablespace, file-per-table tablespaces return disk space to the operating system when they are truncated or dropped. The system tablespace is the storage area for the change buffer. It may also contain table and index data if ...
https://dev.mysql.com/doc/refman/8.4/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-summary-tables.html
Each row summarizes events for a given stored program (stored procedure or function, trigger, or event). The row for an object is removed when the object is dropped. The Performance Schema maintains tables for collecting current and recent ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-current-user.html
In some cases, such as statements that change passwords, the function reference is expanded before it is written to the binary log, so that the statement includes the user name. For all other cases, the name of the current user on the source is ...
https://dev.mysql.com/doc/refman/8.4/en/statement-caching.html
(The sum of the number of prepared statements across all sessions.) Stored programs (stored procedures and functions, triggers, and events). Metadata changes occur for DDL statements such as those that create, drop, alter, rename, or truncate ...