PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/comp-err.html
--charset=dir_name, -C dir_name Command-Line Format --charset Type String Default Value ../share/charsets The character set directory. comp_err creates the errmsg.sys file that is used by mysqld to determine the error messages to display for ...
https://dev.mysql.com/doc/refman/5.7/en/connection-control-plugin-variables.html
If an account has reached the point where connection responses are delayed, a delay also occurs for the next subsequent successful connection. For information about how connection_control_failed_connections_threshold interacts with other connection ... This section describes the system and status variables that the CONNECTION_CONTROL plugin provides to enable its operation to be configured and ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-type-conversion.html
For example, although DATE, DATETIME, and TIMESTAMP values all can be specified using the same set of formats, the types do not all have the same range of values. However, there may be some alteration of the value or loss of information. In all ...
https://dev.mysql.com/doc/refman/5.7/en/debugging-client.html
Before running a client, you should set the MYSQL_DEBUG environment variable: $> MYSQL_DEBUG=d:t:O,/tmp/client.trace $> export MYSQL_DEBUG This causes clients to generate a trace file in /tmp/client.trace. Do this by running mysql in debugging mode ... To be able to debug a MySQL client with the integrated debug package, you should configure MySQL with ...
https://dev.mysql.com/doc/refman/5.7/en/end-markers-in-json-system-variable.html
When reading a very large JSON document, it can be difficult to pair its closing bracket and opening brackets; setting end_markers_in_json=ON repeats the structure's key, if it has one, near the closing bracket. This variable affects both optimizer ...Note If end_markers_in_json is enabled, the repetition of the key means the result is not a valid JSON document, and causes JSON parsers to throw an ...
https://dev.mysql.com/doc/refman/5.7/en/execution-plan-information.html
The set of operations that the optimizer chooses to perform the most efficient query is called the “query execution plan”, also known as the EXPLAIN plan. Depending on the details of your tables, columns, indexes, and the conditions in your ...
https://dev.mysql.com/doc/refman/5.7/en/explain.html
For complex statements, the JSON output can be quite large; in particular, it can be difficult when reading it to pair the closing bracket and opening brackets; to cause the JSON structure's key, if it has one, to be repeated near the closing ...In ...The following discussion uses the DESCRIBE and EXPLAIN keywords in accordance with those uses, but the MySQL parser treats them as completely ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-search.html
For large data sets, it is much faster to load your data into a table that has no FULLTEXT index and then create the index after that, than to load data into a table that has an existing FULLTEXT index. MATCH (col1,col2,...) AGAINST (expr ...
https://dev.mysql.com/doc/refman/5.7/en/general-information-schema-tables.html
The following sections describe what may be denoted as the “general” set of INFORMATION_SCHEMA tables. These are the tables not associated with particular storage engines, components, or plugins.
https://dev.mysql.com/doc/refman/5.7/en/gis-class-point.html
A Point is a geometry that represents a single location in coordinate space. Point Examples Imagine a large-scale map of the world with many cities. On a city map, a Point object could represent a bus stop.