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/performance-schema-replication-tables.html
The following Performance Schema replication tables continue to be populated when the Performance Schema is disabled: replication_connection_configuration replication_connection_status replication_asynchronous_connection_failover ...This is similar ...The replication tables store errors on a per-thread basis without loss of ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-view-changes.html
When Group Replication's distributed recovery process is carrying out state transfer from the binary log, to synchronize the joining member with the donor up to a specific point in time, the joining member and donor make use of GTIDs (see Section ...They do not help marking a specific point in time to which the server joining the group must catch up, nor do they convey certification ...
https://dev.mysql.com/doc/refman/8.0/en/memory-use.html
The memory is only allocated when needed, but it might be used if your replication topology handles large transactions sometimes. MySQL allocates buffers and caches to improve performance of database operations. You can improve MySQL performance by ...The default configuration is designed to permit a MySQL server to start on a virtual machine that has approximately 512MB of ...
https://dev.mysql.com/doc/refman/8.0/en/windows-pluggable-authentication.html
Alternatively, to load the plugin at runtime, use this statement: INSTALL PLUGIN authentication_windows SONAME 'authentication_windows.dll'; INSTALL PLUGIN loads the plugin immediately, and also registers it in the mysql.plugins system table to ...
https://dev.mysql.com/doc/refman/8.0/en/account-categories.html
For example, if a user can grant the SELECT and UPDATE privileges to regular accounts, then with SYSTEM_USER the user can also grant SELECT and UPDATE to system accounts. By direct grant-table modification using statements such as INSERT and UPDATE.
https://dev.mysql.com/doc/refman/8.0/en/index-merge-optimization.html
The Index Merge access method retrieves rows with multiple range scans and merges their results into one. In this case, the key column contains a list of indexes used, and key_len contains a list of the longest key parts for those indexes. The ...
https://dev.mysql.com/doc/refman/8.0/en/multifactor-authentication.html
MFA enables additional authentication methods, such as authentication using multiple passwords, or authentication using devices like smart cards, security keys, and biometric readers. When a client attempts a connection to the MySQL server using a ... Authentication involves one party establishing its identity to the satisfaction of a second ...
https://dev.mysql.com/doc/refman/8.0/en/programs-overview.html
It updates the grant tables with any changes that have been made in newer versions of MySQL, and checks tables for incompatibilities and repairs them if necessary. Each program's description indicates its invocation syntax and the options that it ...
https://dev.mysql.com/doc/refman/8.0/en/timestamp-initialization.html
TIMESTAMP and DATETIME columns can be automatically initialized and updated to the current date and time (that is, the current timestamp). In addition, if the explicit_defaults_for_timestamp system variable is disabled, you can initialize or update ...For any TIMESTAMP or DATETIME column in a table, you can assign the current timestamp as the default value, the auto-update value, or both: An auto-initialized column is set to the current timestamp for inserted rows that specify no value for the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-semisync.html
If your goal is to implement a fault-tolerant replication topology where all the servers receive the same transactions in the same order, and a server that crashes can rejoin the group and be brought up to date automatically, you can use Group ...