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/information-schema-optimizer-trace-table.html
The OPTIMIZER_TRACE table provides information produced by the optimizer tracing capability for traced statements. The OPTIMIZER_TRACE table has these columns: QUERY The text of the traced statement. MISSING_BYTES_BEYOND_MAX_MEM_SIZE Each ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-init-startup-configuration.html
The first decisions to make about InnoDB configuration involve the configuration of data files, log files, page size, and memory buffers, which should be configured before initializing InnoDB. Modifying the configuration after InnoDB is initialized ...
https://dev.mysql.com/doc/refman/5.7/en/replication-channels.html
In MySQL multi-source replication, a replica opens multiple replication channels, one for each replication source server. The replication channels represent the path of transactions flowing from a source to the replica. Each replication channel has ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-reference.html
The following two sections provide basic information about the MySQL command-line options and system variables applicable to replication and the binary log. Replication Options and Variables The command-line options and system variables in the ...
https://dev.mysql.com/doc/refman/5.7/en/account-activity-auditing.html
Applications can use the following guidelines to perform SQL-based auditing that ties database activity to MySQL accounts. When a client connects successfully, the server authenticates the client to a particular row in this table. The User and Host ...
https://dev.mysql.com/doc/refman/5.7/en/added-deprecated-removed.html
Options and Variables Introduced in MySQL 5.7 Options and Variables Deprecated in MySQL 5.7 Options and Variables Removed in MySQL 5.7 This section lists server variables, status variables, and options that were added for the first time, have been ...
https://dev.mysql.com/doc/refman/5.7/en/alter-tablespace.html
ALTER TABLESPACE tablespace_name {ADD | DROP} DATAFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] engine_name This statement is used either to add a new data file, or to drop a data file from a tablespace. The ADD DATAFILE variant ...
https://dev.mysql.com/doc/refman/5.7/en/caching-sha2-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 ...
https://dev.mysql.com/doc/refman/5.7/en/charset-mysql.html
To display the available character sets, use the INFORMATION_SCHEMA CHARACTER_SETS table or the SHOW CHARACTER SET statement. For more complete information, see Section 10.10, “Supported Character Sets and Collations”. mysql> SHOW CHARACTER SET; ...
https://dev.mysql.com/doc/refman/5.7/en/compressed-format.html
Compressed storage format is a read-only format that is generated with the myisampack tool. Compressed tables have the following characteristics: Compressed tables take very little disk space. This minimizes disk usage, which is helpful when using ...