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/view-algorithms.html
The optional ALGORITHM clause for CREATE VIEW or ALTER VIEW is a MySQL extension to standard SQL. 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 ...It ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-single-primary-mode.html
In this mode the group has a single-primary server that is set to read-write mode. All the other members in the group are set to read-only mode (with super-read-only=ON ). The primary is typically the first server to bootstrap the group, all other ...Upon primary member failure, an automatic primary election mechanism chooses the new primary ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-page-compression.html
InnoDB supports page-level compression for tables that reside in file-per-table tablespaces. Supported Platforms Page compression requires sparse file and hole punching support. Hole Punch Size on Linux On Linux systems, the file system block size ...Page compression is enabled by specifying the COMPRESSION attribute with CREATE TABLE or ALTER ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-aws-plugin.html
For any other region, you must also set keyring_aws_region explicitly in my.cnf. The keyring_aws keyring plugin communicates with the Amazon Web Services Key Management Service (AWS KMS) as a back end for key generation and uses a local file for key ... Note The keyring_aws plugin is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/5.7/en/limit-optimization.html
If you need only a specified number of rows from a result set, use a LIMIT clause in the query, rather than fetching the whole result set and throwing away the extra data. If a filesort must be done, all rows that match the query without the LIMIT ...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 ...
https://dev.mysql.com/doc/refman/5.7/en/mathematical-functions.html
A warning is logged if you use this function when binlog_format is set to STATEMENT. mysql> SELECT ATAN(-2,2); -> -0.78539816339745 mysql> SELECT ATAN2(PI(),0); -> 1.5707963267949 CEIL(X) CEIL() is a synonym for CEILING(). mysql> SELECT ...ABS(X) ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-relation-functions-mbr.html
A corresponding set of MBR functions defined according to the OpenGIS specification is described later in this section. mysql> SET @g1 = ST_GeomFromText('Polygon((0 0,0 3,3 3,3 0,0 0))'); mysql> SET @g2 = ST_GeomFromText('Point(1 1)'); mysql> SELECT ... MySQL provides several MySQL-specific functions that test the relationship between minimum bounding rectangles (MBRs) of two geometries g1 and ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-key-cache.html
To minimize disk I/O, the MyISAM storage engine exploits a strategy that is used by many database management systems. It employs a cache mechanism to keep the most frequently accessed table blocks in memory: For index blocks, a special structure ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-limits.html
The maximum number of operations that can be performed per transaction is set using the configuration parameters MaxNoOfConcurrentOperations and MaxNoOfLocalOperations. Instead, the following rules hold true: A DELETE statement on an NDB table makes ... In this section, we list limits found in NDB Cluster that either differ from limits found in, or that are not found in, standard ...
https://dev.mysql.com/doc/refman/5.7/en/stored-objects.html
This chapter discusses stored database objects that are defined in terms of SQL code that is stored on the server for later execution. A procedure does not have a return value but can modify its parameters for later inspection by the caller. It can ...Stored objects include these object types: Stored procedure: An object created with CREATE PROCEDURE and invoked using the CALL ...