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/mysql-ssl-rsa-setup.html
Instead, consider using MySQL server to generate missing SSL and RSA files automatically at startup (see Automatic SSL and RSA File Generation). This program creates the SSL certificate and key files and RSA key-pair files required to support secure ...mysql_ssl_rsa_setup can also be used to create new SSL files if the existing ones have ...
https://dev.mysql.com/doc/refman/8.0/en/create-view.html
The view definition is “frozen” at creation time and is not affected by subsequent changes to the definitions of the underlying tables. The DEFINER and SQL SECURITY clauses specify the security context to be used when checking access privileges ...For example, if a view is defined as SELECT * on a table, new columns added to the table later do not become part of the view, and columns dropped from the table result in an error when selecting from the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-desc.html
--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving up. Three of the table properties that can be set using NDB_TABLE comments ...
https://dev.mysql.com/doc/refman/8.0/en/built-in-function-reference.html
8.0.18 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 ... The following table lists each built-in (native) function and operator and provides a short description of each ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-added-deprecated-removed.html
AutomaticThreadConfig: Use automatic thread configuration; overrides any settings for ThreadConfig and MaxNoOfExecutionThreads, and disables ClassicFragmentation. KeepAliveSendInterval: Time between keep-alive signals on links between data nodes, in ...Parameters Introduced in NDB 8.0 The following node configuration parameters have been added in NDB ...
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/insert.html
This is 0 for numeric types, the empty string ('') for string types, and the “zero” value for date and time types. In MySQL 8.0.19 and later, a row alias with one or more optional column aliases can be used with ON DUPLICATE KEY UPDATE to refer ...| TABLE table_name | VALUES row_constructor_list } [ON DUPLICATE KEY UPDATE assignment_list] value: {expr | DEFAULT} value_list: value [, value] ... INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-mta.html
Conversely, transactions performing inserts, updates and deletes on foreign key child tables (referencing) are not especially serialized with regard to one another. This means that the history size follows a sawtooth pattern over time, and therefore ...(The default is COMMIT_ORDER.) Writeset maintenance work in NDB is performed by the MySQL binary log injector thread as part of preparing and committing each epoch transaction to the binary ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-tables.html
For additional information about configuring event collection, see Section 29.3, “Performance Schema Startup Configuration”, and Section 29.4, “Performance Schema Runtime Configuration”. Consequently, there is no parsing at runtime and the ...prepared_statements_instances: Prepared statement instances and statistics The following sections describe the statement event ...
https://dev.mysql.com/doc/refman/8.0/en/alter-database.html
It backs up and restores a read-only database like any other, but enables the READ ONLY option at restore time if it was enabled at backup time. For any alter_option omitted from the statement, the database retains its current option value, with the ...alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' | 'N'} | READ ONLY [=] {DEFAULT | 0 | 1} } ALTER DATABASE enables you to change the overall characteristics of a ...