PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/show-plugins.html
Type The type of plugin, such as STORAGE ENGINE, INFORMATION_SCHEMA, or AUTHENTICATION. For plugins installed with INSTALL PLUGIN, the Name and Library values are also registered in the mysql.plugin system table. For information about plugin data ...
https://dev.mysql.com/doc/refman/5.7/en/source-thread-states.html
The following list shows the most common states you may see in the State column for the Binlog Dump thread of the replication source. Master has sent all binlog to slave; waiting for more updates The thread has read all remaining updates from the ...If you see no Binlog Dump threads on a source, this means that replication is not running; that is, that no replicas are currently ...
https://dev.mysql.com/doc/refman/5.7/en/sql-compound-statements.html
These objects are defined in terms of SQL code that is stored on the server for later invocation (see Chapter 23, Stored Objects). A compound statement is a block that can contain other blocks; declarations for variables, condition handlers, and ...
https://dev.mysql.com/doc/refman/5.7/en/storage-engines-other.html
For further information, documentation, installation guides, bug reporting or for any help or assistance with these engines, please contact the developer of the engine directly. For more information on developing a customer storage engine that can ... Other storage engines may be available from third parties and community members that have used the Custom Storage Engine ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-optimization.html
Note A limitation on UPDATE and DELETE statements that use a subquery to modify a single table is that the optimizer does not use semijoin or materialization subquery optimizations. As a workaround, try rewriting them as multiple-table UPDATE and ...
https://dev.mysql.com/doc/refman/5.7/en/sys-io-global-by-file-by-bytes.html
total The total number of bytes read and written for the file. These views summarize global I/O consumers to display amount of I/O, grouped by file. By default, rows are sorted by descending total I/O (bytes read and written). The ...
https://dev.mysql.com/doc/refman/5.7/en/working-with-null.html
The NULL value can be surprising until you get used to it. Conceptually, NULL means “a missing unknown value” and it is treated somewhat differently from other values. In MySQL, 0 or NULL means false and anything else means true. This special ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-formats.html
The logging format can also be set or limited by the storage engine being used. The server uses several logging formats to record information in the binary log. The exact format employed depends on the version of MySQL being used. There are three ...In row-based logging, the source writes events to the binary log that indicate how individual table rows are ...
https://dev.mysql.com/doc/refman/5.7/en/charset-compatibility.html
For MaxDB compatibility these two statements are the same: CREATE TABLE t1 (f1 CHAR(N) UNICODE); CREATE TABLE t1 (f1 CHAR(N) CHARACTER SET ucs2); .
https://dev.mysql.com/doc/refman/5.7/en/data-masking-elements.html
A set of loadable functions provides an SQL-level API for performing masking and de-identification operations. MySQL Enterprise Data Masking and De-Identification is based on a plugin library that implements these elements: A server-side plugin ...