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/declare-handler.html
This is true even if the condition occurs in an inner block. This is relevant within the context of cursors and is used to control what happens when a cursor reaches the end of a data set. To detect this condition, you can set up a handler for it or ...statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ...
https://dev.mysql.com/doc/refman/5.7/en/drop-tablespace.html
DROP TABLESPACE tablespace_name [ENGINE [=] engine_name] This statement drops a tablespace that was previously created using CREATE TABLESPACE. DROP DATABASE has no effect in this regard, even if the operation drops all tables belonging to the ...
https://dev.mysql.com/doc/refman/5.7/en/error-log-syslog.html
To do so, use these system variables: log_syslog: Enable this variable to send the error log to the system log. log_syslog_tag: This variable defines a tag to add to the server identifier (mysqld) in syslog messages. For syslog output, a tag can be ... It is possible to have mysqld write the error log to the system log (the Event Log on Windows, and syslog on Unix and Unix-like ...
https://dev.mysql.com/doc/refman/5.7/en/external-locking.html
In this case, if the server tries to update a table that myisamchk is using, the server waits for myisamchk to finish before it continues. (See Section 8.12.1, “System Factors”.) To avoid this requirement, use the CHECK TABLE and REPAIR TABLE ...
https://dev.mysql.com/doc/refman/5.7/en/function-optimization.html
This might be zero, one, or multiple rows, depending on the id column values and the values in the RAND() sequence. This UPDATE statement uses a nondeterministic function to select rows to be modified: UPDATE t SET col_a = some_expr WHERE id = ...A ...
https://dev.mysql.com/doc/refman/5.7/en/general-tablespaces.html
In this example, the my_tablespace directory is at the same level as the data directory: mysql> CREATE TABLESPACE `ts1` ADD DATAFILE '../my_tablespace/ts1.ibd' Engine=InnoDB; Note The ENGINE = InnoDB clause must be defined as part of the CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/getting-information.html
What if you forget the name of a database or table, or what the structure of a given table is (for example, what its columns are called)? MySQL addresses this problem through several statements that provide information about the databases and ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-flow-control.html
This approach works well if the total number of writes to the group does not exceed the write capacity of any member in the group. The information is shared every second, and this period is sufficient to address both concerns. This means that every ... Group Replication ensures that a transaction only commits after a majority of the members in a group have received it and agreed on the relative order between all transactions that were sent ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-single-primary-mode.html
In this mode the group has a single-primary server that is set to read-write mode. This avoids possible concurrency issues between old transactions from the old primary and the new ones being executed on this member. All the other members in the ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-summary.html
For applying and externalizing the certified transactions, Group Replication permits servers to deviate from the agreed order of the transactions if this does not break consistency and validity. This is permitted when the certification process has ... Group Replication is a technique that can be used to implement fault-tolerant ...