Search Results
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-cluster-config-metric-sourcestatus-category.html
Load Data Temp Directory Directory used for temporary files during replication updates. Sync Source Info Synchronizes the source info file to disk after each update. Sync Relay Log Info Synchronizes the relay log info file to disk after each update.
https://dev.mysql.com/doc/refman/8.4/en/replication-features-differing-tables.html
A column's default value is determined by a number of factors, including its type, whether it is defined with a DEFAULT option, whether it is declared as NULL, and the server SQL mode in effect at the time of its creation; for more information, see ... Source and target tables for replication do not have to be ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-connection-compression.html
On the client side, an X Protocol connection request can specify several parameters for compression control: The compression mode. The connection mode has these permitted values: disabled: The connection is uncompressed. required: Compression ... X ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-deadlock-example.html
If client A attempts to update a row in Birds at the same time, this will lead to a deadlock: mysql> UPDATE Birds SET value=40 WHERE name='Buzzard'; ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction InnoDB rolls ... The following example illustrates how an error can occur when a lock request causes a ...
https://dev.mysql.com/doc/mysql-installer/en/MySQLInstallerConsole.html
For example, to show the console's help: MySQLInstallerConsole.exe --help =================== Start Initialization =================== MySQL Installer is running in Community mode Attempting to update manifest. Possible actions are: [--]configure, ... MySQLInstallerConsole.exe provides command-line functionality that is similar to MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-deploying-in-single-primary-mode.html
Each of the MySQL server instances in a group can run on an independent physical host machine, which is the recommended way to deploy Group Replication. This section explains how to create a replication group with three MySQL Server instances, each ...
https://dev.mysql.com/doc/refman/8.4/en/password-security-user.html
To keep this file safe, use a restrictive access mode, the same way as described earlier for the .my.cnf file. In short, the safest methods are to have the client program prompt for the password or to specify the password in a properly protected ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-commands.html
If you are running with --safe-updates enabled, status also prints the values for the mysql variables that affect your queries. For server side help, type 'help contents' If mysql is invoked with the --binary-mode option, all mysql commands are ...
https://dev.mysql.com/doc/refman/8.4/en/datetime.html
The TIMESTAMP and DATETIME data types offer automatic initialization and updating to the current date and time. For more information, see Section 13.2.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”. Invalid DATE, DATETIME, ...This section describes their characteristics, how they are similar, and how they ...
A Quick Guide to Using the MySQL SLES Repository :: A Quick Guide to Using the MySQL SLES Repository
https://dev.mysql.com/doc/mysql-sles-repo-quick-guide/en/index.html
Although this is not required for each update, it does update MySQL repository information to include the current information. Among other instructions discussed there, it is especially important to back up your database before the update. To update ... Abstract This is a quick guide for using the MySQL SLES repository to install and upgrade MySQL on SUSE Linux Enterprise Server ...