PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/backup-and-recovery.html
Backups are also essential as a safeguard before upgrading a MySQL installation, and they can be used to transfer a MySQL installation to another system or to set up replica servers. MySQL offers a variety of backup strategies from which you can ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-limitations.html
Only a single MySQL instance can be cloned at a time. The clone plugin is subject to these limitations: An instance cannot be cloned from a different MySQL server series. For example, you cannot clone between MySQL 8.0 and MySQL 8.4, but can clone ...A workaround is to use dedicated donor instances, which can accommodate DDL operations being blocked while data is ...
https://dev.mysql.com/doc/refman/8.0/en/expired-password-handling.html
Pass the CLIENT_CAN_HANDLE_EXPIRED_PASSWORDS flag to mysql_real_connect() at connect time: MYSQL mysql; mysql_init(&mysql); if (!mysql_real_connect(&mysql, host, user, password, db, port, unix_socket, CLIENT_CAN_HANDLE_EXPIRED_PASSWORDS)) { ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-responses-failure-exit.html
The group_replication_exit_state_action system variable, which is available from MySQL 8.0.12 and MySQL 5.7.24, specifies what Group Replication does when the member leaves the group unintentionally due to an error or problem, and either fails to ...Note that in the case of an expelled member, the member does not know that it was expelled until it reconnects to the group, so the specified action is only taken if the member manages to reconnect, or if the member raises a suspicion on itself and expels ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-introduction.html
INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access privileges. Other terms that are sometimes used for this information are data ...They are actually views, not base tables, so there are no files associated with them, and you cannot set triggers on ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-migration.html
In conjunction with the MySQL binary log, you can perform point-in-time recovery. For example, you might move an entire MySQL instance to a larger, faster server; you might clone an entire MySQL instance to a new replica server; you might copy ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-range-list.html
To drop the partition named p2, execute the following command: mysql> ALTER TABLE tr DROP PARTITION p2; Query OK, 0 rows affected (0.03 sec) Note The NDBCLUSTER storage engine does not support ALTER TABLE ... You can see that this is the case by ...
https://dev.mysql.com/doc/refman/8.0/en/replica-io-thread-states.html
This state also appears in the Replica_IO_State column displayed by SHOW REPLICA STATUS (or before MySQL 8.0.22, SHOW REPLICA STATUS), so you can get a good view of what is happening by using that statement. In MySQL 8.0.26, incompatible changes ...
https://dev.mysql.com/doc/refman/8.0/en/replication-semisync-installation.html
To use semisynchronous replication, the following requirements must be satisfied: The capability of installing plugins requires a MySQL server that supports dynamic loading. MySQL 8.0.26 and later supply new versions of the plugins that implement ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-instances.html
This section explains the configuration settings required for MySQL Server instances that you want to use for Group Replication. Set the disabled_storage_engines system variable as follows to prevent their use: ...Storage Engines Replication ...