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/ssl-libraries.html
For example, this statement returns a row if OpenSSL was used and an empty result if yaSSL was used: SHOW STATUS LIKE 'Rsa_public_key'; . MySQL can be compiled using OpenSSL or yaSSL, both of which enable encrypted connections based on the OpenSSL ...
https://dev.mysql.com/doc/refman/5.7/en/starting-server-troubleshooting.html
This section provides troubleshooting suggestions for problems starting the server. For additional suggestions for Windows systems, see Section 2.3.5, “Troubleshooting a Microsoft Windows MySQL Server Installation”. If you have problems ...
https://dev.mysql.com/doc/refman/5.7/en/stored-programs-defining.html
The following example shows how to do this for the dorepeat() procedure just shown. Each stored program contains a body that consists of an SQL statement. This statement may be a compound statement made up of several statements separated by ...
https://dev.mysql.com/doc/refman/5.7/en/string-collating.html
The existing character sets provide the best documentation and examples to show how these functions are implemented. For a simple character set named MYSET, sorting rules are specified in the MYSET.xml configuration file using <map> array elements ...
https://dev.mysql.com/doc/refman/5.7/en/structured-system-variables.html
The variable is not interpreted as a compound name, but as a simple string for a LIKE pattern-matching operation: mysql> SHOW GLOBAL VARIABLES LIKE 'hot_cache.key_buffer_size'; This is the exception to being able to use structured variable names ...
https://dev.mysql.com/doc/refman/5.7/en/subqueries.html
All subquery forms and operations that the SQL standard requires are supported, as well as a few features that are MySQL-specific. Here is an example of a subquery: SELECT * FROM t1 WHERE column1 = (SELECT column1 FROM t2); In this example, SELECT * ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-materialization.html
For extended EXPLAIN output, the text displayed by a following SHOW WARNINGS includes materialize and materialized-subquery. The optimizer uses materialization to enable more efficient subquery processing. Materialization speeds up query execution ...
https://dev.mysql.com/doc/refman/5.7/en/symbolic-links-to-tables.html
For files used by tables for other storage engines, you may get strange problems if you try to use symbolic links. For InnoDB tables, use the alternative technique explained in Section 14.6.1.2, “Creating Tables Externally” instead. Do not ...
https://dev.mysql.com/doc/refman/5.7/en/symbolic-links.html
To determine the location of your data directory, use this statement: SHOW VARIABLES LIKE 'datadir'; . You can move databases or tables from the database directory to other locations and replace them with symbolic links to the new locations. You ...
https://dev.mysql.com/doc/refman/5.7/en/sys-metrics.html
This view summarizes MySQL server metrics to show variable names, values, types, and whether they are enabled. The metric type determines the source from which the name is taken: For global status variables: The VARIABLE_NAME column of the ...