PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/audit-log-file-formats.html
This is the same as the value returned by the CONNECTION_ID() function within the session. Example: <DB>test</DB> For connect events, this element indicates the default database; the element is empty if there is no default database. This is the same ... The MySQL server calls the audit log plugin to write an audit record to its log file whenever an auditable event ...
https://dev.mysql.com/doc/refman/5.7/en/stored-programs-logging.html
This information is stored in the form of “events” that describe the modifications. This can result in different data on source and replica, or cause restored data to differ from the original data. This section describes how MySQL handles binary ... The binary log contains information about SQL statements that modify database ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations.html
This section discusses current restrictions and limitations on MySQL partitioning support. However, the result must be an integer value or NULL (except in the case of [LINEAR] KEY partitioning, as discussed elsewhere in this chapter; see Section ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-partitions-table.html
Each row in this table corresponds to an individual partition or subpartition of a partitioned table. The indexing can change as partitions are added, dropped, and reorganized; the number shown is this column reflects the current order, taking into ...The PARTITIONS table has these columns: TABLE_CATALOG The name of the catalog to which the table ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-lifecycle.html
This client transaction is assigned a GTID composed of the source's UUID and the smallest nonzero transaction sequence number not yet used on this server. This GTID set contains a representation of the set of all committed GTID transactions, and it ... The life cycle of a GTID consists of the following steps: A transaction is executed and committed on the replication source ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filter-definitions.html
Filter definitions have this form, where actions indicates how filtering takes place: { "filter": actions } The following discussion describes permitted constructs in filter definitions. The preceding definition can be written like this: { "filter": ...For information about using JSON data in MySQL, see Section 11.5, “The JSON Data ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-partition-operations.html
This clause always begins with PARTITION BY, and follows the same syntax and other rules as apply to the partition_options clause for CREATE TABLE (for more detailed information, see Section 13.1.18, “CREATE TABLE Statement”), and can also be ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-auto-increment-handling.html
This section describes the AUTO_INCREMENT lock modes, usage implications of different AUTO_INCREMENT lock mode settings, and how InnoDB initializes the AUTO_INCREMENT counter. InnoDB AUTO_INCREMENT Lock Modes InnoDB AUTO_INCREMENT Lock Mode Usage ...
https://dev.mysql.com/doc/refman/5.7/en/load-xml.html
By default, the <row> element is considered to be the equivalent of a database table row; this can be changed using the ROWS IDENTIFIED BY clause. The name of a user variable used for this purpose must match the name of a field from the XML file, ...
https://dev.mysql.com/doc/refman/5.7/en/help.html
HELP 'search_string' The HELP statement returns online information from the MySQL Reference Manual. Example: HELP 'fake' Yields: Nothing found Please try to run 'help contents' for a list of all accessible topics Result set containing a single row ...The HELP statement searches the help tables for the given search string and displays the result of the ...Its proper operation requires that the help tables in the ...