PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/innodb-information-schema-metrics-table.html
The INNODB_METRICS table provides information about InnoDB performance and resource-related counters. SET GLOBAL innodb_monitor_disable = [counter-name|module_name|pattern|all]; innodb_monitor_reset: Resets counter values to zero. SET GLOBAL ...
https://dev.mysql.com/doc/refman/9.7/en/bit-functions.html
Table 14.17 Bit Functions and Operators Name Description & Bitwise AND >> Right shift << Left shift ^ Bitwise XOR BIT_COUNT() Return the number of bits that are set | Bitwise OR ~ Bitwise inversion The following list describes available bit ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-files-table.html
The FILES table provides information about the files in which MySQL tablespace data is stored. In NDB Cluster, this table also provides information about the files in which NDB Cluster Disk Data tables are stored. For additional information ...
https://dev.mysql.com/doc/refman/9.7/en/json-modification-functions.html
The functions in this section modify JSON values and return the result. JSON_ARRAY_APPEND(json_doc, path, val[, path, val] ...) Appends values to the end of the indicated arrays within a JSON document and returns the result. An error occurs if the ...
https://dev.mysql.com/doc/refman/9.7/en/window-functions-frames.html
The definition of a window used with a window function can include a frame clause. A frame is a subset of the current partition and the frame clause specifies how to define the subset. Frames are determined with respect to the current row, which ...
https://dev.mysql.com/doc/refman/9.7/en/create-table-foreign-keys.html
MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent. A foreign key relationship involves a parent table that holds the initial column ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-replication-conflict-resolution.html
Requirements Source Column Control Conflict Resolution Control Conflict Resolution Functions Conflict Resolution Exceptions Table Conflict Detection Status Variables Examples When using a replication setup involving multiple sources (including ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-command-options.html
mysql supports the following options, which can be specified on the command line or in the [mysql] and [client] groups of an option file. For information about option files used by MySQL programs, see Section 6.2.2.2, “Using Option Files”.
https://dev.mysql.com/doc/refman/9.7/en/srjs-data-arguments.html
Most MySQL data types are supported for MLE stored program input and output arguments, as well as for return data types. The data types are listed here: Integer: All variants and aliases of MySQL integer data types are supported, including TINYINT, ...
https://dev.mysql.com/doc/refman/9.7/en/logical-operators.html
Table 14.5 Logical Operators Name Description AND, && Logical AND NOT, ! Negates value OR, || Logical OR XOR Logical XOR In SQL, all logical operators evaluate to TRUE, FALSE, or NULL (UNKNOWN). In MySQL, these are implemented as 1 (TRUE), 0 ...