Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-functions-for-new-primary.html
This function replaces the usual primary election process; see Section 20.5.1.1, “Changing the Primary”, for more information. The following function enables you to set a member of a single-primary replication group to take over as the primary.
https://dev.mysql.com/doc/refman/8.4/en/partitioning-overview.html
Nonetheless, most advanced database management systems have evolved some means of determining the physical location to be used for storing specific pieces of data in terms of the file system, hardware or even both. However, there is nothing ... This ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rules-channel-based-filters.html
Channel specific replication filters are particularly useful in a multi-source replication topology when the same database or table is present on multiple sources, and the replica is only required to replicate it from one source. However, with ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-commands-restore.html
The restore operations restores the data files from a backup to their original locations on the database server, or to other desired locations. Normally, the restoration process requires the database server to be already shut down (or, at least not ...The option datadir must be specified either in the file specified by the --defaults-file option or as a command-line ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-9-4-0.html
It supports the Java Database Connectivity (JDBC) 4.2 API, and implements the X DevAPI. (Bug #44791, Bug #11753361) To simplify the codebase of Connector/J, the IterateBlock class has been removed, with its function replaced by traditional for loops. (Bug #38044940) A java.sql.Time instance created from a negative millisecond value, when inserted into a database via using a PreparedStatement, lost its fractional part of the ...
https://dev.mysql.com/doc/internals/en/transformation-scalar-in.html
The scalar IN subquery will be replaced with an Item_in_optimizer item. If the subquery does not contain HAVING, SUM() function, or GROUP BY (example 2), then: item list will be replaced with 1. To rewrite a scalar IN subquery, the ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-event-handlers-email-group-controls-reference.html
You can add some, or all, of the following variables to the subject line: {0}: replaced by the alarm level of the event. {1}: replaced by the name of the advisor which generated the alert. {2}: replaced by the name of the server which triggered the ... This section describes the controls on the Email Notification Group ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-ssh-tunnel.html
Stop the agent and change the hostname value as shown in the following: agent-mgmt-hostname = https://agent_name:password@localhost:18443/ Replace the agent_name and password with suitable values. Likewise replace port 18443 if you are not running ... If you run an SSH server on the machine that hosts the MySQL Enterprise Service Manager and an SSH client on the machine that hosts the agent, you can create an SSH tunnel so that the agent can bypass your ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-load-event-based.html
To create the policy statement, use the following syntax: Allow dynamic-group dynamic_group_name to use stream-pull in compartment compartment_name where any {target.stream.id = 'stream_OCID_1', target.stream.id = 'stream_OCID_2'} Replace ... As of ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax-json.html
end-object column_option_key_value: { "date_format": "custom_date_format" | "time_format": "custom_time_format" | "timestamp_format": "custom_timestamp_format" | "model": {MySQL HeatWave_in_database_embedding_model} } model: Supported as of MySQL ...