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/where-optimization.html
HAVING is merged with WHERE if you do not use GROUP BY or aggregate functions (COUNT(), MIN(), and so on). If all columns in ORDER BY and GROUP BY clauses come from the same table, that table is preferred first when joining. If there is an ORDER BY ... This section discusses optimizations that can be made for processing WHERE ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filter-definitions.html
For information about using JSON data in MySQL, see Section 11.5, “The JSON Data Type”. Filter definitions have this form, where actions indicates how filtering takes place: { "filter": actions } The following discussion describes permitted ...
https://dev.mysql.com/doc/refman/5.7/en/update.html
UPDATE is a DML statement that modifies rows in a table. Single-table syntax: UPDATE [LOW_PRIORITY] [IGNORE] table_reference SET assignment_list [WHERE where_condition] [ORDER BY ...] [LIMIT row_count] value: {expr | DEFAULT} assignment: col_name = ...
https://dev.mysql.com/doc/refman/5.7/en/create-event.html
CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] DO event_body; schedule: { AT timestamp [+ INTERVAL interval] ... The event does ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-threads-table.html
The threads table contains a row for each server thread. Each row contains information about a thread and indicates whether monitoring and historical event logging are enabled for it: mysql> SELECT * FROM performance_schema.threads\G ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-usage.html
An administrative or management application that communicates with the servers and organizes them into high-availability groups. Groups serve different purposes, and servers within each group may have different assignments. Assignment of a server ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-overview.html
See the documentation for the DataMemory data node configuration parameter, as well as Section 21.2.2, “NDB Cluster Nodes, Node Groups, Fragment Replicas, and Partitions”, for more information. This section provides a conceptual overview of ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-config-example.html
To support NDB Cluster, you must to update my.cnf as shown in the following example. You may also specify these parameters on the command line when invoking the executables. Note The options shown here should not be confused with those that are ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-timing.html
Events are collected by means of instrumentation added to the server source code. Instruments time events, which is how the Performance Schema provides an idea of how long events take. It is also possible to configure instruments not to collect ...
https://dev.mysql.com/doc/refman/5.7/en/sha256-pluggable-authentication.html
MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: sha256_password: Implements basic SHA-256 authentication. caching_sha2_password: Implements SHA-256 authentication (like sha256_password), but uses ...