Search Results
https://dev.mysql.com/doc/refman/9.7/en/replication-delayed.html
MySQL supports delayed replication such that a replica server deliberately executes transactions later than the source by at least a specified amount of time. This section describes delayed replication between servers which are all using these ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/admin-api-routing-guidelines.html
Manage resource allocation by routing traffic based on server or router tags to ensure workloads are distributed according to resource availability and capabilities. Routing sessions to clusters or servers based on the MySQL version, ensuring ...
https://dev.mysql.com/doc/refman/9.7/en/large-page-support.html
Some hardware and operating system architectures support memory pages greater than the default (usually 4KB). The actual implementation of this support depends on the underlying hardware and operating system. The kernels for some recent systems ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-installation-windows-path.html
To make it easier to invoke MySQL programs, you can add the path name of the MySQL bin directory to your Windows system PATH environment variable: On the Windows desktop, right-click the My Computer icon, and select Properties. Next select the ...
https://dev.mysql.com/doc/refman/9.7/en/replica-logs-relaylog.html
The default relay log file and relay log index file names and locations can be overridden with, respectively, the relay_log and relay_log_index system variables (see Section 19.1.6, “Replication and Binary Logging Options and Variables”). On a ...For the default replication channel, relay log file names have the default form host_name-relay-bin.nnnnnn, where host_name is the name of the replica server host and nnnnnn is a sequence ...
https://dev.mysql.com/doc/refman/9.7/en/replication-solutions-unexpected-replica-halt.html
The details of the recovery process are influenced by the chosen method of replication, whether the replica is single-threaded or multithreaded, and the setting of relevant system variables. The system variable itself is also deprecated, so omit it ... In order for replication to be resilient to unexpected halts of the server (sometimes described as crash-safe) it must be possible for the replica to recover its state before ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/partial.html
IMPORTANT: Because the InnoDB system tablespace holds metadata about InnoDB tables from all databases in an instance, restoring a partial backup on a server that includes other databases could cause the system to lose track of those InnoDB tables in ...In particular, InnoDB tables have internal IDs and other data values that can only be restored to the same instance, not a different MySQL ... By default, all the files under the database subdirectories in the data directory are included in the backup, so ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-using-an-anomaly-detection-model.html
You can use the session variable for the model that is valid for the duration of the connection. You can use the session variable for the model that is valid for the duration of the connection. The system has been shut down for further ...To ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-concepts.html
Table 10.1 Conceptual equivalents between supported DBMS products and MySQL Concept MS SQL Server Sybase ASE PostgreSQL MySQL Note Authentication Yes Yes Yes Yes Auto_Increment Yes Yes Yes Yes PostgreSQL uses sequences for Auto_Increment. The ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-new.html
Figure 5.1 Setup New Connection Form Important The Configure Server Management button (bottom left) opens an optional configuration wizard for setting shell commands on the host. Fill out the connection details and optionally click Configure Server ... To add a connection, click the [+] icon to the right of the MySQL Connections title on the home ...