Search Results
https://dev.mysql.com/doc/refman/8.4/en/replica-io-thread-states.html
If the incompatible changes have an impact for you, set the terminology_use_previous system variable to BEFORE_8_0_26 to make MySQL Server use the old versions of the names for the objects specified in the previous list. This can last for a long ...
https://dev.mysql.com/doc/refman/8.4/en/replication-binlog-encryption-scope.html
Data in motion in the replication event stream, which is sent to MySQL clients including mysqlbinlog, is decrypted for transmission, and should therefore be protected in transit by the use of connection encryption (see Section 8.3, “Using ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-transaction-inconsistencies.html
When using a multithreaded replica, workers which have not received an error complete their queues, so it may take time to stop all threads. After this timeout, the coordinator gives up and aborts the transaction. After this timeout, it aborts the ... Inconsistencies in the sequence of transactions that have been executed from the relay log can occur depending on your replication ...
https://dev.mysql.com/doc/refman/8.4/en/server-configuration-defaults.html
The MySQL server has many operating parameters, which you can change at server startup using command-line options or configuration files (option files). For general instructions on setting parameters at startup or runtime, see Section 7.1.7, ...
https://dev.mysql.com/doc/refman/8.4/en/server-option-variable-reference.html
The following table lists all command-line options, system variables, and status variables applicable within mysqld. For a version of this table that is specific to NDB Cluster, see Section 25.4.2.5, “NDB Cluster mysqld Option and Variable ...The ...
https://dev.mysql.com/doc/refman/8.4/en/sys-execute-prepared-stmt.html
Thus, this procedure is useful primarily for executing dynamic statements on a one-time basis. Example mysql> CALL sys.execute_prepared_stmt('SELECT COUNT(*) FROM mysql.user'); +----------+ | COUNT(*) | +----------+ | 15 | +----------+ . Given an ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-views.html
The sys schema contains many views that summarize Performance Schema tables in various ways. Most of these views come in pairs, such that one member of the pair has the same name as the other member, plus a x$ prefix. The view with the x$ prefix ...
https://dev.mysql.com/doc/refman/8.4/en/view-restrictions.html
In this case, the view is stored in a temporary table and thus you are not really selecting from the table in a subquery and modifying it at the same time. (This is another reason you might wish to force MySQL to use the temptable algorithm by ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-compression-options.html
For a regular backup, among all the storage engines supported by MySQL, only data files of the InnoDB format are compressed, and they bear the .ibz extension after the compression. Out of the three compression algorithms that are supported, this is ... For an overview on backup compression, see Section 4.3.4, “Making a Compressed ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-files-backed-up-myisam.html
mysqlbackup also backs up the .MYD files, .MYI files, and the .sdi files associated with the MyISAM tables. Note While MySQL Enterprise Backup can back up non-InnoDB data (like MYISAM tables), the MySQL server to be backed up must support InnoDB ...