PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-create-table-external.html
CREATE TABLE t1 (c1 INT PRIMARY KEY) DATA DIRECTORY = '/external/directory'; The DATA DIRECTORY clause is supported for tables created in file-per-table tablespaces. mysql> CREATE TABLE t2 (c1 INT PRIMARY KEY) TABLESPACE = innodb_file_per_table DATA ... There are different reasons for creating InnoDB tables externally; that is, creating tables outside of the data ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/innodb-memcached-porting-mysql.html
If you are using lookup values that contain spaces, transform or hash them into values without spaces before using them as keys in calls to add(), set(), get(), and so on. If there is a short numeric primary key column in an InnoDB table, use it as ... Consider these aspects of memcached applications when adapting an existing MySQL schema or application to use the daemon_memcached plugin: memcached keys cannot contain spaces or newlines, because these characters are used as separators in the ASCII ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/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/8.0/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/8.0/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/8.0/en/mysql-cluster-ndbd-definition.html
(NDB 8.0.13) 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/8.0/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 ...