Search Results
https://dev.mysql.com/doc/ndbapi/en/ndb-ndboperation.html
The steps required to release these locks are listed here: Define the primary key read operation in the normal way with LockMode set to LM_Read or LM_Exclusive. A single row in the database may have concurrent multiple lock holders (mode LM_Read) ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations.html
Tables employing user-defined partitioning do not preserve the SQL mode in effect at the time that they were created. As discussed elsewhere in this Manual (see Section 7.1.11, “Server SQL Modes”), the results of many MySQL functions and ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-connection-compression.html
The connection mode has these permitted values: disabled: The connection is uncompressed. However, the option for compression algorithms is subject to the compression mode: If the compression mode is disabled, the compression algorithms option is ...
https://dev.mysql.com/doc/workbench/en/wb-configuration-additional.html
Safe Updates: When enabled (default), MySQL Workbench will not execute UPDATE or DELETE statements if a key is not defined in the WHERE clause. For example, DELETE FROM foo is considered unsafe, whereas DELETE FROM foo WHERE id = 1 is safe and will ... Commonly used configuration options and preferences include: Rescan for Local MySQL Instances: Right-click on the home screen, and this option will scan your system for MySQL instances and add connection tiles to the home ...
https://dev.mysql.com/doc/refman/8.4/en/comparison-operators.html
Table 14.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less than operator <>, != Not equal operator <= Less than or equal operator <=> NULL-safe equal to operator = Equal operator BETWEEN ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-enterprise-backup.html
For example, on Linux distributions that use systemd: s3> systemctl stop mysqld Preserve the two configuration files in the corrupted server's data directory, auto.cnf and mysqld-auto.cnf (if it exists), by copying them to a safe location outside of ... MySQL Enterprise Backup is a commercially-licensed backup utility for MySQL Server, available with MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.4/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/mysql-installer/en/MySQLInstallerConsole.html
False (default) to disable offline mode (run with an internet connection). For example, to show the console's help: MySQLInstallerConsole.exe --help =================== Start Initialization =================== MySQL Installer is running in Community ... MySQLInstallerConsole.exe provides command-line functionality that is similar to MySQL ...
https://dev.mysql.com/doc/workbench/en/wb-preface.html
If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. If you are using a Commercial release of MySQL Workbench, ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-j2ee-concepts-load-balancing-failover.html
When trying to balance workload between multiple servers, the driver has to determine when it is safe to swap servers, doing so in the middle of a transaction, for example, could cause problems. This allows you to identify a trigger statement that ... Connector/J provides a useful load-balancing implementation for MySQL Cluster or multi-source deployments, as explained in Section 3.8.3, “Configuring Load Balancing with Connector/J” and Support for Multiple-Source Replication ...