PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-params-ndbd.html
RedoOverCommitCounter: When RedoOverCommitLimit has been exceeded this many times, transactions are aborted, and operations are handled as specified by DefaultOperationRedoProblemAction. For detailed descriptions and other additional information ...
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/window-functions-frames.html
(For details about the permitted units specifiers, see the description of the DATE_ADD() function in Section 14.7, “Date and Time Functions”.) RANGE on a numeric or temporal expr requires ORDER BY on a numeric or temporal expression, ...A frame ... The definition of a window used with a window function can include a frame ...
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/creating-ssl-files-using-openssl.html
This section describes how to use the openssl command to set up SSL certificate and key files for use by MySQL servers and clients. The first example shows a simplified procedure such as you might use from the command line. The first two examples ...The third example describes how to set up SSL files on ...
https://dev.mysql.com/doc/refman/8.0/en/built-in-function-reference.html
Yes WEEK() Return the week number WEEKDAY() Return the weekday index WEEKOFYEAR() Return the calendar week of the date (1-53) WEIGHT_STRING() Return the weight string for a string XOR Logical XOR YEAR() Return the year YEARWEEK() Return the year and ... The following table lists each built-in (native) function and operator and provides a short description of each ...