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/server-system-variable-reference.html
Please see the corresponding item descriptions for details on setting and using the variables. If a server option set on the command line or in an option file differs from the name of the corresponding system variable, the variable name is noted ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-function-reference.html
The following table lists each spatial function and provides a short description of each one.
https://dev.mysql.com/doc/refman/5.7/en/spatial-relation-functions.html
MySQL implements two sets of functions using function names defined by the OpenGIS specification. One set tests the relationship between two geometry values using precise object shapes, the other set uses object minimum bounding rectangles (MBRs).
https://dev.mysql.com/doc/refman/5.7/en/which-version.html
For example, distributions normally are compiled with support for all character sets. If you want a smaller MySQL server, you can recompile it with support for only the character sets you need. When preparing to install MySQL, decide which version ...First, decide whether to install a development release or a General Availability (GA) ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-problems.html
If you get a duplicate-key error when using ALTER TABLE to change the character set or collation of a character column, the cause is either that the new column collation maps two keys to the same value or that the table is corrupted. In the latter ...
https://dev.mysql.com/doc/refman/5.7/en/csv-storage-engine.html
When you create a CSV table, the server creates a table format file in the database directory. If you examine the test.CSV file in the database directory created by executing the preceding statements, its contents should look like this: "1","record ... The CSV storage engine stores data in text files using comma-separated values ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-index-cache-table.html
Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that contains the FULLTEXT index; for example test/articles. Before querying it, set the value of the ... The ...The ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-plugin-installation.html
Also, for general information about installing plugins, see Section 5.5.1, “Installing and Uninstalling Plugins”. keyring_encrypted_file: Stores keyring data in an encrypted, password-protected file local to the server host. keyring_okv: A KMIP ... Keyring service consumers require that a keyring plugin be ...
https://dev.mysql.com/doc/refman/5.7/en/tracing-example.html
Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G *************************** 1. Next, for every table in the query, we ...row ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-ndb-transid-mysql-connection-map-table.html
This information is used when populating the server_operations and server_transactions tables of the ndbinfo NDB Cluster information database. It is implemented as an INFORMATION_SCHEMA plugin; you can verify that it is supported by checking the ...