PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.7Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/spatial-geojson-functions.html
mysql> SELECT ST_AsGeoJSON(ST_GeomFromText('POINT(11.11111 12.22222)'),2); +-------------------------------------------------------------+ | ST_AsGeoJSON(ST_GeomFromText('POINT(11.11111 12.22222)'),2) | ... This section describes functions for ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-generated-columns.html
Generated column definitions have this syntax: col_name data_type [GENERATED ALWAYS] AS (expr) [VIRTUAL | STORED] [NOT NULL | NULL] [UNIQUE [KEY]] [[PRIMARY] KEY] [COMMENT 'string'] AS (expr) indicates that the column is generated and defines the ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-locks-table.html
LOCK_INDEX The name of the index, if LOCK_TYPE is RECORD; otherwise NULL. LOCK_SPACE The tablespace ID of the locked record, if LOCK_TYPE is RECORD; otherwise NULL. LOCK_PAGE The page number of the locked record, if LOCK_TYPE is RECORD; otherwise ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbd-definition.html
Data Memory, Index Memory, and String Memory DataMemory and IndexMemory are [ndbd] parameters specifying the size of memory segments used to store the actual records and their indexes. StringMemory Version (or later) NDB 7.5.0 Type or units % or ...
https://dev.mysql.com/doc/refman/5.7/en/creating-spatial-indexes.html
For InnoDB and MyISAM tables, MySQL can create spatial indexes using syntax similar to that for creating regular indexes, but using the SPATIAL keyword. For storage engines that support nonspatial indexing of spatial columns, the engine creates a ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-standard-monitor.html
The contents show which transactions are involved, the statement each was attempting to execute, the locks they have and need, and which transaction InnoDB decided to roll back to break the deadlock. The Lock Monitor is the same as the Standard ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-hash.html
Partitioning by HASH is used primarily to ensure an even distribution of data among a predetermined number of partitions. To partition a table using HASH partitioning, it is necessary to append to the CREATE TABLE statement a PARTITION BY HASH ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-waits-current-table.html
END_EVENT_ID This column is set to NULL when the event starts and updated to the thread current event number when the event ends. If an event is produced from an instrument that has TIMED = NO, timing information is not collected, and TIMER_START, ...The table stores one row per thread showing the current status of the thread's most recent monitored wait event, so there is no system variable for configuring the table ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-summary-tables.html
If no row has the statement digest value for the statement that just completed, and the table is full, the statistics for the statement that just completed are added to a special “catch-all” row with DIGEST = NULL, which is created if necessary.
https://dev.mysql.com/doc/refman/5.7/en/replace.html
REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] {VALUES | VALUE} (value_list) [, (value_list)] ... REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION ...