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-memory-summary-tables.html
Allocating a single byte one million times is not the same as allocating one million bytes a single time; tracking both sizes and counts can expose the difference. The memory/performance_schema/ instruments are built in, always enabled, and cannot ...Operation counts help to understand or tune the overall pressure the server is putting on the memory allocator, which has an impact on ...
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/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/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/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/mysql-cluster-replication-multi-source.html
All SQL nodes acting as sources and replicas are started with the system variable log_replica_updates (beginning with NDB 8.0.26) or log_slave_updates (NDB 8.0.26 and earlier) enabled. You must not start any of the SQL nodes with the system variable ...Each cluster has two SQL nodes, with SQL nodes A and B belonging to Cluster 1, SQL nodes C and D belonging to Cluster 2, and SQL nodes E and F belonging to ...