Search Results
https://dev.mysql.com/doc/ndbapi/en/ndb-column.html
The NDB API provides access to time types with microseconds (TIME, DATETIME, and TIMESTAMP) as Time2, Datetime2, and Timestamp2. (Time, Datetime, and Timestamp are deprecated as of the same version.) Use setPrecision() to set up to 6 fractional ...
https://dev.mysql.com/doc/relnotes/mysql-shell/8.4/en/news-8-4-0.html
The ociParManifest and ociParExpireTime options were removed from the Dump utilities. As of this release, dba.createCluster() and dba.createReplicaSet() validate these options and return an error if they are used with adoptFromGR=true. (Bug ...(Bug ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-connection-compression.html
The benefits of compression therefore occur primarily when there is low network bandwidth, network transfer time dominates the cost of compression and decompression operations, and result sets are large. As the compression level for an algorithm ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlimport.html
The mysqlimport client provides a command-line interface to the LOAD DATA SQL statement. Invoke mysqlimport like this: mysqlimport [options] db_name textfile1 [textfile2 ...] For each text file named on the command line, mysqlimport strips any ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-audit-plugins.html
To register the plugin at runtime, use this statement, adjusting the .so suffix for your platform as necessary: INSTALL PLUGIN NULL_AUDIT SONAME 'adt_null.so'; For additional information about plugin loading, see Installing and Uninstalling Plugins.
https://dev.mysql.com/doc/refman/8.4/en/create-procedure.html
The DEFINER and SQL SECURITY clauses specify the security context to be used when checking access privileges at routine execution time, as described later in this section. For NOW(), the binary log includes the timestamp and replicates correctly. By ...
https://dev.mysql.com/doc/refman/8.4/en/set-operations.html
Result Set Column Names and Data Types Set Operations with TABLE and VALUES Statements Set Operations using DISTINCT and ALL Set Operations with ORDER BY and LIMIT Limitations of Set Operations SQL set operations combine the results of multiple ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-4.html
InnoDB: Virtual column information for a row containing an externally stored BLOB was not always logged during an UPDATE operation, which sometimes resulted in an Index PRIMARY is corrupted error. (Bug #110706, Bug #113812, Bug #115608, Bug #116764, ...(Bug #37256912) macOS: Removed warnings of the form ld: warning: ignoring duplicate libraries and warnings specific to ... Account Management Notes C API Notes Character Set Support Compilation Notes Component Notes Firewall Notes Installation Notes Optimizer Notes Performance Schema Notes Functionality ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-source.html
rpl_semi_sync_master_timeout Command-Line Format --rpl-semi-sync-master-timeout=# Deprecated Yes System Variable rpl_semi_sync_master_timeout Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 10000 Minimum Value 0 Maximum ... This section describes the server options and system variables that you can use on replication source ...Startup Options for ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-enterprise-backup.html
Restore backup of s2 onto the host for s3: s3> mysqlbackup --defaults-file=/etc/my.cnf \ --datadir=/var/lib/mysql \ --backup-image=/backups/my.mbi_2206_1429 \ --backup-dir=/tmp/restore_`date +%d%m_%H%M` copy-back-and-apply-log Note The command above ...This section explains how to back up and subsequently restore a Group Replication member using MySQL Enterprise ... MySQL ...