PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-fulltext-index.html
Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML operations on data contained within those columns. When a full-text index is dropped, the FTS_DOC_ID column that was created for the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-sbr-rbr.html
This is because the BLOB column value is logged, rather than the statement generating the data. SELECT, a CREATE statement is generated from the table definition and replicated using statement-based format, while the row insertions are replicated ...
https://dev.mysql.com/doc/refman/5.7/en/xa-statements.html
xid values are supplied by the client, or generated by the MySQL server. Values generated by one TM must be different from values generated by other TMs. To perform XA transactions in MySQL, use the following statements: XA {START|BEGIN} xid ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-select.html
SELECT, the destination table does not preserve information about whether columns in the selected-from table are generated columns. The SELECT part of the statement cannot assign values to generated columns in the destination table. You can create ...The ENGINE option is part of the CREATE TABLE statement, and should not be used following the SELECT; this would result in a syntax ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-key.html
KEY takes only a list of zero or more column names. Any columns used as the partitioning key must comprise part or all of the table's primary key, if the table has one. Where no column name is specified as the partitioning key, the table's primary ... Partitioning by key is similar to partitioning by hash, except that where hash partitioning employs a user-defined expression, the hashing function for key partitioning is supplied by the MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/collation-diagnostics.html
The MySQL server generates diagnostics when it finds problems while parsing the Index.xml file: Unknown tags are written to the error log. For example, the following message results if a collation definition contains a <aaa> tag: [Warning] Buffered ...In other cases, when a collation description is generally correct but contains some unknown tags, the collation is initialized and is available for ...
https://dev.mysql.com/doc/refman/5.7/en/docker-mysql-more-topics.html
To make MySQL Server generate an error log when either of the two conditions is true, use the --log-error option to configure the server to generate the error log at a specific location inside the container. MYSQL_RANDOM_ROOT_PASSWORD: When this ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndbd.html
ndbd generates a set of log files which are placed in the directory specified by DataDir in the config.ini configuration file. For example, ndb_2_error.log is the error log generated by the data node whose node ID is 2. The ndbd binary provides the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-ssl-rsa-setup.html
Another way to generate SSL and RSA files, for MySQL distributions compiled using OpenSSL, is to have the server generate them automatically. Important mysql_ssl_rsa_setup helps lower the barrier to using SSL by making it easier to generate the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-functions.html
(See Section 16.2.1, “Replication Formats”.) USER() and CURRENT_USER() are automatically replicated using row-based replication when using MIXED mode, and generate a warning in STATEMENT mode. SYSDATE() is automatically replicated using ...