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/xml-functions.html
Some basic information about XPath syntax and usage is provided later in this section; however, an in-depth discussion of these topics is beyond the scope of this manual, and you should refer to the XML Path Language (XPath) 1.0 standard for ...Note ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-mixed.html
Like all other unsafe statements, this generates a warning if binlog_format = STATEMENT. For example, this occurs when the statement creating a view uses the UUID() function. This is true whether or not any temporary tables are actually logged. The ... When running in MIXED logging format, the server automatically switches from statement-based to row-based logging under the following conditions: When a DML statement updates an NDBCLUSTER ...
https://dev.mysql.com/doc/refman/5.7/en/bnl-bka-optimization.html
Suppose that join buffer B1 is employed to join tables t1 and t2 and the result of this operation is joined with table t3 using join buffer B2: A regular join buffer contains columns from each join operand. This provides a savings in buffer space ...
https://dev.mysql.com/doc/refman/5.7/en/charset-metadata.html
This is also true of the contents of tables in INFORMATION_SCHEMA because those tables by definition contain information about database objects. This does not cause any disruption if you never use accented or non-Latin characters. It is more ...
https://dev.mysql.com/doc/refman/5.7/en/commit.html
This means that, when not otherwise inside a transaction, each statement is atomic, as if it were surrounded by START TRANSACTION and COMMIT. Because of this, SHOW PROCESSLIST displays Rolling back in the State column for the session, not only for ...SET autocommit disables or enables the default autocommit mode for the current ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-files.html
The relevant factors in the expression are: info_length is space needed for “screens.” This is related to MySQL's Unireg heritage. In this context, “int” does not mean “integer.” It means “interval,” a term that refers collectively ... MySQL represents each table by an .frm table format (definition) file in the database ...
https://dev.mysql.com/doc/refman/5.7/en/derived-table-optimization.html
The outer query has this derived table or view reference as the only source in the FROM clause. This improves performance because delaying materialization may result in not having to do it at all. In this case, the query is not executed (because it ...The optimizer handles derived tables and view references the same way: It avoids unnecessary materialization whenever possible, which enables pushing down conditions from the outer query to derived tables and produces more efficient execution ...
https://dev.mysql.com/doc/refman/5.7/en/events-overview.html
Conceptually, this is similar to the idea of the Unix crontab (also known as a “cron job”) or the Windows Task Scheduler. Scheduled tasks of this type are also sometimes known as “temporal triggers”, implying that these are objects that are ... MySQL Events are tasks that run according to a ...
https://dev.mysql.com/doc/refman/5.7/en/generated-column-index-optimizations.html
This occurs if the WHERE, ORDER BY, or GROUP BY clause refers to an expression that matches the definition of some indexed generated column. You can see this using EXPLAIN: mysql> EXPLAIN SELECT * FROM t1 WHERE f1 + 1 > 9\G ...For example: CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-message-compression.html
This limit is lower than the maximum possible value for the group_replication_compression_threshold system variable, which is matched to the maximum message size accepted by XCom. The LZ4 maximum input size is therefore a practical limit for message ... For messages sent between online group members, Group Replication enables message compression by ...