PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html
Starting with MySQL 8.0.17, queries using JSON_CONTAINS() on InnoDB tables can be optimized using multi-valued indexes; see Multi-Valued Indexes, for more information. row *************************** id: 1 select_type: SIMPLE table: jemp partitions: ... The functions in this section perform search or comparison operations on JSON values to extract data from them, report whether data exists at a location within them, or report the path to data within ...
https://dev.mysql.com/doc/refman/8.0/en/stored-programs-logging.html
Triggers can update tables, so error messages similar to those for stored functions occur with CREATE TRIGGER if you do not have the required privileges. The use of NAME_CONST() can result in a problem for CREATE TABLE ... If a stored program that ... The binary log contains information about SQL statements that modify database ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-optimization.html
To see whether a given Performance Schema table has indexes and what they are, use SHOW INDEX or SHOW CREATE TABLE: mysql> SHOW INDEX FROM performance_schema.accounts\G *************************** 1. row *************************** Table: accounts ... Applications that monitor databases may make frequent use of Performance Schema ...For example, include a WHERE clause that ...
https://dev.mysql.com/doc/refman/8.0/en/condition-filtering.html
In join processing, prefix rows are those rows passed from one table in a join to the next. In general, the optimizer attempts to put tables with low prefix counts early in the join order to keep the number of row combinations from increasing ...
https://dev.mysql.com/doc/refman/8.0/en/intersect.html
query_expression_body INTERSECT [ALL | DISTINCT] query_expression_body [INTERSECT [ALL | DISTINCT] query_expression_body] [...] query_expression_body: See Section 15.2.14, “Set Operations with UNION, INTERSECT, and EXCEPT” INTERSECT limits the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-consumer-configurations.html
The consumer settings in the setup_consumers table form a hierarchy from higher levels to lower. The setup_consumers table contains the following hierarchy of values: global_instrumentation thread_instrumentation events_waits_current ...The ...
https://dev.mysql.com/doc/refman/8.0/en/change-replication-source-to.html
This option prevents the replication applier from taking actions such as creating temporary tables and executing LOAD DATA INFILE requests, which increases the security of the channel. OFF: The replica sets sql_require_primary_key = OFF; no ...If ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-gtids.html
Only statements that can be logged using GTID safe statements can be logged when enforce_gtid_consistency is set to ON, so the operations listed here cannot be used with this option: CREATE TEMPORARY TABLE or DROP TEMPORARY TABLE statements inside ...There is an exception that nontransactional DML is allowed in the same transaction or in the same statement as transactional DML, if all nontransactional tables are ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-standard-monitor.html
The contents include the statement that failed as well as information about the constraint that failed and the referenced and referencing tables. The Lock Monitor is the same as the Standard Monitor except that it includes additional lock ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-porting-memcached.html
You might create additional secondary indexes on tables that are frequently used to generate reports using SQL. If you store several different classes of information using memcached, consider setting up a separate InnoDB table for each type of data.