PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/partitioning-pruning.html
Important Invalid DATE and DATETIME values referenced in the WHERE condition of a statement against a partitioned table are treated as NULL. By limiting the search, it is possible to expend much less time and effort in finding matching rows than by ...When the optimizer can make use of partition pruning in performing this query, execution of the query can be an order of magnitude faster than the same query against a nonpartitioned table containing the same column definitions and ...
https://dev.mysql.com/doc/refman/8.0/en/get-diagnostics.html
The keyword STACKED means to retrieve information from the second diagnostics area, which is available only if the current context is a condition handler. The GET DIAGNOSTICS statement is typically used in a handler within a stored program. It is a ... GET [CURRENT | STACKED] DIAGNOSTICS { statement_information_item [, statement_information_item] ...
https://dev.mysql.com/doc/refman/8.0/en/known-issues.html
The default value of max_sort_length is 1024 and can be changed at server startup time or at runtime. For information about platform-specific issues, see the installation and debugging instructions in Section 2.1, “General Installation ... This ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-mgm-definition.html
[mgm] and [mgm default] are older aliases for these, supported for backward compatibility. All parameters in the following list are optional and assume their default values if omitted. Id Version (or later) NDB 8.0.13 Type or units unsigned Default ... The [ndb_mgmd] section is used to configure the behavior of the management ...
https://dev.mysql.com/doc/refman/8.0/en/subquery-optimization-with-exists.html
Most optimizations cannot deal with predicates that may be turned on and off at query execution time, so they assume any trigcond(X) to be an unknown function and ignore it. WHERE subquery_where) MySQL evaluates queries “from outside to inside.” ... Certain optimizations are applicable to comparisons that use the IN (or =ANY) operator to test subquery ...
https://dev.mysql.com/doc/refman/8.0/en/windows-installation.html
To accommodate the RESTART statement, the MySQL server forks when run as a service or standalone, to enable a monitor process to supervise the server process. This is due to the fingerprinting mechanism used by the virus-scanning software, and the ...MySQL Installer Method The simplest and recommended method is to download MySQL Installer (for Windows) and let it install and configure a specific version of MySQL Server as follows: Download MySQL Installer from https://dev.mysql.com/downloads/installer/ and execute ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-quick-start.html
The timer columns show when the event started and stopped and how long it took. If an event is still in progress, the TIMER_END and TIMER_WAIT values are NULL. For information about timers and event time collection, see Section 29.4.1, ...For ...
https://dev.mysql.com/doc/refman/8.0/en/replication-sbr-rbr.html
Not all statements which modify data (such as INSERT DELETE, UPDATE, and REPLACE statements) can be replicated using statement-based replication. DELETE and UPDATE statements that use a LIMIT clause without an ORDER BY are nondeterministic. For ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-filtering.html
The filtering functions just described affect audit filtering immediately and update the audit log tables in the mysql system database that store filters and user accounts (see Audit Log Tables). It is also possible to modify the audit log tables ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-ndb-comment-options.html
This may be suitable for short-lived data which is frequently updated, and where the loss of all data in the unlikely event of a total cluster failure is acceptable. Table-level options for controlling read from any replica and partition balance can ... NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB ...