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-gtids-concepts.html
A global transaction identifier (GTID) is a unique identifier created and associated with each transaction committed on the server of origin (the source). In addition, the table is compressed periodically at a user-configurable rate; see ...This ...
https://dev.mysql.com/doc/refman/5.7/en/drop-tablespace.html
DROP TABLESPACE tablespace_name [ENGINE [=] engine_name] This statement drops a tablespace that was previously created using CREATE TABLESPACE. If it is not the same as the storage engine used to create the tablespace, the DROP TABLESPACE statement ...It is supported with all MySQL NDB Cluster 7.5 releases, and with InnoDB in the standard MySQL Server as ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-search-mecab.html
Creating a FULLTEXT Index that uses the MeCab Parser To create a FULLTEXT index that uses the mecab parser, specify WITH PARSER ngram with CREATE TABLE, ALTER TABLE, or CREATE INDEX. For a stopword list applicable to Japanese, you must create your ... The built-in MySQL full-text parser uses the white space between words as a delimiter to determine where words begin and end, which is a limitation when working with ideographic languages that do not use word ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-search-ngram.html
Creating a FULLTEXT Index that Uses the ngram Parser To create a FULLTEXT index that uses the ngram parser, specify WITH PARSER ngram with CREATE TABLE, ALTER TABLE, or CREATE INDEX. The following example demonstrates creating a table with an ngram ... The built-in MySQL full-text parser uses the white space between words as a delimiter to determine where words begin and end, which is a limitation when working with ideographic languages that do not use word ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-stopwords.html
The following example demonstrates creating and configuring a new global stopword table for InnoDB. The stopword list is loaded and searched for full-text queries using the server character set and collation (the values of the character_set_server ...
https://dev.mysql.com/doc/refman/5.7/en/stored-objects.html
Stored objects include these object types: Stored procedure: An object created with CREATE PROCEDURE and invoked using the CALL statement. Stored function: An object created with CREATE FUNCTION and used much like a built-in function. Trigger: An ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-delimited-text.html
This section describes how to use mysqldump to create delimited-text dump files. The .sql file contains a CREATE TABLE statement for the table. The following command dumps the contents of the db1 database to files in the /tmp database: $> mysqldump ...For information about reloading such dump files, see Section 7.4.4, “Reloading Delimited-Text Format ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-transaction-tables.html
The cost of transaction instrumentation can be reduced various ways, such as enabling or disabling transaction instrumentation according to user, account, host, or thread (client connection). CREATE TABLE t2 (a INT) ENGINE = MyISAM; -- Transaction 1 ...Within the event hierarchy, wait events nest within stage events, which nest within statement events, which nest within transaction ...
https://dev.mysql.com/doc/refman/5.7/en/adding-character-set.html
The range of IDs from 1024 to 2047 is reserved for user-defined collations. For a simple character set, create a configuration file, MYSET.xml, that describes the character set properties. For a complex character set, create a C source file that ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-sets.html
For example, utf8_unicode_ci works fine for German dictionary order and French, so there is no need to create special utf8 collations. In Japan, since the supplementary characters are obscure Kanji ideographs, the typical user does not care what ...