PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.3Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/get-diagnostics.html
Briefly, it contains two kinds of information: Statement information, such as the number of conditions that occurred or the affected-rows count. For a statement that produces three conditions, the diagnostics area contains statement and condition ...
https://dev.mysql.com/doc/refman/8.0/en/handler.html
READ syntax fetches a row where the index specified satisfies the given values and the WHERE condition is met. READ syntax fetches a row from the table in index order that matches the WHERE condition. READ syntax fetches a row from the table in ...
https://dev.mysql.com/doc/refman/8.0/en/locale-support.html
The locale indicated by the lc_time_names system variable controls the language used to display day and month names and abbreviations. This variable affects the output from the DATE_FORMAT(), DAYNAME(), and MONTHNAME() functions. The lc_time_names ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-cluster-locks.html
If a transaction holds an exclusive lock on a given row, all other locks on that row have the same transaction ID. When the detail column contains a * (asterisk character), this means that this lock is the first holding lock in the affected row's ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-server-locks.html
If a transaction has an exclusive lock on a given row, all other locks on that row have the same transaction ID. The detail column indicates whether this lock is the first holding lock in the affected row's lock queue, in which case it contains a * ... The server_locks table is similar in structure to the cluster_locks table, and provides a subset of the information found in the latter table, but which is specific to the SQL node (MySQL server) where it ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlimport.html
--replace, -r Command-Line Format --replace The --replace and --ignore options control handling of input rows that duplicate existing rows on unique key values. If you specify --replace, new rows replace existing rows that have the same unique key ... The mysqlimport client provides a command-line interface to the LOAD DATA SQL ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-hints.html
Consider this statement: SELECT /*+ BNL(t2) */ FROM t1, t2; If the optimizer chooses to process t1 first, it applies a Block Nested-Loop join to t2 by buffering the rows from t1 before starting to read from t2. ORDER_INDEX, NO_ORDER_INDEX: Cause ...
https://dev.mysql.com/doc/refman/8.0/en/outer-join-optimization.html
The LEFT JOIN condition is used to decide how to retrieve rows from table B. If there is a row in A that matches the WHERE clause, but there is no row in B that matches the ON condition, an extra B row is generated with all columns set to NULL. For ...MySQL implements an A LEFT JOIN B join_specification as follows: Table B is set to depend on table A and all tables on which A ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations-partitioning-keys-unique-keys.html
This section discusses the relationship of partitioning keys with primary keys and unique keys. The rule governing this relationship can be expressed as follows: All columns used in the partitioning expression for a partitioned table must be part ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-atom-molecule-events.html
For a table I/O event, there are usually two rows in events_waits_current, not one. For example, a row fetch might result in rows like this: Row# EVENT_NAME TIMER_START TIMER_END ---- ---------- ----------- --------- 1 wait/io/file/myisam/dfile ...