PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.3Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/password-security-admin.html
MySQL stores passwords for user accounts in the mysql.user system table. Access to this table should never be granted to any nonadministrative accounts. The validate_password plugin can be used to enforce a policy on acceptable password. Database ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-instrumentation-checking.html
It is always possible to determine what instruments the Performance Schema includes by checking the setup_instruments table. As described earlier, it is possible to find out by querying the setup_instruments table. Changes to this code occur often, ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-memory-model.html
The buffers are global to the server, so the instruments are displayed only in the memory_summary_global_by_event_name table, and not in other memory_summary_by_xxx_by_event_name tables. Memory used depends on the load actually seen, not the load ...
https://dev.mysql.com/doc/refman/8.0/en/permission-optimization.html
Simplifying the privileges established by GRANT statements enables MySQL to reduce permission-checking overhead when clients execute statements. For example, if you do not grant any table-level or column-level privileges, the server need not ever ...
https://dev.mysql.com/doc/refman/8.0/en/replication-asynchronous-connection-failover-source.html
Suitable values are SOURCE_RETRY_COUNT=3 | MASTER_RETRY_COUNT=3 and SOURCE_CONNECT_RETRY=10 | MASTER_CONNECT_RETRY=10, which make the replica retry the connection 3 times with 10-second intervals between. This feature ensures that the replica stays ... To activate asynchronous connection failover for a replication channel set SOURCE_CONNECTION_AUTO_FAILOVER=1 on the CHANGE REPLICATION SOURCE TO statement (from MySQL 8.0.23) or CHANGE MASTER TO statement (before MySQL 8.0.23) for the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-drop-if-exists.html
The DROP DATABASE IF EXISTS, DROP TABLE IF EXISTS, and DROP VIEW IF EXISTS statements are always replicated, even if the database, table, or view to be dropped does not exist on the source. This is to ensure that the object to be dropped no longer ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-max-allowed-packet.html
This means that, when you are replicating large column values using row-based replication, you must take care to set max_allowed_packet large enough to accommodate the largest row in any table to be replicated, even if you are replicating updates ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-shutdowns.html
However, be careful that the replica does not have temporary tables open; see Section 19.5.1.31, “Replication and Temporary Tables”. It is safe to shut down a replication source server and restart it later. When a replica loses its connection ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-timeout.html
The Performance Schema table replication_applier_status shows the total number of transaction retries that took place on each replication channel, in the COUNT_TRANSACTIONS_RETRIES column. The Performance Schema table ... The global value of the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-formats.html
When using row-based logging, the source writes events to the binary log that indicate how individual table rows are changed. Replication of the source to the replica works by copying the events representing the changes to the table rows to the ...