MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 491 to 500 of 502 total results

https://dev.mysql.com/doc/refman/5.7/en/spatial-geohash-functions.html

Geohash is a system for encoding latitude and longitude coordinates of arbitrary precision into a text string. mysql> SET @gh = ST_GeoHash(45,-20,10); mysql> SELECT ST_AsText(ST_PointFromGeoHash(@gh,0)); +---------------------------------------+ | ...Geohash values are strings that contain only characters chosen from ...

13.4.2.5 START SLAVE Statement

https://dev.mysql.com/doc/refman/5.7/en/start-slave.html

However, the replication receiver thread might not yet have connected to the source successfully, or an applier thread might stop when applying an event right after starting. However, it is sent in plain text over the connection to the replica ...

11.3 String Data Types

https://dev.mysql.com/doc/refman/5.7/en/string-types.html

The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. For information about storage requirements of the string data types, see Section 11.7, “Data Type Storage Requirements”. For descriptions of functions that ...

8.2.2.2 Optimizing Subqueries with Materialization

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 ...

26.4.5.14 The ps_thread_account() Function

https://dev.mysql.com/doc/refman/5.7/en/sys-ps-thread-account.html

Given a Performance Schema thread ID, returns the user_name@host_name account associated with the thread. Parameters in_thread_id BIGINT UNSIGNED: The thread ID for which to return the account. The value should match the THREAD_ID column from some ...

2.10.3 Changes in MySQL 5.7

https://dev.mysql.com/doc/refman/5.7/en/upgrading-from-previous-series.html

Implementation of the ONLY_FULL_GROUP_BY SQL mode has been made more sophisticated, to no longer reject deterministic queries that previously were rejected. In consequence, ONLY_FULL_GROUP_BY is now enabled by default, to prohibit nondeterministic ... Before upgrading to MySQL 5.7, review the changes described in this section to identify those that apply to your current MySQL installation and ...

5.8.1.6 Using Server Logs to Find Causes of Errors in mysqld

https://dev.mysql.com/doc/refman/5.7/en/using-log-files.html

If you find the text mysqld restarted in the error log (normally a file named host_name.err) you probably have found a query that causes mysqld to fail. Note that before starting mysqld with the general query log enabled, you should check all your ...

7.4 Using mysqldump for Backups

https://dev.mysql.com/doc/refman/5.7/en/using-mysqldump.html

The server writes one file as tab-delimited text, one line per table row. This section describes how to use mysqldump to produce dump files, and how to reload dump files. A dump file can be used in several ways: As a backup to enable data recovery ...

2.1.4.1 Verifying the MD5 Checksum

https://dev.mysql.com/doc/refman/5.7/en/verifying-md5-checksum.html

On Linux, it is part of the GNU Text Utilities package, which is available for a wide range of platforms. After you have downloaded a MySQL package, you should make sure that its MD5 checksum matches the one provided on the MySQL download pages.

23.5.2 View Processing Algorithms

https://dev.mysql.com/doc/refman/5.7/en/view-algorithms.html

For MERGE, the text of a statement that refers to the view and the view definition are merged such that parts of the view definition replace corresponding parts of the statement. The optional ALGORITHM clause for CREATE VIEW or ALTER VIEW is a ...

Displaying 491 to 500 of 502 total results