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-nodes-groups.html
This section discusses the manner in which NDB Cluster divides and duplicates data for storage. A number of concepts central to an understanding of this topic are discussed in the next few paragraphs. It is common for the terms “node” and ...An ...
https://dev.mysql.com/doc/refman/8.0/en/general-thread-states.html
Killed Someone has sent a KILL statement to the thread and it should abort next time it checks the kill flag. System lock The thread has called mysql_lock_tables() and the thread state has not been updated since. Updating The thread is searching for ... The following list describes thread State values that are associated with general query processing and not more specialized activities such as ...
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/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/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/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 ...
https://dev.mysql.com/doc/refman/8.0/en/load-data-local-security.html
(This is a change from previous versions of MySQL.) To cause the server to refuse or permit LOAD DATA LOCAL statements explicitly (regardless of how client programs and libraries are configured at build time or runtime), start mysqld with ...To ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-consumer-filtering.html
If YES, and the instrumentation is enabled and timed, CPU_TIME is measured. If you disable a consumer, the server does not spend time maintaining destinations for that consumer. For example, if you do not care about historical event information, ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-overview.html
Partition selection is also supported for the data modification statements DELETE, INSERT, REPLACE, UPDATE, and LOAD DATA, LOAD XML. For information on partitioning restrictions and feature limitations, see Section 26.6, “Restrictions and ... This ...