Search Results
https://dev.mysql.com/doc/refman/8.4/en/numeric-type-attributes.html
When used in conjunction with the optional (nonstandard) ZEROFILL attribute, the default padding of spaces is replaced with zeros. MySQL supports an extension for optionally specifying the display width of integer data types in parentheses ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-overview.html
Partition selection is also supported for the data modification statements DELETE, INSERT, REPLACE, UPDATE, and LOAD DATA, LOAD XML. This section provides a conceptual overview of partitioning in MySQL 8.4. For information on partitioning ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-pruning.html
In many cases, the equal sign can be replaced with another arithmetic comparison, including <, >, <=, >=, and <>. The optimization known as partition pruning is based on a relatively simple concept which can be described as “Do not scan ...
https://dev.mysql.com/doc/refman/8.4/en/password-security-admin.html
A user who has access to modify the plugin directory (the value of the plugin_dir system variable) or the my.cnf file that specifies the plugin directory location can replace plugins and modify the capabilities provided by plugins, including ...
https://dev.mysql.com/doc/refman/8.4/en/query-attributes.html
The most visible part of an SQL statement is the text of the statement. Clients can also define query attributes that apply to the next statement sent to the server for execution: Attributes are defined prior to sending the statement. Attributes ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-invoked.html
Replication of invoked features such as loadable functions and stored programs (stored procedures and functions, triggers, and events) provides the following characteristics: The effects of the feature are always replicated. The following ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-triggers.html
The effect for this trigger is thus the same as the multiple triggers it replaces. With statement-based replication, triggers executed on the source also execute on the replica. With row-based replication, triggers executed on the source do not ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-concepts.html
A global transaction identifier (GTID) is a unique identifier created and associated with each transaction committed on the server of origin (the source). This identifier is unique not only to the server on which it originated, but is unique across ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-lifecycle.html
You can also choose whether to replace the whole GTID set in gtid_purged with a specified GTID set, or to add a specified GTID set to the GTIDs already in gtid_purged. The life cycle of a GTID consists of the following steps: A transaction is ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-slaveinit.html
To do this, on the replica, execute the following CHANGE REPLICATION SOURCE TO statement, replacing the option values with the actual values relevant to your system: mysql> CHANGE REPLICATION SOURCE TO -> SOURCE_HOST='source_host_name', -> ... To ...