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/replication-mode-change-online-verify-transactions.html
There are several possible ways to wait for transactions to replicate: The simplest method, which works regardless of your topology but relies on timing is as follows: if you are sure that the replica never lags more than N seconds, just wait for a ... This section explains how to monitor a replication topology and verify that all anonymous transactions have been ...
https://dev.mysql.com/doc/refman/5.7/en/static-format.html
Of the three MyISAM storage formats, static format is the simplest and most secure (least subject to corruption). It is also the fastest of the on-disk formats due to the ease with which rows in the data file can be found on disk: To look up a row ...It is used when the table contains no variable-length columns (VARCHAR, VARBINARY, BLOB, or ...
https://dev.mysql.com/doc/refman/5.7/en/time.html
MySQL retrieves and displays TIME values in 'hh:mm:ss' format (or 'hhh:mm:ss' format for large hours values). MySQL recognizes TIME values in several formats, some of which can include a trailing fractional seconds part in up to microseconds (6 ...
https://dev.mysql.com/doc/refman/5.7/en/uninstall-plugin.html
It requires the DELETE privilege for the mysql.plugin system table because it removes the row from that table that registers the plugin. The server executes the plugin's deinitialization function and removes the row for the plugin from the ...
https://dev.mysql.com/doc/refman/5.7/en/mysqld-server.html
This setting modifies certain aspects of SQL syntax and semantics, for example for compatibility with code from other database systems, or to control the error handling for particular situations. There are performance and reliability considerations ...The following discussion covers these MySQL server configuration topics: Startup options that the server ...
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 ...