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/spatial-geojson-functions.html
If not specified, this argument defaults to its maximum value of 232 − 1. Option Value Meaning 1 Reject the document and produce an error. If an object has a CRS that is not understood, an error occurs, with the exception that if the optional srid ... This section describes functions for converting between GeoJSON documents and spatial ...
https://dev.mysql.com/doc/refman/5.7/en/limit-optimization.html
MySQL sometimes optimizes a query that has a LIMIT row_count clause and no HAVING clause: If you select only a few rows with LIMIT, MySQL uses indexes in some cases when normally it would prefer to do a full table scan. If multiple rows have ... If ...
https://dev.mysql.com/doc/refman/5.7/en/optimizer-features-to-trace.html
Some features in the optimizer can be invoked many times during statement optimization and execution, and thus can make the trace grow beyond reason. Subqueries: A subquery in which the WHERE clause may be executed once per row. They are: Greedy ...
https://dev.mysql.com/doc/refman/5.7/en/replication-upgrade.html
If you use statement-based logging (binlog_format=STATEMENT), if a replica is upgraded before the source, the source executes statements which succeed there but which may fail on the replica and so cause replication to stop. To do this without ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-security-mysql-security-procedures.html
Without FLUSH PRIVILEGES, the changes do not take effect until the next time that the server is restarted. By default these are installed on Unix-style systems with the permissions wxr-xr-x (755), which means they can be executed by any user that ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlimport.html
If the file does not exist or is otherwise inaccessible, an error occurs. If the file does not exist or is otherwise inaccessible, an error occurs. If you do not specify either option, an error occurs when a duplicate key value is found, and the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-operations.html
A newly created secondary index contains only the committed data in the table at the time the CREATE INDEX or ALTER TABLE statement finishes executing. Online DDL support for adding secondary indexes means that you can generally speed the overall ...
https://dev.mysql.com/doc/refman/5.7/en/starting-server.html
(For Windows, see Section 2.3.4.5, “Starting the Server for the First Time”.) For some suggested commands that you can use to test whether the server is accessible and working properly, see Section 2.9.3, “Testing the Server”. Otherwise, you ... This section describes how start the server on Unix and Unix-like ...
https://dev.mysql.com/doc/refman/5.7/en/tracing-example.html
If a statement uses subqueries, there can be mutliple preparations, optimizations, and executions, as well as subquery-specific transformations. Now we can examine the trace, whose first column (QUERY), containing the original statement to be ...
https://dev.mysql.com/doc/refman/5.7/en/compiler-characteristics.html
In some cases, the compiler used to build MySQL affects the features available for use. The notes in this section apply for binary distributions provided by Oracle Corporation or that you compile yourself from source. icc (Intel C++ Compiler) ...