Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-features-optimizer.html
It is possible for the data on the source and replica to become different if a statement is written in such a way that the data modification is nondeterministic; that is, left up the query optimizer. (In general, this is not a good practice, even ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rbr-usage.html
MySQL uses statement-based logging (SBL), row-based logging (RBL) or mixed-format logging. The MySQL server tracks the logging mode that was in effect when each temporary table was created. mysqlbinlog displays row-based events in the binary log ...
https://dev.mysql.com/doc/refman/8.4/en/show-profile.html
Note The SHOW PROFILE and SHOW PROFILES statements are deprecated; expect them to be removed in a future MySQL release. Enable profiling by setting profiling to 1 or ON: mysql> SET profiling = 1; SHOW PROFILES displays a list of the most recent ...
https://dev.mysql.com/doc/refman/8.4/en/show-variables.html
SHOW [GLOBAL | SESSION] VARIABLES [LIKE 'pattern' | WHERE expr] SHOW VARIABLES shows the values of MySQL system variables (see Section 7.1.8, “Server System Variables”). These are the values used to initialize the corresponding session ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-before-you-begin.html
The backup should include the mysql system database, which contains the MySQL data dictionary tables and system tables. Important Downgrade from MySQL 8.4 to MySQL 8.3, or from a MySQL 8.4 release to a previous MySQL 8.4 release, is not supported.
https://dev.mysql.com/doc/refman/8.4/en/view-restrictions.html
(This is another reason you might wish to force MySQL to use the temptable algorithm by specifying ALGORITHM = TEMPTABLE in the view definition.) You can use DROP TABLE or ALTER TABLE to drop or alter a table that is used in a view definition. That ... The maximum number of tables that can be referenced in the definition of a view is ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.usage.html
The following sections describe the command-line options for the different modes of operation of mysqlbackup. mysqlbackup follows the MySQL standard practice for handling duplicate options, whether specified in a configuration file, on the command ...Use the hyperlinks at the option names to jump to the detailed descriptions for the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/restoring.html
The ultimate purpose of backup data is to help recover from a database issue or to create a clone of the original database server in another location (typically, to run report queries or to create a new replica). After a serious database issue, you ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-add-process.html
Adding Free Processes Using the add process command, you can add unmanaged mysqld processes, or ndbapi slots for ndbapi applications such as ndb_restore. Consider the following set of commands that creates and then starts a cluster named mycluster: ...Any hosts referenced in the list must be members of the site to which the cluster ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-27.html
Version 8.0.27 is the latest General Availability release of the 8.0 series of MySQL Connector/J. It is suitable for use with MySQL Server versions 8.0, 5.7, and 5.6. (Bug #33185116) In line with good XML practices, the getSource() method of ...It ...