PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/commit.html
You cannot use ROLLBACK to undo the effect; however, if an error occurs during statement execution, the statement is rolled back. Important Many APIs used for writing MySQL client applications (such as JDBC) provide their own methods for starting ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-provision-replica.html
If the sources in the multi-source replication topology have existing data, it can save time to provision the replica with the relevant data before starting replication. This statement transfers the GTIDs for the transactions executed on the source ...In a multi-source replication topology, copying the data directory cannot be used to provision the replica with data from all of the sources, and you might also want to replicate only specific databases from each ...
https://dev.mysql.com/doc/refman/5.7/en/condition-filtering.html
To the extent that the optimizer can use information about conditions on rows selected from one table and passed to the next, the more accurately it can compute row estimates and choose the best execution plan. The maximum value is 100, which means ... In join processing, prefix rows are those rows passed from one table in a join to the ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-restarting-group.html
In that situation, to re-create the group, it must be started by bootstrapping as if it was being started for the first time. For Group Replication, this includes both transactions that have been committed and applied, which are in the gtid_executed ... Group Replication is designed to ensure that the database service is continuously available, even if some of the servers that form the group are currently unable to participate in it due to planned maintenance or unplanned ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-buffer-page-table.html
ACCESS_TIME An abstract number used to judge the first access time of the page. This can be the name of a clustered index or a secondary index. The INNODB_BUFFER_PAGE table provides information about each page in the InnoDB buffer pool. For related ...
https://dev.mysql.com/doc/refman/5.7/en/creating-tables.html
Age changes as time passes, which means you'd have to update your records often. You want a table that contains a record for each of your pets. This can be called the pet table, and it should contain, as a bare minimum, each animal's name. Because ...
https://dev.mysql.com/doc/refman/5.7/en/sys-io-global-by-wait-by-latency.html
max_latency The maximum single wait time of timed occurrences of the I/O event. These views summarize global I/O consumers to display amount of I/O and time waiting for I/O, grouped by event. total_latency The total wait time of timed occurrences ...The io_global_by_wait_by_latency and x$io_global_by_wait_by_latency views have these columns: event_name The I/O event name, with the wait/io/file/ prefix ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-configuration-overview.html
All tables include the data type for the parameter, option, or variable, as well as its default, mimimum, and maximum values as applicable. Note 4294967039 often appears as a maximum value in these tables. Each of the node parameter tables lists the ...
https://dev.mysql.com/doc/refman/5.7/en/ldml-rules.html
Rules that specify differences at secondary or higher sort levels are recognized (and thus can be included in collation definitions) but are treated as equality at the primary level. Either of the following rules resets subsequent shift rules to be ...This is a subset of the syntax described in the LDML specification available at http://www.unicode.org/reports/tr35/, which should be consulted for further ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-online-add-node-basics.html
Execute one or more CREATE NODEGROUP commands in the NDB Cluster management client to create the new node group or node groups to which the new data nodes belong. Note This needs to be done only for tables already existing at the time the new node ... In this section, we list the basic steps required to add new data nodes to an NDB ...