PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/innodb-limits.html
This section describes limits for InnoDB tables, indexes, tablespaces, and other aspects of the InnoDB storage engine. The index key prefix length limit is 3072 bytes for InnoDB tables that use DYNAMIC or COMPRESSED row format. The index key prefix ...
https://dev.mysql.com/doc/refman/9.7/en/insert.html
INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | VALUE} (value_list) [, (value_list)] ... | TABLE table_name | VALUES ...
https://dev.mysql.com/doc/refman/9.7/en/installing-source-distribution.html
To install MySQL from a standard source distribution: Verify that your system satisfies the tool requirements listed at Section 2.8.2, “Source Installation Prerequisites”. Obtain a distribution file using the instructions in Section 2.1.3, ...
https://dev.mysql.com/doc/refman/9.7/en/keyring-okv-plugin.html
Note The keyring_okv plugin is an extension included in MySQL Enterprise Edition, a commercial product. Important The keyring_okv keyring plugin is deprecated, and is being replaced by the Key Management Interoperability Protocol (KMIP) Keyring ...
https://dev.mysql.com/doc/refman/9.7/en/monitor-innodb-mutex-waits-performance-schema.html
A mutex is a synchronization mechanism used in the code to enforce that only one thread at a given time can have access to a common resource. When two or more threads executing in the server need to access the same resource, the threads compete ...
https://dev.mysql.com/doc/refman/9.7/en/myisam-storage-engine.html
MyISAM is based on the older (and no longer available) ISAM storage engine but has many useful extensions. Table 18.2 MyISAM Storage Engine Features Feature Support B-tree indexes Yes Backup/point-in-time recovery (Implemented in the server, rather ...
https://dev.mysql.com/doc/refman/9.7/en/myisampack.html
When the table is used later, the server reads into memory the information needed to decompress columns. This results in much better performance when accessing individual rows, because you only have to uncompress exactly one row. MySQL uses mmap() ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndb-innodb-engines.html
The NDB storage engine is implemented using a distributed, shared-nothing architecture, which causes it to behave differently from InnoDB in a number of ways. For those unaccustomed to working with NDB, unexpected behaviors can arise due to its ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndbinfo-cluster-operations.html
The cluster_operations table provides a per-operation (stateful primary key op) view of all activity in the NDB Cluster from the point of view of the local data management (LQH) blocks (see The DBLQH Block). (Currently, the MySQL Server does not ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndbinfo-operations-per-fragment.html
The operations_per_fragment table provides information about the operations performed on individual fragments and fragment replicas, as well as about some of the results from these operations. This currently has the following formats: Base table: ...