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/gis-class-multipolygon.html
A MultiPolygon is a MultiSurface object composed of Polygon elements. MultiPolygon Examples On a region map, a MultiPolygon could represent a system of lakes. MultiPolygon Assertions A MultiPolygon has no two Polygon elements with interiors that ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-backups-read-only.html
Note The instructions in this section place the server to be backed up in a state that is safe for backup methods that get the data from the server, such as mysqldump (see Section 4.5.4, “mysqldump — A Database Backup Program”). You should not ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-objects-table.html
This table has a maximum size of 100 rows by default. The order in which matching occurs matters because different matching setup_objects rows can have different ENABLED and TIMED values. For existing rows, only the ENABLED and TIMED columns can be ... The setup_objects table controls whether the Performance Schema monitors particular ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-limitations.html
When the DML operations are applied, it is possible to encounter a duplicate key entry error (ERROR 1062 (23000): Duplicate entry), even if the duplicate entry is only temporary and would be reverted by a later entry in the online log. An online DDL ... The following limitations apply to online DDL operations: The table is copied when creating an index on a TEMPORARY ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-mutex-instances-table.html
The work performed while holding a mutex is said to be in a “critical section,” and multiple queries do execute this critical section in a serialized way (one at a time), which is a potential bottleneck. The mutex_instances table lists all the ...The mutex_instances table has these columns: NAME The instrument name associated with the ...
https://dev.mysql.com/doc/refman/5.7/en/account-activity-auditing.html
Applications can use the following guidelines to perform SQL-based auditing that ties database activity to MySQL accounts. When a client connects successfully, the server authenticates the client to a particular row in this table. The User and Host ...
https://dev.mysql.com/doc/refman/5.7/en/flow-control-functions.html
The second syntax returns the result for the first condition that is true. If no comparison or condition is true, the result after ELSE is returned, or NULL if there is no ELSE part. Note The syntax of the CASE operator described here differs ...
https://dev.mysql.com/doc/refman/5.7/en/alter-database.html
Use UPGRADE DATA DIRECTORY NAME in this case to explicitly tell the server to re-encode the database directory name to the current encoding format: ALTER DATABASE `#mysql50#a-b-c` UPGRADE DATA DIRECTORY NAME; After executing this statement, you can ...ALTER {DATABASE | SCHEMA} db_name UPGRADE DATA DIRECTORY NAME alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name } ALTER DATABASE enables you to change the overall characteristics of a ...
https://dev.mysql.com/doc/refman/5.7/en/cache-index.html
A key cache must exist before you assign indexes to it, or an error occurs: mysql> CACHE INDEX t1 IN non_existent_cache; ERROR 1284 (HY000): Unknown key cache 'non_existent_cache' By default, table indexes are assigned to the main (default) key ...| ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statements-with-temp-tables.html
total_latency The total wait time of timed occurrences of the statement. last_seen The time at which the statement was most recently seen. These views list normalized statements that have used temporary tables. By default, rows are sorted by ...