PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/help.html
HELP 'search_string' The HELP statement returns online information from the MySQL Reference Manual. The HELP statement searches the help tables for the given search string and displays the result of the search. The search string can contain the ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-geohash-functions.html
Geohash is a system for encoding latitude and longitude coordinates of arbitrary precision into a text string. Geohash values are strings that contain only characters chosen from "0123456789bcdefghjkmnpqrstuvwxyz". ST_GeoHash(longitude, latitude, ...The functions in this section enable manipulation of geohash values, which provides applications the capabilities of importing and exporting geohash data, and of indexing and searching geohash ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-what-is-new-7-6.html
When the primary key is extended with an additional column or columns, any columns added must be defined as NOT NULL, and no values in any such columns may be changed during the time that the backup is being taken. --remap-column takes as its ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-setup.html
get H VALUE H 0 22 HYDERABAD|TELANGANA|IN END Configuring the InnoDB memcached Plugin Traditional memcached configuration options may be specified in a MySQL configuration file or a mysqld startup string, encoded in the argument of the ... This ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-service.html
Syntax: my_bool my_key_fetch(const char *key_id, const char **key_type, const char* user_id, void **key, size_t *key_len) Arguments: key_id, user_id: Null-terminated strings that as a pair form a unique identifier indicating which key to fetch. The ...If there is no user context, this value can be ... MySQL Server supports a keyring service that enables internal server components and plugins to ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-replica.html
--replicate-do-db=db_name Command-Line Format --replicate-do-db=name Type String Creates a replication filter using the name of a database. --replicate-ignore-db=db_name Command-Line Format --replicate-ignore-db=name Type String Creates a ... This ...
https://dev.mysql.com/doc/refman/5.7/en/replication-administration-skip.html
If replication stops due to an issue with an event in a replicated transaction, you can resume replication by skipping the failed transaction on the replica. Before skipping a transaction, ensure that the replication I/O thread is stopped as well ...
https://dev.mysql.com/doc/refman/5.7/en/column-count-limit.html
mysql> CREATE TABLE t2 (c1 VARCHAR(65533) NOT NULL) ENGINE = InnoDB CHARACTER SET latin1; Query OK, 0 rows affected (0.01 sec) For MyISAM tables, NULL columns require additional space in the row to record whether their values are NULL. Each NULL ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-secondary-indexes.html
row *************************** id: 1 select_type: SIMPLE table: jemp partitions: NULL type: range possible_keys: i key: i key_len: 5 ref: NULL rows: 2 filtered: 100.00 Extra: Using where 1 row in set, 1 warning (0.00 sec) mysql> SHOW WARNINGS\G ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-quick-start.html
row *************************** Table: setup_consumers Create Table: CREATE TABLE `setup_consumers` ( `NAME` varchar(64) NOT NULL, `ENABLED` enum('YES','NO') NOT NULL ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 Table structure is also available ... This section briefly introduces the Performance Schema with examples that show how to use ...