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-cluster-config-send-buffers.html
This parameter is used in the config.ini file [tcp] section, and denotes the amount of unsent data (in bytes) that must be present in the send buffer before the connection is considered overloaded. This parameter can be set for all types of NDB ...
https://dev.mysql.com/doc/refman/8.0/en/index-btree-hash.html
Understanding the B-tree and hash data structures can help predict how different queries perform on different storage engines that use these data structures in their indexes, particularly for the MEMORY storage engine that lets you choose B-tree or ...B-Tree Index Characteristics Hash Index Characteristics B-Tree Index Characteristics A B-tree index can be used for column comparisons in expressions that use the =, >, >=, <, <=, or BETWEEN ...
https://dev.mysql.com/doc/refman/8.0/en/constraints.html
We must handle the case when you have inserted or updated a lot of rows in a nontransactional table for which changes cannot be rolled back when an error occurs. Several SQL mode options are available to provide greater control over handling of bad ...The basic philosophy is that MySQL Server tries to produce an error for anything that it can detect while parsing a statement to be executed, and tries to recover from any errors that occur while executing the ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-examples.html
If it is important to have the same order on the source and replica, the rows must be ordered before assigning an AUTO_INCREMENT number. For NDB tables, it is also possible to change the storage type used for a table or column. row ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-literals.html
For more information about the temporal data types, such as the range of permitted values, see Section 13.2, “Date and Time Data Types”. The value inserted must not have a zero for the month part, the day part, or both parts. Standard SQL and ...For example, in contexts where MySQL expects a date, it interprets any of '2015-07-21', '20150721', and 20150721 as a ...
https://dev.mysql.com/doc/refman/8.0/en/document-store-concepts.html
JSON Document Collection CRUD Operations JSON Document A JSON document is a data structure composed of key-value pairs and is the fundamental structure for using MySQL as document store. Mogae", "GovernmentForm": "Republic" }, "demographics": { ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-probes-and-statistics.html
It then propagates that information to the group periodically to share that data with the other members. The monitoring period must be high enough to allow the other members to decide on the current write requests, but low enough that it has minimal ... The monitoring mechanism works by having each member deploying a set of probes to collect information about its work queues and ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-db-options.html
This means that you must select the default database explicitly with a USE statement in order for a DDL statement to be applied. The database that is checked for a match depends on the binary log format of the statement that is being handled. If the ... When evaluating replication options, the replica begins by checking to see whether there are any --replicate-do-db or --replicate-ignore-db options that ...
https://dev.mysql.com/doc/refman/8.0/en/replication-semisync-interface.html
rpl_semi_sync_source_wait_for_replica_count or rpl_semi_sync_master_wait_for_slave_count Controls the number of replica acknowledgments the source must receive per transaction before returning to the session. If something goes wrong such that the ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-plugins-table.html
This is the name used to refer to the plugin file in statements such as INSTALL PLUGIN and UNINSTALL PLUGIN. This file is located in the directory named by the plugin_dir system variable. For information about plugin data structures that form the ...