PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/innodb-fulltext-index.html
When incoming documents are tokenized, the individual words (also referred to as “tokens”) are inserted into the index tables along with position information and an associated DOC_ID. The inverted index is partitioned into six auxiliary index ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-online-ddl-performance.html
Minimizing load helps maintain good performance and high throughput during the DDL operation. Online operations read less data into the buffer pool than table-copy operations, which reduces purging of frequently accessed data from memory. Online DDL ... Online DDL improves several aspects of MySQL operation: Applications that access the table are more responsive because queries and DML operations on the table can proceed while the DDL operation is in ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-table-import.html
The Transportable Tablespaces feature is described under the following topics in this section: Prerequisites Importing Tables Importing Partitioned Tables Importing Table Partitions Limitations Usage Notes Internals Prerequisites The ... This ...
https://dev.mysql.com/doc/refman/9.7/en/jdv-examples.html
CREATE TABLE customers ( customer_id INT PRIMARY KEY, name VARCHAR(100) ); CREATE TABLE orders ( order_id INT PRIMARY KEY, customer_id INT, product VARCHAR(100), amount DECIMAL(10,2), FOREIGN KEY (customer_id) REFERENCES customers(customer_id) ); ...
https://dev.mysql.com/doc/refman/9.7/en/json-duality-views-syntax.html
The CREATE JSON RELATIONAL DUALITY VIEW statement is an extension of the CREATE VIEW statement. There are some additional clauses with CREATE JSON RELATIONAL DUALITY VIEW, and some restrictions on the SELECT statement. The result set is structured ...
https://dev.mysql.com/doc/refman/9.7/en/merge-storage-engine.html
You can optionally specify an INSERT_METHOD option to control how inserts into the MERGE table take place. If you specify no INSERT_METHOD option or if you specify it with a value of NO, inserts into the MERGE table are not permitted and attempts to ... The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM tables that can be used as ...
https://dev.mysql.com/doc/refman/9.7/en/miscellaneous-functions.html
INET_ATON(expr) Given the dotted-quad representation of an IPv4 network address as a string, returns an integer that represents the numeric value of the address in network byte order (big endian). Note To store values generated by INET_ATON(), use ...The function return value and type are the same as the return value and type of its argument, but the function result is not checked for the ONLY_FULL_GROUP_BY SQL ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-limitations-transactions.html
NDBCLUSTER stores only part of a column value that uses any of MySQL's BLOB or TEXT data types in the table visible to MySQL; the remainder of the BLOB or TEXT is stored in a separate internal table that is not accessible to MySQL. Unique indexes ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndbd-definition.html
(NDB 9.7.0) A unique node ID is used as the node's address for all cluster internal messages. For data nodes, this is an integer in the range 1 to 144 inclusive. The NodeGroup parameter is chiefly intended for use in adding a new node group to a ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndbinfo-dict-obj-tree.html
This is intended primarily for use in testing, but can be useful in visualizing hierarchies of NDB database objects. The dict_obj_tree table provides a tree-based view of table information from the dict_obj_info table. This means that you must know ...