PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/optimize-character.html
For character and string columns, follow these guidelines: Use binary collation order for fast comparison and sort operations, when you do not need language-specific collation features. You can use the BINARY operator to use binary collation within ...
https://dev.mysql.com/doc/refman/9.7/en/packet-too-large.html
A communication packet is a single SQL statement sent to the MySQL server, a single row that is sent to the client, or a binary log event sent from a replication source server to a replica. The largest possible packet that can be transmitted to or ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-limitations.html
This section discusses current restrictions and limitations on MySQL partitioning support. The following constructs are not permitted in partitioning expressions: Stored procedures, stored functions, loadable functions, or plugins. For a list of ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-variables-metadata-table.html
The variables_metadata table shows, for each server system variable, its name, scope, type, range of values (where applicable), and description. VARIABLE_SCOPE The variable's scope; this is one of the values listed here: GLOBAL The variable is ...
https://dev.mysql.com/doc/refman/9.7/en/replication-options-binary-log.html
Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which ...
https://dev.mysql.com/doc/refman/9.7/en/replication-sbr-rbr.html
For most users, the mixed replication format should provide the best combination of data integrity and performance. If, however, you want to take advantage of the features specific to the statement-based or row-based replication format when ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-api-using.html
This section discusses the use of the API in executing and in obtaining and processing results from both simple SQL statements and prepared statements. SQL execution in JavaScript is available in stored procedures only, and not in stored functions.
https://dev.mysql.com/doc/refman/9.7/en/static-format.html
It is used when the table contains no variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT). Of the three MyISAM storage formats, static format is the simplest and most secure (least subject to corruption). It is also the fastest of the ...
https://dev.mysql.com/doc/refman/9.7/en/kerberos-pluggable-authentication.html
Note Kerberos pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition supports an authentication method that enables users to authenticate to MySQL Server using Kerberos, ...
https://dev.mysql.com/doc/refman/9.7/en/manual-info.html
This is the Reference Manual for the MySQL Database System, version 9.7, through release 9.7.0. Differences between minor versions of MySQL 9.7 are noted in the present text with reference to release numbers (9.7.x). This manual is not intended for ...