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/option-files.html
The rules for escape sequences in option files differ slightly from the rules for escape sequences in string literals in SQL statements. Most MySQL programs can read startup options from option files (sometimes called configuration files). Option ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-storage-layout.html
Use the VARCHAR data type instead of CHAR to store variable-length strings or for columns with many NULL values. A CHAR(N) column always takes N characters to store data, even if the string is shorter or its value is NULL. Once your data reaches a ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-tuning.html
When to Use Compression In general, compression works best on tables that include a reasonable number of character string columns and where the data is read far more often than it is written. Recall that compression works by identifying repeated ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-tips.html
Suppose that an indexed string column c1 is compared to a numeric value using WHERE c1 = 2222. For such comparisons, the string value is converted to a number and the operands are compared numerically (see Section 12.3, “Type Conversion in ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-installation.html
MySQL Enterprise Encryption functions are located in a loadable function library file installed in the plugin directory (the directory named by the plugin_dir system variable). The function library base name is openssl_udf and the suffix is ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-config-example.html
You may also use a separate [mysql_cluster] section in the cluster my.cnf file for settings to be read and used by all executables: # cluster-specific settings [mysql_cluster] ndb-connectstring=ndb_mgmd.mysql.com:1186 For additional NDB variables ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-general-info.html
The version string displayed by NDB Cluster programs uses this format: mysql-mysql_server_version-ndb-ndb_engine_version mysql_server_version represents the version of the MySQL Server on which the NDB Cluster release is based. For example, the full ... MySQL NDB Cluster uses the MySQL server with the NDB storage ...
https://dev.mysql.com/doc/refman/5.7/en/begin-end.html
Use of multiple statements requires that a client is able to send statement strings containing the ; statement delimiter. END syntax is used for writing compound statements, which can appear within stored programs (stored procedures and functions, ...
https://dev.mysql.com/doc/refman/5.7/en/connection-access.html
The client supplies the credentials specified in the row (for example, a password), as indicated by the authentication_string column. The authentication method implemented by the plugin that authenticates the client may or may not use the password ... When you attempt to connect to a MySQL server, the server accepts or rejects the connection based on these conditions: Your identity and whether you can verify it by supplying the proper ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-status-variables.html
If the group is operating in multi-primary mode, shows an empty string. MySQL 5.7 supports one status variable providing information about Group Replication. This variable is described here: group_replication_primary_member Shows the primary ...